1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
| USE [Ligne12]
GO
/****** Object: Table [dbo].[Location] Script Date: 11/21/2014 15:44:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Location](
[Location_ID] [int] IDENTITY(1,1) NOT NULL,
[Assembly_ID] [int] NOT NULL,
[Panel_ID] [int] NOT NULL,
[Board_ID] [int] NOT NULL,
[Result_ID] [int] NOT NULL,
[Inspection_end_time] [datetime] NOT NULL,
[Total_Features] [int] NOT NULL,
[Identifier1] [varchar](50) NOT NULL,
[Identifier2] [varchar](50) NULL,
[Identifier3] [varchar](50) NULL,
[Inspection_info1] [varchar](200) NULL,
[Inspection_info2] [varchar](200) NULL,
[Inspection_info3] [varchar](200) NULL,
[Image1] [nvarchar](250) NULL,
[Image2] [nvarchar](250) NULL,
[Attribute1] [int] NULL,
[Attribute2] [int] NULL,
[Min_Attribute2] [float] NULL DEFAULT ((-999999)),
[Max_Attribute2] [float] NULL DEFAULT ((-999999)),
[Tgt_Attribute2] [float] NULL DEFAULT ((-999999)),
[Attribute3] [int] NULL,
[Min_Attribute3] [float] NULL DEFAULT ((-999999)),
[Max_Attribute3] [float] NULL DEFAULT ((-999999)),
[Tgt_Attribute3] [float] NULL DEFAULT ((-999999)),
[Attribute4] [int] NULL,
[Min_Attribute4] [float] NULL DEFAULT ((-999999)),
[Max_Attribute4] [float] NULL DEFAULT ((-999999)),
[Tgt_Attribute4] [float] NULL DEFAULT ((-999999)),
[Measure1] [float] NULL,
[Min_Measure1] [float] NULL DEFAULT ((-999999)),
[Max_Measure1] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure1] [float] NULL DEFAULT ((-999999)),
[Measure2] [float] NULL,
[Min_Measure2] [float] NULL DEFAULT ((-999999)),
[Max_Measure2] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure2] [float] NULL DEFAULT ((-999999)),
[Measure3] [float] NULL,
[Min_Measure3] [float] NULL DEFAULT ((-999999)),
[Max_Measure3] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure3] [float] NULL DEFAULT ((-999999)),
[Measure4] [float] NULL,
[Min_Measure4] [float] NULL DEFAULT ((-999999)),
[Max_Measure4] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure4] [float] NULL DEFAULT ((-999999)),
[Measure5] [float] NULL,
[Min_Measure5] [float] NULL DEFAULT ((-999999)),
[Max_Measure5] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure5] [float] NULL DEFAULT ((-999999)),
[Measure6] [float] NULL,
[Min_Measure6] [float] NULL DEFAULT ((-999999)),
[Max_Measure6] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure6] [float] NULL DEFAULT ((-999999)),
[Measure7] [float] NULL,
[Min_Measure7] [float] NULL DEFAULT ((-999999)),
[Max_Measure7] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure7] [float] NULL DEFAULT ((-999999)),
[Measure8] [float] NULL,
[Min_Measure8] [float] NULL DEFAULT ((-999999)),
[Max_Measure8] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure8] [float] NULL DEFAULT ((-999999)),
[Measure9] [float] NULL,
[Min_Measure9] [float] NULL DEFAULT ((-999999)),
[Max_Measure9] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure9] [float] NULL DEFAULT ((-999999)),
[Measure10] [float] NULL,
[Min_Measure10] [float] NULL DEFAULT ((-999999)),
[Max_Measure10] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure10] [float] NULL DEFAULT ((-999999)),
[Measure11] [float] NULL,
[Min_Measure11] [float] NULL DEFAULT ((-999999)),
[Max_Measure11] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure11] [float] NULL DEFAULT ((-999999)),
[Measure12] [float] NULL,
[Min_Measure12] [float] NULL DEFAULT ((-999999)),
[Max_Measure12] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure12] [float] NULL DEFAULT ((-999999)),
[Measure13] [float] NULL,
[Min_Measure13] [float] NULL DEFAULT ((-999999)),
[Max_Measure13] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure13] [float] NULL DEFAULT ((-999999)),
[Measure14] [float] NULL,
[Min_Measure14] [float] NULL DEFAULT ((-999999)),
[Max_Measure14] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure14] [float] NULL DEFAULT ((-999999)),
[Measure15] [float] NULL,
[Min_Measure15] [float] NULL DEFAULT ((-999999)),
[Max_Measure15] [float] NULL DEFAULT ((-999999)),
[Tgt_Measure15] [float] NULL DEFAULT ((-999999)),
CONSTRAINT [PK_Location] PRIMARY KEY CLUSTERED
(
[Location_ID] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Location] WITH CHECK ADD CONSTRAINT [FK_Location_Board] FOREIGN KEY([Board_ID])
REFERENCES [dbo].[Board] ([Board_ID])
GO
ALTER TABLE [dbo].[Location] CHECK CONSTRAINT [FK_Location_Board]
GO
ALTER TABLE [dbo].[Location] WITH CHECK ADD CONSTRAINT [FK_Location_Panel] FOREIGN KEY([Panel_ID])
REFERENCES [dbo].[Panel] ([Panel_ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Location] CHECK CONSTRAINT [FK_Location_Panel]
GO
ALTER TABLE [dbo].[Location] WITH CHECK ADD CONSTRAINT [FK_Location_Result] FOREIGN KEY([Result_ID])
REFERENCES [dbo].[Result] ([Result_ID])
GO
ALTER TABLE [dbo].[Location] CHECK CONSTRAINT [FK_Location_Result]
GO
ALTER TABLE [dbo].[Location] WITH CHECK ADD CONSTRAINT [FK_Location_Run] FOREIGN KEY([Assembly_ID])
REFERENCES [dbo].[Run] ([Assembly_ID])
GO
ALTER TABLE [dbo].[Location] CHECK CONSTRAINT [FK_Location_Run] |
Partager