개정판 28bdc4cc
issue #000 Scripts 정리
Change-Id: Ic43f2a1e68a6af99e049c105c93a701c72a5efd1
| HYTOS/HYTOS/Scripts/Attributes.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Attributes ( |
|
| 2 |
UID TEXT PRIMARY KEY, |
|
| 3 |
Components_UID TEXT NOT NULL REFERENCES Components (UID), |
|
| 4 |
SymbolAttribute_UID TEXT NOT NULL REFERENCES SymbolAttribute (UID), |
|
| 5 |
Value TEXT, |
|
| 6 |
FOREIGN KEY (SymbolAttribute_UID) REFERENCES SymbolAttribute (UID), |
|
| 7 |
UNIQUE (Components_UID, SymbolAttribute_UID) |
|
| 8 |
); |
|
| 9 |
|
|
| 10 |
|
|
| HYTOS/HYTOS/Scripts/Colors.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Colors ( |
|
| 2 |
UID INTEGER NOT NULL, |
|
| 3 |
RED INTEGER, |
|
| 4 |
GREEN INTEGER, |
|
| 5 |
BLUE INTEGER, |
|
| 6 |
PROPERTY TEXT, |
|
| 7 |
VALUE TEXT, |
|
| 8 |
CONSTRAINT Colors_PK PRIMARY KEY (UID) |
|
| 9 |
); |
|
| HYTOS/HYTOS/Scripts/DisplayNames.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS DisplayNames ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
TABLE_NAME TEXT NOT NULL, |
|
| 4 |
COLUMN_NAME TEXT NOT NULL, |
|
| 5 |
DISPLAY_NAME TEXT, |
|
| 6 |
CONSTRAINT PK_DisplayNames PRIMARY KEY ( |
|
| 7 |
UID |
|
| 8 |
), |
|
| 9 |
CONSTRAINT UQ_DisplayNames UNIQUE ( |
|
| 10 |
TABLE_NAME, |
|
| 11 |
COLUMN_NAME |
|
| 12 |
) |
|
| 13 |
); |
|
| HYTOS/HYTOS/Scripts/DrawingsUnits.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS DrawingsUnits ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Drawings_UID TEXT NOT NULL, |
|
| 4 |
Table_Name TEXT NOT NULL, |
|
| 5 |
Column_Name TEXT NOT NULL, |
|
| 6 |
Units_UID TEXT NOT NULL, |
|
| 7 |
CONSTRAINT PK_DrawingsUnits PRIMARY KEY ( |
|
| 8 |
UID |
|
| 9 |
), |
|
| 10 |
CONSTRAINT FK_Drawings_UID FOREIGN KEY ( |
|
| 11 |
Drawings_UID |
|
| 12 |
) |
|
| 13 |
REFERENCES Drawings (UID), |
|
| 14 |
CONSTRAINT FK_Units_UID FOREIGN KEY ( |
|
| 15 |
Units_UID |
|
| 16 |
) |
|
| 17 |
REFERENCES Units (UID) |
|
| 18 |
); |
|
| HYTOS/HYTOS/Scripts/EQUIPMENT_DATA_LIST.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS EQUIPMENT_DATA_LIST ( |
|
| 2 |
UID TEXT, |
|
| 3 |
ITEM_NO TEXT, |
|
| 4 |
SERVICE TEXT, |
|
| 5 |
NO_REQ TEXT, |
|
| 6 |
FLUID TEXT, |
|
| 7 |
DESC_OF_PART TEXT, |
|
| 8 |
OPERATION_CONDITION_TEMP TEXT, |
|
| 9 |
OPERATION_CONDITION_PRESS TEXT, |
|
| 10 |
DESIGN_CONDITION_TEMP TEXT, |
|
| 11 |
DESIGN_CONDITION_PRESS TEXT, |
|
| 12 |
MATERIAL TEXT, |
|
| 13 |
WEIGHT TEXT, |
|
| 14 |
POWER TEXT, |
|
| 15 |
INSULATION TEXT, |
|
| 16 |
PNID_NO TEXT, |
|
| 17 |
REV TEXT, |
|
| 18 |
CONSTRAINT EQUIPMENT_DATA_LIST_PK PRIMARY KEY (UID) |
|
| 19 |
); |
|
| 20 |
CREATE UNIQUE INDEX IF NOT EXISTS EQUIPMENT_DATA_LIST_TAG_NO_IDX ON EQUIPMENT_DATA_LIST (UID); |
|
| HYTOS/HYTOS/Scripts/EqpTagNames.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [EqpTagNames]( |
|
| 2 |
[UID] TEXT CONSTRAINT [EqpTagNames_PK] PRIMARY KEY NOT NULL, |
|
| 3 |
[Code] TEXT NOT NULL UNIQUE, |
|
| 4 |
[Description] TEXT, |
|
| 5 |
[Allowables] TEXT); |
|
| 6 |
|
|
| 7 |
CREATE UNIQUE INDEX IF NOT EXISTS [EqpTagNames_Code_IDX] ON [EqpTagNames]([Code]); |
|
| HYTOS/HYTOS/Scripts/Fittings_2K.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Fittings_2K ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Components_UID TEXT NOT NULL, |
|
| 4 |
[90_Elbow_Standard_Screw] INTEGER, |
|
| 5 |
[90_Elbow_Standard_Flange_Weld] INTEGER, |
|
| 6 |
[90_Elbow_Long_Radius_All] INTEGER, |
|
| 7 |
[90_Elbow_1_Weld] INTEGER, |
|
| 8 |
[90_Elbow_2_Weld] INTEGER, |
|
| 9 |
[90_Elbow_3_Weld] INTEGER, |
|
| 10 |
[90_Elbow_4_Weld] INTEGER, |
|
| 11 |
[90_Elbow_5_Weld] INTEGER, |
|
| 12 |
[45_Elbow_Standard_All] INTEGER, |
|
| 13 |
[45_Elbow_Long_Radius_All] INTEGER, |
|
| 14 |
[45_Elbow_1_Weld] INTEGER, |
|
| 15 |
[45_Elbow_2_Weld] INTEGER, |
|
| 16 |
[180_Elbow_Standard_Screw] INTEGER, |
|
| 17 |
[180_Elbow_Standard_Flange_Weld] INTEGER, |
|
| 18 |
[180_Elbow_Long_Radius_All] INTEGER, |
|
| 19 |
Tee_Elbow_Standard_Screw INTEGER, |
|
| 20 |
Tee_Elbow_Long_Radius_Screw INTEGER, |
|
| 21 |
Tee_Elbow_Standard_Flange_Weld INTEGER, |
|
| 22 |
Tee_Elbow_Stub_In_Branch INTEGER, |
|
| 23 |
Tee_Through_Screw INTEGER, |
|
| 24 |
Tee_Through_Flange_Weld INTEGER, |
|
| 25 |
Tee_Through_Stub_In_Branch INTEGER, |
|
| 26 |
Gate_Ball_Plug_Valve_Full INTEGER, |
|
| 27 |
[Gate_Ball_Plug_Valve_Reduce_Trim_0.9] INTEGER, |
|
| 28 |
[Gate_Ball_Plug_Valve_Reduce_Trim_0.8] INTEGER, |
|
| 29 |
Globe_Valve_Standard INTEGER, |
|
| 30 |
Globe_Valve_Angle_YType INTEGER, |
|
| 31 |
Diaphragm_Dam_Valve INTEGER, |
|
| 32 |
Butterfly_Valve INTEGER, |
|
| 33 |
Check_Valve_Lift INTEGER, |
|
| 34 |
Check_Valve_Swing INTEGER, |
|
| 35 |
Check_Valve_Tilting INTEGER, |
|
| 36 |
Pipe_Entrance_Normal INTEGER, |
|
| 37 |
Pipe_Entrance_Borda_Count INTEGER, |
|
| 38 |
Pipe_Exit INTEGER, |
|
| 39 |
Resistance_Coefficiency REAL, |
|
| 40 |
Calculated_Fitting REAL, |
|
| 41 |
CONSTRAINT PK_Fittings_2K PRIMARY KEY ( |
|
| 42 |
UID |
|
| 43 |
), |
|
| 44 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
|
| 45 |
Components_UID |
|
| 46 |
) |
|
| 47 |
REFERENCES Components (UID) |
|
| 48 |
); |
|
| HYTOS/HYTOS/Scripts/Fittings_CraneK.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Fittings_CraneK ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Components_UID TEXT NOT NULL, |
|
| 4 |
[90_Elbow_Standard_Screw] INTEGER, |
|
| 5 |
[90_Elbow_Long_Radius_1] INTEGER, |
|
| 6 |
[90_Elbow_Long_Radius_1.5] INTEGER, |
|
| 7 |
[90_Elbow_Long_Radius_2] INTEGER, |
|
| 8 |
[90_Elbow_Long_Radius_3] INTEGER, |
|
| 9 |
[90_Elbow_Long_Radius_4] INTEGER, |
|
| 10 |
[90_Elbow_Long_Radius_6] INTEGER, |
|
| 11 |
[90_Elbow_Long_Radius_8] INTEGER, |
|
| 12 |
[90_Elbow_Long_Radius_10] INTEGER, |
|
| 13 |
[90_Elbow_Long_Radius_12] INTEGER, |
|
| 14 |
[90_Elbow_Long_Radius_14] INTEGER, |
|
| 15 |
[90_Elbow_Long_Radius_16] INTEGER, |
|
| 16 |
[90_Elbow_Long_Radius_20] INTEGER, |
|
| 17 |
[90_Elbow_1_Weld] INTEGER, |
|
| 18 |
[90_Elbow_2_Weld] INTEGER, |
|
| 19 |
[90_Elbow_3_Weld] INTEGER, |
|
| 20 |
[90_Elbow_6_Weld] INTEGER, |
|
| 21 |
[45_Elbow_Standard_Screw] INTEGER, |
|
| 22 |
[45_Elbow_1_Weld] INTEGER, |
|
| 23 |
[45_Elbow_3_Weld] INTEGER, |
|
| 24 |
[180_Elbow_Standard_Screw] INTEGER, |
|
| 25 |
[180_Elbow_Long_Radius_1] INTEGER, |
|
| 26 |
[180_Elbow_Long_Radius_1.5] INTEGER, |
|
| 27 |
[180_Elbow_Long_Radius_2] INTEGER, |
|
| 28 |
[180_Elbow_Long_Radius_3] INTEGER, |
|
| 29 |
[180_Elbow_Long_Radius_4] INTEGER, |
|
| 30 |
[180_Elbow_Long_Radius_6] INTEGER, |
|
| 31 |
[180_Elbow_Long_Radius_8] INTEGER, |
|
| 32 |
[180_Elbow_Long_Radius_10] INTEGER, |
|
| 33 |
[180_Elbow_Long_Radius_12] INTEGER, |
|
| 34 |
[180_Elbow_Long_Radius_14] INTEGER, |
|
| 35 |
[180_Elbow_Long_Radius_16] INTEGER, |
|
| 36 |
[180_Elbow_Long_Radius_20] INTEGER, |
|
| 37 |
[180_Elbow_2_Weld] INTEGER, |
|
| 38 |
[180_Elbow_3_Weld] INTEGER, |
|
| 39 |
[180_Elbow_4_Weld] INTEGER, |
|
| 40 |
[180_Elbow_6_Weld] INTEGER, |
|
| 41 |
[180_Elbow_12_Weld] INTEGER, |
|
| 42 |
Tee_Through INTEGER, |
|
| 43 |
Tee_Elbow INTEGER, |
|
| 44 |
Expander INTEGER, |
|
| 45 |
Reducer INTEGER, |
|
| 46 |
Globe_Valve_Standard INTEGER, |
|
| 47 |
Globe_Valve_45_Angle INTEGER, |
|
| 48 |
Globe_Valve_90_Angle INTEGER, |
|
| 49 |
Plug_Valve_1_Way INTEGER, |
|
| 50 |
Plug_Valve_3_Way_Through INTEGER, |
|
| 51 |
Plug_Valve_3_Way_Elbow INTEGER, |
|
| 52 |
Foot_Valve_Poppet_Disc INTEGER, |
|
| 53 |
Foot_Valve_Hinged_Disc INTEGER, |
|
| 54 |
Gate_Valve INTEGER, |
|
| 55 |
Ball_Valve INTEGER, |
|
| 56 |
Butterfly_Valve INTEGER, |
|
| 57 |
Pipe_Enterance_Projecting INTEGER, |
|
| 58 |
[Pipe_Enterance_Flush_0.00] INTEGER, |
|
| 59 |
[Pipe_Enterance_Flush_0.02] INTEGER, |
|
| 60 |
[Pipe_Enterance_Flush_0.04] INTEGER, |
|
| 61 |
[Pipe_Enterance_Flush_0.06] INTEGER, |
|
| 62 |
[Pipe_Enterance_Flush_0.10] INTEGER, |
|
| 63 |
[Pipe_Enterance_Flush_0.15] INTEGER, |
|
| 64 |
Pipe_Exit_Projecting INTEGER, |
|
| 65 |
Pipe_Exit_Sharp_Edged INTEGER, |
|
| 66 |
Pipe_Exit_Rounded INTEGER, |
|
| 67 |
Check_Valve_Swing_Vertical INTEGER, |
|
| 68 |
Check_Valve_Swing_Angled INTEGER, |
|
| 69 |
Check_Valve_Lift_Straight INTEGER, |
|
| 70 |
Check_Valve_Lift_Angled INTEGER, |
|
| 71 |
[Check_Valve_Tilting_Alpha_5] INTEGER, |
|
| 72 |
[Check_Valve_Tilting_Alpha_15] INTEGER, |
|
| 73 |
Check_Valve_Globe_Stop INTEGER, |
|
| 74 |
Check_Valve_Globe_Stop_45_Angle INTEGER, |
|
| 75 |
Check_Valve_Globe_Stop_Inline INTEGER, |
|
| 76 |
Check_Valve_Angled_Stop INTEGER, |
|
| 77 |
Check_Valve_Angled_Stop_45_Angle INTEGER, |
|
| 78 |
Check_Valve_Angled_Stop_Inline INTEGER, |
|
| 79 |
User_Input INTEGER, |
|
| 80 |
Resistance_Coefficiency REAL, |
|
| 81 |
Calculated_Fitting REAL, |
|
| 82 |
CONSTRAINT PK_Fittings_CraneK PRIMARY KEY ( |
|
| 83 |
UID |
|
| 84 |
), |
|
| 85 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
|
| 86 |
Components_UID |
|
| 87 |
) |
|
| 88 |
REFERENCES Components (UID) |
|
| 89 |
); |
|
| HYTOS/HYTOS/Scripts/Fittings_EquivalentLength.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Fittings_EquivalentLength ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Components_UID TEXT NOT NULL, |
|
| 4 |
Gate_Ball_Plug_Valve INTEGER, |
|
| 5 |
Globe_Valve INTEGER, |
|
| 6 |
Butterfly_Valve INTEGER, |
|
| 7 |
Check_Valve INTEGER, |
|
| 8 |
[90_Elbow] INTEGER, |
|
| 9 |
[45_Elbo] INTEGER, |
|
| 10 |
Tee_Branch INTEGER, |
|
| 11 |
Tee_Through INTEGER, |
|
| 12 |
Milter INTEGER, |
|
| 13 |
Milter_Degree INTEGER, |
|
| 14 |
Nozzle_In_YN BOOLEAN, |
|
| 15 |
Nozzle_Out_YN BOOLEAN, |
|
| 16 |
Calculated_Fitting REAL, |
|
| 17 |
CONSTRAINT PK_Fittings_EquivalentLength PRIMARY KEY ( |
|
| 18 |
UID |
|
| 19 |
), |
|
| 20 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
|
| 21 |
Components_UID |
|
| 22 |
) |
|
| 23 |
REFERENCES Components (UID) |
|
| 24 |
); |
|
| HYTOS/HYTOS/Scripts/FluidCode.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [FluidCode]( |
|
| 2 |
`UID` TEXT NOT NULL, |
|
| 3 |
`CODE` TEXT NOT NULL, |
|
| 4 |
`DESCRIPTION` TEXT, |
|
| 5 |
`Allowables` TEXT, |
|
| 6 |
CONSTRAINT `FluidCode_PK` PRIMARY KEY(`UID`) |
|
| 7 |
); |
|
| HYTOS/HYTOS/Scripts/INSTRUMENT_DATA_LIST.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS INSTRUMENT_DATA_LIST ( |
|
| 2 |
UID TEXT, |
|
| 3 |
ITEM_NO TEXT, |
|
| 4 |
SERVICE TEXT, |
|
| 5 |
FLOW_RATE TEXT, |
|
| 6 |
PRESSURE TEXT, |
|
| 7 |
TEMPERATURE TEXT, |
|
| 8 |
TYPE TEXT, |
|
| 9 |
RANGE TEXT, |
|
| 10 |
NOR_LEVEL_MM TEXT, |
|
| 11 |
NOR_LEVEL_PERCENT TEXT, |
|
| 12 |
DEL_PRESS TEXT, |
|
| 13 |
SHUT_OFF TEXT, |
|
| 14 |
LOCATION TEXT, |
|
| 15 |
PNID_NO TEXT, |
|
| 16 |
REV TEXT, |
|
| 17 |
CONSTRAINT EQUIPMENT_DATA_LIST_PK PRIMARY KEY (UID) |
|
| 18 |
); |
|
| 19 |
CREATE UNIQUE INDEX IF NOT EXISTS INSTRUMENT_DATA_LIST_TAG_NO_IDX ON INSTRUMENT_DATA_LIST (UID); |
|
| HYTOS/HYTOS/Scripts/InsulationPurpose.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [InsulationPurpose]( |
|
| 2 |
`UID` TEXT NOT NULL, |
|
| 3 |
`CODE` TEXT NOT NULL UNIQUE, |
|
| 4 |
`DESCRIPTION` TEXT, |
|
| 5 |
`Allowables` TEXT, |
|
| 6 |
CONSTRAINT `InsulationPurpose_PK` PRIMARY KEY(`UID`) |
|
| 7 |
); |
|
| 8 |
|
|
| 9 |
CREATE UNIQUE INDEX IF NOT EXISTS [InsulationPurpose_CODE_IDX] ON [InsulationPurpose]([CODE]); |
|
| HYTOS/HYTOS/Scripts/LINE_DATA_LIST.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS LINE_DATA_LIST ( |
|
| 2 |
UID TEXT, |
|
| 3 |
LINE_SIZE TEXT, |
|
| 4 |
LINE_SYMBOL TEXT, |
|
| 5 |
LINE_NO TEXT, |
|
| 6 |
LINE_CLASS TEXT, |
|
| 7 |
LINE_ROUTING_FROM TEXT, |
|
| 8 |
LINE_ROUTING_TO TEXT, |
|
| 9 |
SERVICE_FLUID TEXT, |
|
| 10 |
SERVICE_DENSITY TEXT, |
|
| 11 |
SERVICE_STATE TEXT, |
|
| 12 |
OPERATION_CONDITION_TEMP TEXT, |
|
| 13 |
OPERATION_CONDITION_PRESS TEXT, |
|
| 14 |
DESIGN_CONDITION_TEMP TEXT, |
|
| 15 |
DESIGN_CONDITION_PRESS TEXT, |
|
| 16 |
TEST_CONDITION_TEMP TEXT, |
|
| 17 |
TEST_CONDITION_PRESS TEXT, |
|
| 18 |
INSUL_CODE TEXT, |
|
| 19 |
PAINT_CODE TEXT, |
|
| 20 |
NDE_CODE TEXT, |
|
| 21 |
PWHT TEXT, |
|
| 22 |
PNID_NO TEXT, |
|
| 23 |
STREAM_NO TEXT, |
|
| 24 |
CONSTRAINT LINE_DATA_LIST_PK PRIMARY KEY (UID) |
|
| 25 |
); |
|
| 26 |
CREATE UNIQUE INDEX IF NOT EXISTS LINE_DATA_LIST_TAG_NO_IDX ON LINE_DATA_LIST (UID); |
|
| HYTOS/HYTOS/Scripts/LineProperties.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS LineProperties ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Name TEXT NOT NULL, |
|
| 4 |
[DisplayName] TEXT, |
|
| 5 |
[Type] TEXT, |
|
| 6 |
[LimitNumber] INTEGER, |
|
| 7 |
[Index] INTEGER, |
|
| 8 |
CONSTRAINT LineProperties_PK PRIMARY KEY (UID) |
|
| 9 |
); |
|
| 10 |
CREATE UNIQUE INDEX IF NOT EXISTS LineProperties_Name_IDX ON LineProperties (Name); |
|
| HYTOS/HYTOS/Scripts/LineTypes.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS LineTypes ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Name TEXT NOT NULL UNIQUE, |
|
| 4 |
Type1 TEXT, |
|
| 5 |
Conditions1 TEXT, |
|
| 6 |
Type2 TEXT, |
|
| 7 |
Conditions2 TEXT, |
|
| 8 |
PRIMARY KEY ( |
|
| 9 |
UID |
|
| 10 |
) |
|
| 11 |
); |
|
| HYTOS/HYTOS/Scripts/Loops.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Loops ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Name TEXT NOT NULL, |
|
| 4 |
From_Nozzles_UID TEXT NOT NULL, |
|
| 5 |
Stream_No INTEGER NOT NULL, |
|
| 6 |
To_Nozzles_UID TEXT NOT NULL, |
|
| 7 |
CONSTRAINT PK_Loops PRIMARY KEY ( |
|
| 8 |
UID |
|
| 9 |
), |
|
| 10 |
CONSTRAINT FK_From_Nozzles_UID FOREIGN KEY ( |
|
| 11 |
From_Nozzles_UID |
|
| 12 |
) |
|
| 13 |
REFERENCES Nozzles (UID), |
|
| 14 |
CONSTRAINT FK_Stream_No FOREIGN KEY ( |
|
| 15 |
Stream_No |
|
| 16 |
) |
|
| 17 |
REFERENCES HMB (Stream_No), |
|
| 18 |
CONSTRAINT FK_To_Nozzles_UID FOREIGN KEY ( |
|
| 19 |
To_Nozzles_UID |
|
| 20 |
) |
|
| 21 |
REFERENCES Nozzles (UID) |
|
| 22 |
); |
|
| HYTOS/HYTOS/Scripts/NOMINAL PIPE SIZE.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS "NOMINAL PIPE SIZE"( |
|
| 2 |
Code VARCHAR(2147483647) NOT NULL, |
|
| 3 |
Metric REAL, |
|
| 4 |
Inch REAL, |
|
| 5 |
InchStr VARCHAR(2147483647), |
|
| 6 |
MetricStr VARCHAR(2147483647) |
|
| 7 |
); |
|
| HYTOS/HYTOS/Scripts/NOTE_DATA_LIST.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS NOTE_DATA_LIST ( |
|
| 2 |
UID TEXT, |
|
| 3 |
NOTE_NO TEXT, |
|
| 4 |
DESCRIPTION TEXT, |
|
| 5 |
PNID_NO TEXT, |
|
| 6 |
CONSTRAINT NOTE_DATA_LIST_PK PRIMARY KEY (UID) |
|
| 7 |
); |
|
| 8 |
CREATE UNIQUE INDEX IF NOT EXISTS NOTE_DATA_LIST_TAG_NO_IDX ON NOTE_DATA_LIST (UID); |
|
| HYTOS/HYTOS/Scripts/NominalDiameter.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS NominalDiameter ( |
|
| 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, |
|
| 10 |
CONSTRAINT PK_NominalDiameter PRIMARY KEY ( |
|
| 11 |
UID |
|
| 12 |
) |
|
| 13 |
); |
|
| HYTOS/HYTOS/Scripts/Nozzles.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Nozzles ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Points_UID TEXT NOT NULL, |
|
| 4 |
Pressure REAL, |
|
| 5 |
Pressure_Drop REAL, |
|
| 6 |
Elevation REAL, |
|
| 7 |
Over_Design_CV REAL, |
|
| 8 |
CV_Type TEXT, |
|
| 9 |
Total_Discharge_Loss REAL, |
|
| 10 |
Total_Suction_Loass REAL, |
|
| 11 |
Total_Loss REAL, |
|
| 12 |
Discharge_Device_Loss REAL, |
|
| 13 |
Suction_Device_Loss REAL, |
|
| 14 |
Total_Device_Loss REAL, |
|
| 15 |
Discharge_Line_Friction_Loss REAL, |
|
| 16 |
Suction_Line_Friction_Loss REAL, |
|
| 17 |
Line_Total_Frictoin_Loss REAL, |
|
| 18 |
CONSTRAINT PK_Nozzles PRIMARY KEY ( |
|
| 19 |
UID |
|
| 20 |
), |
|
| 21 |
CONSTRAINT FK_Points_UID FOREIGN KEY ( |
|
| 22 |
Points_UID |
|
| 23 |
) |
|
| 24 |
REFERENCES Points (UID) |
|
| 25 |
); |
|
| HYTOS/HYTOS/Scripts/PipingMaterialsClass.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [PipingMaterialsClass]( |
|
| 2 |
`UID` TEXT NOT NULL, |
|
| 3 |
`CODE` TEXT NOT NULL UNIQUE, |
|
| 4 |
`DESCRIPTION` TEXT, |
|
| 5 |
`Allowables` TEXT, |
|
| 6 |
CONSTRAINT `PipingMaterialsClass_PK` PRIMARY KEY(`UID`) |
|
| 7 |
); |
|
| 8 |
|
|
| 9 |
CREATE UNIQUE INDEX IF NOT EXISTS [PipingMaterialsClass_CODE_IDX] ON [PipingMaterialsClass]([CODE]); |
|
| HYTOS/HYTOS/Scripts/PnIDNumber.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [PnIDNumber]( |
|
| 2 |
[UID] TEXT CONSTRAINT [PnIDNumber_PK] PRIMARY KEY NOT NULL, |
|
| 3 |
[CODE] TEXT NOT NULL UNIQUE, |
|
| 4 |
[DESCRIPTION] TEXT); |
|
| 5 |
|
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [PnIDNumber_CODE_IDX] ON [PnIDNumber]([CODE]); |
|
| HYTOS/HYTOS/Scripts/Points.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Points ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Components_UID TEXT NOT NULL, |
|
| 4 |
[Index] INTEGER NOT NULL, |
|
| 5 |
X REAL NOT NULL, |
|
| 6 |
Y REAL NOT NULL, |
|
| 7 |
CONSTRAINT PK_Points PRIMARY KEY ( |
|
| 8 |
UID |
|
| 9 |
), |
|
| 10 |
CONSTRAINT FK_Components_UID FOREIGN KEY ( |
|
| 11 |
Components_UID |
|
| 12 |
) |
|
| 13 |
REFERENCES Components (UID) |
|
| 14 |
); |
|
| HYTOS/HYTOS/Scripts/Ports.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Ports ( |
|
| 2 |
UID TEXT PRIMARY KEY |
|
| 3 |
NOT NULL, |
|
| 4 |
Components_UID TEXT REFERENCES Components (UID) NOT NULL, |
|
| 5 |
X INTEGER, |
|
| 6 |
Y INTEGER, |
|
| 7 |
Connected_UID TEXT REFERENCES Components (UID) |
|
| 8 |
); |
|
| HYTOS/HYTOS/Scripts/Roughness.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Roughness ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Material TEXT NOT NULL, |
|
| 4 |
Roughness REAL NOT NULL, |
|
| 5 |
CONSTRAINT PK_Roughness PRIMARY KEY ( |
|
| 6 |
UID |
|
| 7 |
), |
|
| 8 |
CONSTRAINT UQ_Roughness UNIQUE ( |
|
| 9 |
Material |
|
| 10 |
) |
|
| 11 |
); |
|
| HYTOS/HYTOS/Scripts/Symbol.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS "Symbol" ( |
|
| 2 |
`UID` INTEGER PRIMARY KEY AUTOINCREMENT, |
|
| 3 |
`Name` TEXT NOT NULL, |
|
| 4 |
`SymbolType_UID` TEXT NOT NULL, |
|
| 5 |
`Type` TEXT, |
|
| 6 |
`Threshold` NUMERIC NOT NULL DEFAULT (0.4), |
|
| 7 |
`MinMatchPoint` TEXT NOT NULL DEFAULT 0, |
|
| 8 |
`IsDetectOrigin` INTEGER NOT NULL DEFAULT 0, |
|
| 9 |
`RotationCount` INTEGER NOT NULL DEFAULT 4, |
|
| 10 |
`OCROption` INTEGER NOT NULL DEFAULT 0, |
|
| 11 |
`IsContainChild` INTEGER NOT NULL DEFAULT 0, |
|
| 12 |
`OriginalPoint` TEXT, |
|
| 13 |
`ConnectionPoint` TEXT, |
|
| 14 |
`BaseSymbol` TEXT, |
|
| 15 |
`AdditionalSymbol` TEXT, |
|
| 16 |
`IsExceptDetect` INTEGER DEFAULT 0, |
|
| 17 |
`HasInstrumentLabel` INTEGER DEFAULT 0, |
|
| 18 |
`Width` INTEGER, |
|
| 19 |
`Height` INTEGER, |
|
| 20 |
`Flip` INTEGER, |
|
| 21 |
FOREIGN KEY(`SymbolType_UID`) REFERENCES `SymbolType`(`UID`) |
|
| 22 |
); |
|
| HYTOS/HYTOS/Scripts/SymbolAttribute.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS SymbolAttribute ( |
|
| 2 |
`UID` TEXT NOT NULL, |
|
| 3 |
`SymbolType_UID` TEXT, |
|
| 4 |
`Attribute` TEXT, |
|
| 5 |
`DisplayAttribute` TEXT NOT NULL, |
|
| 6 |
`AttributeType` TEXT NOT NULL, |
|
| 7 |
`Expression` BLOB, |
|
| 8 |
`index` INT NOT NULL, |
|
| 9 |
`AttrAt` INTEGER DEFAULT 0, |
|
| 10 |
`Target` TEXT DEFAULT 'ALL', |
|
| 11 |
PRIMARY KEY(`SymbolType_UID`,`Attribute`), |
|
| 12 |
FOREIGN KEY(`SymbolType_UID`) REFERENCES `SymbolType`(`UID`) |
|
| 13 |
); |
|
| HYTOS/HYTOS/Scripts/SymbolName.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS "SymbolName" ( |
|
| 2 |
`UID` INTEGER NOT NULL, |
|
| 3 |
`SymbolType_UID` INTEGER, |
|
| 4 |
`Category` TEXT ( 2000000000 ) NOT NULL, |
|
| 5 |
`Type` TEXT ( 2000000000 ), |
|
| 6 |
`Name` TEXT ( 2000000000 ) NOT NULL, |
|
| 7 |
FOREIGN KEY(`SymbolType_UID`) REFERENCES `SymbolType`(`UID`), |
|
| 8 |
PRIMARY KEY(`UID`) |
|
| 9 |
); |
|
| HYTOS/HYTOS/Scripts/Symbols.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Symbols ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
Name TEXT NOT NULL, |
|
| 4 |
SymbolType_UID TEXT NOT NULL, |
|
| 5 |
OriginalPoint TEXT NOT NULL, |
|
| 6 |
ConnectionPoint TEXT, |
|
| 7 |
CONSTRAINT PK_Symbols PRIMARY KEY ( |
|
| 8 |
UID |
|
| 9 |
), |
|
| 10 |
CONSTRAINT FK_SymbolType_UID FOREIGN KEY ( |
|
| 11 |
SymbolType_UID |
|
| 12 |
) |
|
| 13 |
REFERENCES SymbolType (UID) |
|
| 14 |
); |
|
| HYTOS/HYTOS/Scripts/TitleBlockProperties.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [TitleBlockProperties]( |
|
| 2 |
[UID] TEXT CONSTRAINT [TitleBlockProperties_PK] PRIMARY KEY NOT NULL, |
|
| 3 |
[NAME] TEXT NOT NULL UNIQUE, |
|
| 4 |
[AREA] TEXT |
|
| 5 |
); |
|
| 6 |
CREATE UNIQUE INDEX IF NOT EXISTS [TitleBlockProperties_NAME_IDX] ON [TitleBlockProperties]([NAME]); |
|
| HYTOS/HYTOS/Scripts/TitleBlockValues.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS TitleBlockValues ( |
|
| 2 |
UID TEXT PRIMARY KEY, |
|
| 3 |
Drawings_UID TEXT REFERENCES Drawings (UID), |
|
| 4 |
TitleBlockProperties_UID TEXT REFERENCES TitleBlockProperties (UID), |
|
| 5 |
VALUE TEXT |
|
| 6 |
); |
|
| 7 |
CREATE UNIQUE INDEX IF NOT EXISTS [TitleBlockValues_UNIQUE_IDX] ON [TitleBlockValues]([Drawings_UID],[TitleBlockProperties_UID]); |
|
| HYTOS/HYTOS/Scripts/UnitNumber.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [UnitNumber]( |
|
| 2 |
`UID` TEXT NOT NULL, |
|
| 3 |
`CODE` TEXT NOT NULL UNIQUE, |
|
| 4 |
`DESCRIPTION` TEXT, |
|
| 5 |
`Allowables` TEXT, |
|
| 6 |
CONSTRAINT `UnitNumber_PK` PRIMARY KEY(`UID`) |
|
| 7 |
); |
|
| HYTOS/HYTOS/Scripts/Units.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS Units ( |
|
| 2 |
UID TEXT NOT NULL, |
|
| 3 |
TABLE_NAME TEXT NOT NULL, |
|
| 4 |
COLUMN_NAME TEXT NOT NULL, |
|
| 5 |
UNIT TEXT NOT NULL, |
|
| 6 |
CONSTRAINT PK_Units PRIMARY KEY ( |
|
| 7 |
UID |
|
| 8 |
), |
|
| 9 |
CONSTRAINT UQ_Units UNIQUE ( |
|
| 10 |
TABLE_NAME, |
|
| 11 |
COLUMN_NAME, |
|
| 12 |
UNIT |
|
| 13 |
) |
|
| 14 |
); |
|
| HYTOS/HYTOS/Scripts/VALVE_DATA_LIST.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS VALVE_DATA_LIST ( |
|
| 2 |
UID TEXT, |
|
| 3 |
ITEM_NO TEXT, |
|
| 4 |
MainSize TEXT, |
|
| 5 |
SubSize TEXT, |
|
| 6 |
PNID_NO TEXT, |
|
| 7 |
CONSTRAINT VALVE_DATA_LIST_PK PRIMARY KEY (UID) |
|
| 8 |
); |
|
| 9 |
CREATE UNIQUE INDEX IF NOT EXISTS VALVE_DATA_LIST_TAG_NO_IDX ON VALVE_DATA_LIST (UID); |
|
| HYTOS/HYTOS/Scripts/ValveOperCodes.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS [ValveOperCodes]( |
|
| 2 |
[UID] TEXT CONSTRAINT [ValveOperCodes_PK] PRIMARY KEY NOT NULL, |
|
| 3 |
[Code] TEXT NOT NULL UNIQUE, |
|
| 4 |
[Description] TEXT, |
|
| 5 |
[Allowables] TEXT); |
|
| 6 |
|
|
| 7 |
CREATE UNIQUE INDEX IF NOT EXISTS [ValveOperCodes_Code_IDX] ON [ValveOperCodes]([Code]); |
|
| HYTOS/HYTOS/Scripts/VendorPackages.sql | ||
|---|---|---|
| 1 |
CREATE TABLE IF NOT EXISTS VendorPackages ( |
|
| 2 |
UID TEXT PRIMARY KEY, |
|
| 3 |
Drawings_UID TEXT REFERENCES Drawings (UID) NOT NULL, |
|
| 4 |
PTS TEXT |
|
| 5 |
); |
|
내보내기 Unified diff
