25 lines
1.5 KiB
Plaintext
25 lines
1.5 KiB
Plaintext
CREATE TABLE [dbo].[TestSetupROIs](
|
|
[TestSetupROIId] [bigint] IDENTITY(1,1) NOT NULL,
|
|
[TestSetupId] [int] NOT NULL,
|
|
[Suffix] [nvarchar](50) NOT NULL,
|
|
[ROIStart] [float] NOT NULL,
|
|
[ROIEnd] [float] NOT NULL,
|
|
[IsEnabled] [bit] NOT NULL,
|
|
[IsDefault] [bit] NOT NULL,
|
|
CONSTRAINT [PK_TestSetupROIs] PRIMARY KEY CLUSTERED
|
|
(
|
|
[TestSetupROIId] ASC
|
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
) ON [PRIMARY]
|
|
|
|
--GO
|
|
|
|
ALTER TABLE [dbo].[TestSetupROIs] WITH NOCHECK ADD CONSTRAINT [FK_TestSetupROIs_TestSetupId] FOREIGN KEY([TestSetupId])
|
|
REFERENCES [dbo].[TestSetups] ([TestSetupId])
|
|
--GO
|
|
|
|
ALTER TABLE [dbo].[TestSetupROIs] CHECK CONSTRAINT [FK_TestSetupROIs_TestSetupId]
|
|
--GO
|
|
|
|
|