개정판 b6a3b4ea
issue #000: DB 변경
Change-Id: I392648e2cba9005e0b917e09b861e6993ec66699
| HYTOS/HYTOS/Scripts/DisplayNames.sql | ||
|---|---|---|
| 3 | 3 |
TABLE_NAME TEXT NOT NULL, |
| 4 | 4 |
COLUMN_NAME TEXT NOT NULL, |
| 5 | 5 |
DISPLAY_NAME TEXT, |
| 6 |
[Order] INTEGER NOT NULL, |
|
| 6 | 7 |
CONSTRAINT PK_DisplayNames PRIMARY KEY ( |
| 7 | 8 |
UID |
| 8 | 9 |
), |
| 9 | 10 |
CONSTRAINT UQ_DisplayNames UNIQUE ( |
| 10 | 11 |
TABLE_NAME, |
| 11 |
COLUMN_NAME |
|
| 12 |
COLUMN_NAME, |
|
| 13 |
[Order] |
|
| 12 | 14 |
) |
| 13 | 15 |
); |
| HYTOS/HYTOS/Scripts/HMB.sql | ||
|---|---|---|
| 2 | 2 |
UID TEXT NOT NULL, |
| 3 | 3 |
Components_UID TEXT NOT NULL, |
| 4 | 4 |
Stream_No INTEGER NOT NULL, |
| 5 |
Phase_Type TEXT NOT NULL, |
|
| 5 | 6 |
Flowrate_Mass REAL, |
| 6 | 7 |
Flowrate_Volume REAL, |
| 7 | 8 |
Density REAL, |
내보내기 Unified diff
