개정판 f3207ee3
issue #000: add hmb tables not hmd attribute(remain) add manual
Change-Id: I6391dd991967adcc061a1cc2ece427ab484dff45
| DTI_PID/DTI_PID/Scripts/MSSQL/ID2.sql | ||
|---|---|---|
| 3230 | 3230 |
[Priority] varchar ( 37 ), |
| 3231 | 3231 |
FOREIGN KEY(`Table_UID`) REFERENCES `InstTables`(`UID`), |
| 3232 | 3232 |
PRIMARY KEY(`UID`) |
| 3233 |
); |
|
| 3234 | ||
| 3235 |
CREATE TABLE IF NOT EXISTS Stream_No ( |
|
| 3236 |
[UID] VARCHAR(37), |
|
| 3237 |
[Stream_No] VARCHAR ( 100 ) NOT NULL, |
|
| 3238 |
[From] VARCHAR ( 100 ), |
|
| 3239 |
[To] VARCHAR ( 100 ), PRIMARY KEY(`UID`) |
|
| 3240 |
); |
|
| 3241 | ||
| 3242 |
CREATE TABLE IF NOT EXISTS HMB_From_To ( |
|
| 3243 |
[UID] VARCHAR ( 37 ), |
|
| 3244 |
[Drawing_UID] VARCHAR ( 37 ), |
|
| 3245 |
[From_Component_UID] VARCHAR ( 37 ), |
|
| 3246 |
[To_Component_UID] VARCHAR ( 37 ), |
|
| 3247 |
[Stream_No_UID] VARCHAR ( 37 ), |
|
| 3248 |
FOREIGN KEY([Stream_No_UID]) REFERENCES [Stream_No]([UID]), |
|
| 3249 |
FOREIGN KEY([From_Component_UID]) REFERENCES [Components]([UID]) ON DELETE CASCADE, |
|
| 3250 |
FOREIGN KEY([To_Component_UID]) REFERENCES [Components]([UID]) ON DELETE CASCADE, |
|
| 3251 |
FOREIGN KEY([Drawing_UID]) REFERENCES [Drawings]([UID]]) ON DELETE CASCADE |
|
| 3252 |
); |
|
| 3253 | ||
| 3254 |
CREATE TABLE IF NOT EXISTS HMB_LIST ( |
|
| 3255 |
[UID] VARCHAR ( 37 ), |
|
| 3256 |
[Name] VARCHAR ( 100 ) NOT NULL, |
|
| 3257 |
[Unit] VARCHAR ( 100 ), |
|
| 3258 |
[index] INTEGER NOT NULL, |
|
| 3259 |
PRIMARY KEY(`UID`) |
|
| 3233 | 3260 |
); |
| DTI_PID/DTI_PID/Scripts/SQLite_Project.tables.sql | ||
|---|---|---|
| 72 | 72 |
`Priority` varchar ( 37 ), |
| 73 | 73 |
FOREIGN KEY(`Table_UID`) REFERENCES `InstTables`(`UID`), |
| 74 | 74 |
PRIMARY KEY(`UID`) |
| 75 |
); |
|
| 76 | ||
| 77 |
CREATE TABLE IF NOT EXISTS `Stream_No` ( |
|
| 78 |
`UID` VARCHAR(37), |
|
| 79 |
`Stream_No` VARCHAR ( 100 ) NOT NULL, |
|
| 80 |
`From` VARCHAR ( 100 ), |
|
| 81 |
`To` VARCHAR ( 100 ), PRIMARY KEY(`UID`) |
|
| 82 |
); |
|
| 83 | ||
| 84 |
CREATE TABLE IF NOT EXISTS `HMB_From_To` ( |
|
| 85 |
`UID` VARCHAR ( 37 ), |
|
| 86 |
`Drawing_UID` VARCHAR ( 37 ), |
|
| 87 |
`From_Component_UID` VARCHAR ( 37 ), |
|
| 88 |
`To_Component_UID` VARCHAR ( 37 ), |
|
| 89 |
`Stream_No_UID` VARCHAR ( 37 ), |
|
| 90 |
FOREIGN KEY(`Stream_No_UID`) REFERENCES `Stream_No`(`UID`), |
|
| 91 |
FOREIGN KEY(`From_Component_UID`) REFERENCES `Components`(`UID`) ON DELETE CASCADE, |
|
| 92 |
FOREIGN KEY(`To_Component_UID`) REFERENCES `Components`(`UID`) ON DELETE CASCADE, |
|
| 93 |
FOREIGN KEY(`Drawing_UID`) REFERENCES `Drawings`(`UID`) ON DELETE CASCADE |
|
| 94 |
); |
|
| 95 | ||
| 96 |
CREATE TABLE IF NOT EXISTS "HMB_LIST" ( |
|
| 97 |
`UID` VARCHAR ( 37 ), |
|
| 98 |
`Name` VARCHAR ( 100 ) NOT NULL, |
|
| 99 |
`Unit` VARCHAR ( 100 ), |
|
| 100 |
`index` INTEGER NOT NULL, |
|
| 101 |
PRIMARY KEY(`UID`) |
|
| 75 | 102 |
); |
내보내기 Unified diff