개정판 417432b0
issue #1043 : 시스템분석/설계 ResistanceCoefficient 테이블 추가
Change-Id: Ic31ab03e049a1c31c85ba0361ec497a8cad3bc72
| HYTOS/HYTOS/Scripts/CreateTables.sql | ||
|---|---|---|
| 465 | 465 |
Schedule_UID |
| 466 | 466 |
) |
| 467 | 467 |
); |
| 468 |
|
|
| 469 |
CREATE TABLE ResistanceCoefficient ( |
|
| 470 |
UID TEXT NOT NULL, |
|
| 471 |
Method TEXT NOT NULL, |
|
| 472 |
Category TEXT NOT NULL, |
|
| 473 |
Type TEXT NOT NULL, |
|
| 474 |
K REAL NOT NULL, |
|
| 475 |
CONSTRAINT PK_ResistanceCoefficient PRIMARY KEY ( |
|
| 476 |
UID |
|
| 477 |
), |
|
| 478 |
CONSTRAINT UQ_ResistanceCoefficient UNIQUE ( |
|
| 479 |
Method, |
|
| 480 |
Category, |
|
| 481 |
Type |
|
| 482 |
) |
|
| 483 |
); |
|
내보내기 Unified diff
