개정판 74f746fc
issue #000 : 테이블 구조 변경
Change-Id: I348c7bd152afc1ffdf91208da7e22f42b4c0a65d
| HYTOS/HYTOS/Scripts/NominalDiameter.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS NominalDiameter ( |
| 2 | 2 |
UID TEXT NOT NULL, |
| 3 |
Code TEXT NOT NULL, |
|
| 4 |
Metric REAL, |
|
| 5 |
Inch REAL, |
|
| 6 |
MetricStr TEXT, |
|
| 7 |
InchStr TEXT, |
|
| 8 |
AllowableMetricStr TEXT, |
|
| 9 |
AllowableInchStr TEXT, |
|
| 3 |
Milimeter REAL NOT NULL, |
|
| 4 |
Inch REAL NOT NULL, |
|
| 10 | 5 |
CONSTRAINT PK_NominalDiameter PRIMARY KEY ( |
| 11 | 6 |
UID |
| 12 | 7 |
) |
| HYTOS/HYTOS/Scripts/Roughness.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS Roughness ( |
| 2 | 2 |
UID TEXT NOT NULL, |
| 3 | 3 |
Material TEXT NOT NULL, |
| 4 |
Roughness REAL NOT NULL, |
|
| 4 |
Meter REAL NOT NULL, |
|
| 5 |
Inch REAL NOT NULL, |
|
| 6 |
Feet REAL NOT NULL, |
|
| 7 |
Milimeter REAL NOT NULL, |
|
| 5 | 8 |
CONSTRAINT PK_Roughness PRIMARY KEY ( |
| 6 | 9 |
UID |
| 7 | 10 |
), |
내보내기 Unified diff
