25 lines
1.5 KiB
Transact-SQL
25 lines
1.5 KiB
Transact-SQL
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
|
||
|
||
|