SQLQuery2.sql

CREATE TABLE[BPDataSequence]([BPDataID] INT IDENTITY(1,1) NOT NULL,[Raw_Data] VARBINARY(MAX) NULL,[Samplerate_hz] FLOAT NOT NULL,[Interval_sec] BIGINT NOT NULL,[NumberOfSequences] INT NOT NULL,[SequenceDuration_sec] REAL,[Data_Format] NVARCHAR(MAX) NOT NULL,[Bin_or_Text] CHAR(1) NOT NULL,[Measurement_Format_Type] NVARCHAR(MAX) NOT NULL,[ConversionConstant_mmhg/mV] REAL NOT NULL,[ZeroPoint_mmhg] REAL NOT NULL, [Transdusor_Identification] NVARCHAR(MAX) NOT NULL,[OperationID] BIGINT NOT NULL,CONSTRAINT pk_BPDataSequence PRIMARY KEY CLUSTERED (BPDataID), CONSTRAINT [fk_BPDataSequence] FOREIGN KEY ([OperationID]) REFERENCES [Operation] ([OperationID]) ON UPDATE CASCADE);