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];