개정판 aec60f68
issue #000 Scripts 수정
Change-Id: I5dc7214d9ead8b6681dc31a822bbdc632888039e
| HYTOS/HYTOS/Scripts/App.Configuration.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS Configuration ( |
| 2 |
"Section" TEXT NOT NULL, |
|
| 3 |
"Key" TEXT NOT NULL, |
|
| 4 |
Value TEXT, |
|
| 5 |
CONSTRAINT Configuration_PK PRIMARY KEY ("Section","Key")
|
|
| 2 |
Section TEXT NOT NULL, |
|
| 3 |
[Key] TEXT NOT NULL, |
|
| 4 |
Value TEXT, |
|
| 5 |
CONSTRAINT PK_Configuration PRIMARY KEY ( |
|
| 6 |
Section, |
|
| 7 |
[Key] |
|
| 8 |
) |
|
| 6 | 9 |
); |
| HYTOS/HYTOS/Scripts/App.Styles.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS Styles ( |
| 2 |
UID TEXT, |
|
| 3 |
Value TEXT, |
|
| 4 |
CONSTRAINT Styles_PK PRIMARY KEY (UID)
|
|
| 2 |
UID TEXT,
|
|
| 3 |
Value TEXT,
|
|
| 4 |
CONSTRAINT PK_Styles PRIMARY KEY (UID)
|
|
| 5 | 5 |
); |
| 6 | 6 |
CREATE UNIQUE INDEX IF NOT EXISTS Styles_Value_IDX ON Styles (Value); |
| HYTOS/HYTOS/Scripts/Components.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS Components ( |
| 2 |
UID TEXT PRIMARY KEY, |
|
| 3 |
Drawings_UID TEXT REFERENCES Drawings (UID) NOT NULL, |
|
| 4 |
Symbol_UID TEXT REFERENCES Symbol (UID) NOT NULL, |
|
| 5 |
X INTEGER, |
|
| 6 |
Y INTEGER, |
|
| 7 |
Width INTEGER, |
|
| 8 |
Height INTEGER, |
|
| 9 |
Rotation INTEGER |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Drawings_UID TEXT NOT NULL, |
|
| 4 |
Symbols_UID TEXT NOT NULL, |
|
| 5 |
Name TEXT, |
|
| 6 |
X REAL NOT NULL, |
|
| 7 |
Y REAL NOT NULL, |
|
| 8 |
Rotation REAL NOT NULL |
|
| 9 |
DEFAULT 0, |
|
| 10 |
Scale REAL NOT NULL |
|
| 11 |
DEFAULT 1, |
|
| 12 |
CONSTRAINT PK_Components PRIMARY KEY ( |
|
| 13 |
UID |
|
| 14 |
), |
|
| 15 |
CONSTRAINT FK_Drawings_UID FOREIGN KEY ( |
|
| 16 |
Drawings_UID |
|
| 17 |
) |
|
| 18 |
REFERENCES Drawings (UID), |
|
| 19 |
CONSTRAINT FK_Symbols_UID FOREIGN KEY ( |
|
| 20 |
Symbols_UID |
|
| 21 |
) |
|
| 22 |
REFERENCES Symbols (UID) |
|
| 10 | 23 |
); |
| HYTOS/HYTOS/Scripts/Configuration.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS Configuration ( |
| 2 |
"Section" TEXT NOT NULL, |
|
| 3 |
"Key" TEXT NOT NULL, |
|
| 4 |
Value TEXT, |
|
| 5 |
CONSTRAINT Configuration_PK PRIMARY KEY ("Section","Key")
|
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Section TEXT NOT NULL, |
|
| 4 |
[Key] TEXT NOT NULL, |
|
| 5 |
Value TEXT NOT NULL, |
|
| 6 |
CONSTRAINT PK_Configuration PRIMARY KEY ( |
|
| 7 |
UID |
|
| 8 |
), |
|
| 9 |
CONSTRAINT UQ_Configuration UNIQUE ( |
|
| 10 |
Section, |
|
| 11 |
[Key] |
|
| 12 |
) |
|
| 6 | 13 |
); |
| HYTOS/HYTOS/Scripts/Drawings.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS Drawings ( |
| 2 |
[UID] TEXT CONSTRAINT [FluidCode_PK] PRIMARY KEY NOT NULL, |
|
| 3 |
[NAME] TEXT NOT NULL, |
|
| 4 |
[DATETIME] TEXT |
|
| 5 |
); |
|
| 6 |
|
|
| 7 |
CREATE UNIQUE INDEX IF NOT EXISTS [DRAWINGS_NAME_IDX] ON [Drawings]([NAME]); |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
NAME TEXT NOT NULL, |
|
| 4 |
DATETIME TEXT NOT NULL, |
|
| 5 |
CONSTRAINT PK_Drawings PRIMARY KEY ( |
|
| 6 |
UID |
|
| 7 |
), |
|
| 8 |
CONSTRAINT UQ_Drawings UNIQUE ( |
|
| 9 |
NAME |
|
| 10 |
) |
|
| 11 |
); |
|
| HYTOS/HYTOS/Scripts/HMB.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS HMB ( |
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
DWG_NAME TEXT NOT NULL, |
|
| 4 |
NAME TEXT NOT NULL, |
|
| 5 |
UNIT TEXT, |
|
| 6 |
VALUE TEXT, |
|
| 7 |
CONSTRAINT HMB_PK PRIMARY KEY (UID) |
|
| 8 |
) ; |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Components_UID TEXT NOT NULL, |
|
| 4 |
Stream_No INTEGER NOT NULL, |
|
| 5 |
Flowrate_Mass REAL, |
|
| 6 |
Flowrate_Volume REAL, |
|
| 7 |
Density REAL, |
|
| 8 |
Viscosity REAL, |
|
| 9 |
Temperature REAL, |
|
| 10 |
Molecular_Weight REAL, |
|
| 11 |
Specific_Heat_Ratio REAL, |
|
| 12 |
Compress_Factor REAL, |
|
| 13 |
Nominal_Pipe_Size REAL, |
|
| 14 |
Inside_Pipe_Size REAL, |
|
| 15 |
Schedul_No TEXT, |
|
| 16 |
Straight_Length REAL, |
|
| 17 |
Equivalent_Length REAL, |
|
| 18 |
Roughness REAL, |
|
| 19 |
Limitation_Velocity REAL, |
|
| 20 |
Limitation_Pressure_Drop REAL, |
|
| 21 |
Velocity REAL, |
|
| 22 |
Reynolds REAL, |
|
| 23 |
Friction_Factor REAL, |
|
| 24 |
Pressure_Drop REAL, |
|
| 25 |
Pressure_Drop_Friction REAL, |
|
| 26 |
Pressure_Drop_Static REAL, |
|
| 27 |
Pressure_Pipe_End_Point REAL, |
|
| 28 |
Power REAL, |
|
| 29 |
CONSTRAINT PK_HMB PRIMARY KEY ( |
|
| 30 |
UID |
|
| 31 |
), |
|
| 32 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
|
| 33 |
Components_UID |
|
| 34 |
) |
|
| 35 |
REFERENCES Components (UID), |
|
| 36 |
CONSTRAINT UQ_HMB UNIQUE ( |
|
| 37 |
Components_UID, |
|
| 38 |
Stream_No |
|
| 39 |
) |
|
| 40 |
); |
|
| HYTOS/HYTOS/Scripts/Project.Projects.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS `Projects` (
|
|
| 2 |
`Id` INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
| 3 |
`Name` TEXT UNIQUE,
|
|
| 4 |
[Desc] TEXT,
|
|
| 5 |
`Path` TEXT NOT NULL,
|
|
| 6 |
`CreatedDate` TEXT,
|
|
| 7 |
`UpdatedDate` TEXT
|
|
| 8 |
); |
|
| 1 |
CREATE TABLE IF NOT EXISTS Projects (
|
|
| 2 |
Id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
| 3 |
Name TEXT UNIQUE,
|
|
| 4 |
[Desc] TEXT,
|
|
| 5 |
Path TEXT NOT NULL,
|
|
| 6 |
CreatedDate TEXT,
|
|
| 7 |
UpdatedDate TEXT
|
|
| 8 |
); |
|
| HYTOS/HYTOS/Scripts/SymbolType.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE IF NOT EXISTS SymbolType( |
| 2 |
`UID` INTEGER, |
|
| 3 |
`Category` TEXT ( 2000000000 ), |
|
| 4 |
`Type` TEXT ( 2000000000 ), |
|
| 5 |
PRIMARY KEY(`UID`) |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Category TEXT NOT NULL, |
|
| 4 |
Type TEXT NOT NULL, |
|
| 5 |
CONSTRAINT PK_SymbolType PRIMARY KEY ( |
|
| 6 |
UID |
|
| 7 |
), |
|
| 8 |
CONSTRAINT UQ_SymbolType UNIQUE ( |
|
| 9 |
Category, |
|
| 10 |
Type |
|
| 11 |
) |
|
| 6 | 12 |
); |
내보내기 Unified diff
