개정판 340d0023
issue #1043 : 시스템분석/설계 : Template.db 파일에 DrawingsUnits 테이블 삭제
Change-Id: Ie2208d88aad9e52506973f091a686f298b1459ff
| HYTOS/HYTOS/Scripts/CreateTables.sql | ||
|---|---|---|
| 16 | 16 |
); |
| 17 | 17 |
|
| 18 | 18 |
CREATE TABLE IF NOT EXISTS Configuration ( |
| 19 |
UID TEXT NOT NULL, |
|
| 20 | 19 |
Section TEXT NOT NULL, |
| 21 | 20 |
[Key] TEXT NOT NULL, |
| 22 |
Value TEXT NOT NULL, |
|
| 23 |
CONSTRAINT PK_Configuration PRIMARY KEY ( |
|
| 24 |
UID |
|
| 25 |
), |
|
| 21 |
Value TEXT NOT NULL, |
|
| 26 | 22 |
CONSTRAINT UQ_Configuration UNIQUE ( |
| 27 | 23 |
Section, |
| 28 | 24 |
[Key] |
| ... | ... | |
| 46 | 42 |
); |
| 47 | 43 |
|
| 48 | 44 |
|
| 49 |
CREATE TABLE IF NOT EXISTS DrawingsUnits ( |
|
| 50 |
UID TEXT NOT NULL, |
|
| 51 |
Units TEXT NOT NULL, |
|
| 52 |
Units_UID TEXT NOT NULL, |
|
| 53 |
CONSTRAINT PK_DrawingsUnits PRIMARY KEY ( |
|
| 54 |
UID |
|
| 55 |
), |
|
| 56 |
CONSTRAINT FK_Units_UID FOREIGN KEY ( |
|
| 57 |
Units_UID |
|
| 58 |
) |
|
| 59 |
REFERENCES Units (UID) |
|
| 60 |
); |
|
| 61 |
|
|
| 62 |
|
|
| 63 | 45 |
CREATE TABLE IF NOT EXISTS Fittings_2K ( |
| 64 | 46 |
UID TEXT NOT NULL, |
| 65 | 47 |
Components_UID TEXT NOT NULL, |
내보내기 Unified diff
