32 lines
1.2 KiB
Plaintext
32 lines
1.2 KiB
Plaintext
CREATE TABLE [dbo].[SensorTestHistory](
|
|
[SensorTestHistoryId] [bigint] IDENTITY(1,1) NOT NULL,
|
|
[TestHistoryId] [bigint] NOT NULL,
|
|
[SensorId] [int] NULL,
|
|
[SerialNumber] [nvarchar](max) NOT NULL,
|
|
[Capacity] [float] NULL,
|
|
[Range] [float] NULL,
|
|
[CalibrationDate] [datetime] NULL,
|
|
[HardwareChannelName] [nvarchar](max) NULL,
|
|
[ISOChannelName] [nvarchar](max) NULL,
|
|
[ISOCode] [nvarchar](50) NULL,
|
|
[UserChannelName] [nvarchar](max) NULL,
|
|
[UserCode] [nvarchar](50) NULL,
|
|
[Sensitivity] [nvarchar](max) NULL,
|
|
[FilterClass] [nvarchar](50) NULL,
|
|
[IsProportional] [bit] NULL,
|
|
[LinearizationFormula] [nvarchar](max) NULL,
|
|
[EID] [nvarchar](50) NULL,
|
|
[MeasuredExcitation] [decimal](18, 0) NULL,
|
|
[MeasurementUnit] [nvarchar](max) NULL,
|
|
[SamplesPerSecond] [int] NULL,
|
|
[AAF] [int] NULL,
|
|
CONSTRAINT [PK_SensorTestHistory] PRIMARY KEY CLUSTERED
|
|
(
|
|
[SensorTestHistoryId] ASC
|
|
)
|
|
);
|
|
|
|
ALTER TABLE [dbo].[SensorTestHistory] WITH CHECK ADD CONSTRAINT [FK_SensorTestHistory_TestHistory] FOREIGN KEY([TestHistoryId])
|
|
REFERENCES [dbo].[TestHistory] ([TestHistoryId]);
|
|
|
|
ALTER TABLE [dbo].[SensorTestHistory] CHECK CONSTRAINT [FK_SensorTestHistory_TestHistory]; |