개정판 c7df4619
issue #000 CreateTables.sql
1. PAPUploadInformation,PAPUploadInformationItem 테이블 생성구문 추가.
Change-Id: I0738cac6dd953d4e33cdd3e4b2910b366219ded3
| HYTOS/HYTOS/Scripts/CreateTables.sql | ||
|---|---|---|
| 353 | 353 |
) |
| 354 | 354 |
REFERENCES Components (UID) ON DELETE CASCADE |
| 355 | 355 |
); |
| 356 |
|
|
| 357 |
CREATE TABLE IF NOT EXISTS PAPUploadInformation ( |
|
| 358 |
Project_UID TEXT NOT NULL, |
|
| 359 |
ProjectNo TEXT, |
|
| 360 |
CalculationCase TEXT, |
|
| 361 |
CreateDateTime datetime NOT NULL DEFAULT (datetime('now', 'localtime')),
|
|
| 362 |
PRIMARY KEY(Project_UID) |
|
| 363 |
); |
|
| 364 |
|
|
| 365 |
CREATE TABLE IF NOT EXISTS PAPUploadInformationItem ( |
|
| 366 |
Components_UID TEXT NOT NULL, |
|
| 367 |
Project_UID TEXT NOT NULL, |
|
| 368 |
ProjectNo TEXT, |
|
| 369 |
Components_Type TEXT, |
|
| 370 |
Components_ItemNo TEXT, |
|
| 371 |
Components_DataCase TEXT, |
|
| 372 |
PRIMARY KEY(Components_UID, Project_UID) |
|
| 373 |
); |
|
내보내기 Unified diff
