HYTOS

CREATE TABLE IF NOT EXISTS Components (

    UID          TEXT NOT NULL,

    Drawings_UID TEXT NOT NULL,

    Symbols_UID  TEXT NOT NULL,

    Name         TEXT,

    X            REAL,

    Y            REAL,

    Rotation     REAL,

    Scale        REAL DEFAULT (1),

    CONSTRAINT PK_Components PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Drawings_UID FOREIGN KEY (

        Drawings_UID

    )

    REFERENCES Drawings (UID),

    CONSTRAINT FK_Symbols_UID FOREIGN KEY (

        Symbols_UID

    )

    REFERENCES Symbols (UID) 

);

CREATE TABLE IF NOT EXISTS Configuration (

    UID     TEXT NOT NULL,

    Section TEXT NOT NULL,

    [Key]   TEXT NOT NULL,

    Value   TEXT NOT NULL,

    CONSTRAINT PK_Configuration PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Configuration UNIQUE (

        Section,

        [Key]

    )

);

CREATE TABLE IF NOT EXISTS DisplayNames (

    UID          TEXT NOT NULL,

    TABLE_NAME   TEXT NOT NULL,

    COLUMN_NAME  TEXT NOT NULL,

    DISPLAY_NAME TEXT,

    [Order]      INTEGER NOT NULL,

    CONSTRAINT PK_DisplayNames PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_DisplayNames UNIQUE (

        TABLE_NAME,

        COLUMN_NAME,

        [Order]

    )

);

CREATE TABLE IF NOT EXISTS Drawings (

    UID      TEXT NOT NULL,

    NAME     TEXT NOT NULL,

    DATETIME TEXT NOT NULL,

    CONSTRAINT PK_Drawings PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Drawings UNIQUE (

        NAME

    )

);

CREATE TABLE IF NOT EXISTS DrawingsUnits (

    UID          TEXT NOT NULL,

    Drawings_UID TEXT NOT NULL,

    Table_Name   TEXT NOT NULL,

    Column_Name  TEXT NOT NULL,

    Units_UID    TEXT,

    CONSTRAINT PK_DrawingsUnits PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Drawings_UID FOREIGN KEY (

        Drawings_UID

    )

    REFERENCES Drawings (UID),

    CONSTRAINT FK_Units_UID FOREIGN KEY (

        Units_UID

    )

    REFERENCES Units (UID) 

);

CREATE TABLE IF NOT EXISTS Fittings_2K (

    UID                                    TEXT    NOT NULL,

    Components_UID                         TEXT    NOT NULL,

    [90_Elbow_Standard_Screw]              INTEGER,

    [90_Elbow_Standard_Flange_Weld]        INTEGER,

    [90_Elbow_Long_Radius_All]             INTEGER,

    [90_Elbow_1_Weld]                      INTEGER,

    [90_Elbow_2_Weld]                      INTEGER,

    [90_Elbow_3_Weld]                      INTEGER,

    [90_Elbow_4_Weld]                      INTEGER,

    [90_Elbow_5_Weld]                      INTEGER,

    [45_Elbow_Standard_All]                INTEGER,

    [45_Elbow_Long_Radius_All]             INTEGER,

    [45_Elbow_1_Weld]                      INTEGER,

    [45_Elbow_2_Weld]                      INTEGER,

    [180_Elbow_Standard_Screw]             INTEGER,

    [180_Elbow_Standard_Flange_Weld]       INTEGER,

    [180_Elbow_Long_Radius_All]            INTEGER,

    Tee_Elbow_Standard_Screw               INTEGER,

    Tee_Elbow_Long_Radius_Screw            INTEGER,

    Tee_Elbow_Standard_Flange_Weld         INTEGER,

    Tee_Elbow_Stub_In_Branch               INTEGER,

    Tee_Through_Screw                      INTEGER,

    Tee_Through_Flange_Weld                INTEGER,

    Tee_Through_Stub_In_Branch             INTEGER,

    Gate_Ball_Plug_Valve_Full              INTEGER,

    [Gate_Ball_Plug_Valve_Reduce_Trim_0.9] INTEGER,

    [Gate_Ball_Plug_Valve_Reduce_Trim_0.8] INTEGER,

    Globe_Valve_Standard                   INTEGER,

    Globe_Valve_Angle_YType                INTEGER,

    Diaphragm_Dam_Valve                    INTEGER,

    Butterfly_Valve                        INTEGER,

    Check_Valve_Lift                       INTEGER,

    Check_Valve_Swing                      INTEGER,

    Check_Valve_Tilting                    INTEGER,

    Pipe_Entrance_Normal                   INTEGER,

    Pipe_Entrance_Borda                    INTEGER,

    Pipe_Exit                              INTEGER,

    Resistance_Coefficiency                REAL,

    Calculated_Fitting                     REAL,

    CONSTRAINT PK_Fittings_2K PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS Fittings_CraneK (

    UID                              TEXT    NOT NULL,

    Components_UID                   TEXT    NOT NULL,

    [90_Elbow_Standard_Screw]        INTEGER,

    [90_Elbow_Long_Radius_1]         INTEGER,

    [90_Elbow_Long_Radius_1.5]       INTEGER,

    [90_Elbow_Long_Radius_2]         INTEGER,

    [90_Elbow_Long_Radius_3]         INTEGER,

    [90_Elbow_Long_Radius_4]         INTEGER,

    [90_Elbow_Long_Radius_6]         INTEGER,

    [90_Elbow_Long_Radius_8]         INTEGER,

    [90_Elbow_Long_Radius_10]        INTEGER,

    [90_Elbow_Long_Radius_12]        INTEGER,

    [90_Elbow_Long_Radius_14]        INTEGER,

    [90_Elbow_Long_Radius_16]        INTEGER,

    [90_Elbow_Long_Radius_20]        INTEGER,

    [90_Elbow_1_Weld]                INTEGER,

    [90_Elbow_2_Weld]                INTEGER,

    [90_Elbow_3_Weld]                INTEGER,

    [90_Elbow_6_Weld]                INTEGER,

    [45_Elbow_Standard_Screw]        INTEGER,

    [45_Elbow_1_Weld]                INTEGER,

    [45_Elbow_3_Weld]                INTEGER,

    [180_Elbow_Standard_Screw]       INTEGER,

    [180_Elbow_Long_Radius_1]        INTEGER,

    [180_Elbow_Long_Radius_1.5]      INTEGER,

    [180_Elbow_Long_Radius_2]        INTEGER,

    [180_Elbow_Long_Radius_3]        INTEGER,

    [180_Elbow_Long_Radius_4]        INTEGER,

    [180_Elbow_Long_Radius_6]        INTEGER,

    [180_Elbow_Long_Radius_8]        INTEGER,

    [180_Elbow_Long_Radius_10]       INTEGER,

    [180_Elbow_Long_Radius_12]       INTEGER,

    [180_Elbow_Long_Radius_14]       INTEGER,

    [180_Elbow_Long_Radius_16]       INTEGER,

    [180_Elbow_Long_Radius_20]       INTEGER,

    [180_Elbow_2_Weld]               INTEGER,

    [180_Elbow_3_Weld]               INTEGER,

    [180_Elbow_4_Weld]               INTEGER,

    [180_Elbow_6_Weld]               INTEGER,

    [180_Elbow_12_Weld]              INTEGER,

    Tee_Through                      INTEGER,

    Tee_Elbow                        INTEGER,

    Expander                         INTEGER,

    Reducer                          INTEGER,

    Globe_Valve_Standard             INTEGER,

    Globe_Valve_45_Angle             INTEGER,

    Globe_Valve_90_Angle             INTEGER,

    Plug_Valve_1_Way                 INTEGER,

    Plug_Valve_3_Way_Through         INTEGER,

    Plug_Valve_3_Way_Elbow           INTEGER,

    Foot_Valve_Poppet_Disc           INTEGER,

    Foot_Valve_Hinged_Disc           INTEGER,

    Gate_Valve                       INTEGER,

    Ball_Valve                       INTEGER,

    Butterfly_Valve                  INTEGER,

    Pipe_Enterance_Projecting        INTEGER,

    [Pipe_Enterance_Flush_0.00]      INTEGER,

    [Pipe_Enterance_Flush_0.02]      INTEGER,

    [Pipe_Enterance_Flush_0.04]      INTEGER,

    [Pipe_Enterance_Flush_0.06]      INTEGER,

    [Pipe_Enterance_Flush_0.10]      INTEGER,

    [Pipe_Enterance_Flush_0.15]      INTEGER,

    Pipe_Exit_Projecting             INTEGER,

    Pipe_Exit_Sharp_Edged            INTEGER,

    Pipe_Exit_Rounded                INTEGER,

    Check_Valve_Swing_Vertical       INTEGER,

    Check_Valve_Swing_Angled         INTEGER,

    Check_Valve_Lift_Straight        INTEGER,

    Check_Valve_Lift_Angled          INTEGER,

    [Check_Valve_Tilting_Alpha_5]    INTEGER,

    [Check_Valve_Tilting_Alpha_15]   INTEGER,

    Check_Valve_Globe_Stop           INTEGER,

    Check_Valve_Globe_Stop_45_Angle  INTEGER,

    Check_Valve_Globe_Stop_Inline    INTEGER,

    Check_Valve_Angled_Stop          INTEGER,

    Check_Valve_Angled_Stop_45_Angle INTEGER,

    Check_Valve_Angled_Stop_Inline   INTEGER,

    User_Input                       INTEGER,

    Resistance_Coefficiency          REAL,

    Calculated_Fitting               REAL,

    CONSTRAINT PK_Fittings_CraneK PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS Fittings_EquivalentLength (

    UID                  TEXT    NOT NULL,

    Components_UID       TEXT    NOT NULL,

    Gate_Ball_Plug_Valve INTEGER,

    Globe_Valve          INTEGER,

    Butterfly_Valve      INTEGER,

    Check_Valve          INTEGER,

    [90_Elbow]           INTEGER,

    [45_Elbo]            INTEGER,

    Tee_Branch           INTEGER,

    Tee_Through          INTEGER,

    Milter               INTEGER,

    Milter_Degree        INTEGER,

    Nozzle_In_YN         BOOLEAN,

    Nozzle_Out_YN        BOOLEAN,

    Calculated_Fitting   REAL,

    CONSTRAINT PK_Fittings_EquivalentLength PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS HMB (

	UID                      TEXT    NOT NULL,

    Components_UID           TEXT    NOT NULL,

    Stream_No                INTEGER NOT NULL,

    Phase_Type               TEXT,

    Flowrate_Mass            REAL,

    Flowrate_Volume          REAL,

    Density                  REAL,

    Viscosity                REAL,

    Temperature              REAL,

    Molecular_Weight         REAL,

    Specific_Heat_Ratio      REAL,

    Compress_Factor          REAL,

    Nominal_Pipe_Size        REAL,

    Inside_Pipe_Size         REAL,

    Schedul_No               TEXT,

    Straight_Length          REAL,

    Equivalent_Length        REAL,

    Roughness                REAL,

    Limitation_Velocity      REAL,

    Limitation_Pressure_Drop REAL,

    Velocity                 REAL,

    Reynolds                 REAL,

    Friction_Factor          REAL,

    Pressure_Drop            REAL,

    Pressure_Drop_Friction   REAL,

    Pressure_Drop_Static     REAL,

    Pressure_Pipe_End_Point  REAL,

    Power                    REAL,

    CONSTRAINT PK_HMB PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID),

    CONSTRAINT UQ_HMB UNIQUE (

        Components_UID,

        Stream_No

    )

);

CREATE TABLE IF NOT EXISTS Loops (

    UID              TEXT    NOT NULL,

    Name             TEXT    NOT NULL,

    From_Nozzles_UID TEXT    NOT NULL,

    Stream_No        INTEGER NOT NULL,

    To_Nozzles_UID   TEXT    NOT NULL,

    CONSTRAINT PK_Loops PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_From_Nozzles_UID FOREIGN KEY (

        From_Nozzles_UID

    )

    REFERENCES Nozzles (UID),

    CONSTRAINT FK_Stream_No FOREIGN KEY (

        Stream_No

    )

    REFERENCES HMB (Stream_No),

    CONSTRAINT FK_To_Nozzles_UID FOREIGN KEY (

        To_Nozzles_UID

    )

    REFERENCES Nozzles (UID) 

);

CREATE TABLE IF NOT EXISTS NominalDiameter (

    UID                TEXT NOT NULL,

    Milimeter          REAL NOT NULL,

    Inch               REAL NOT NULL,

    CONSTRAINT PK_NominalDiameter PRIMARY KEY (

        UID

    )

);

CREATE TABLE IF NOT EXISTS Nozzles (

    UID                          TEXT NOT NULL,

    Points_UID                   TEXT NOT NULL,

    Pressure                     REAL,

    Pressure_Drop                REAL,

    Elevation                    REAL,

    Over_Design_CV               REAL,

    CV_Type                      TEXT,

    Total_Discharge_Loss         REAL,

    Total_Suction_Loass          REAL,

    Total_Loss                   REAL,

    Discharge_Device_Loss        REAL,

    Suction_Device_Loss          REAL,

    Total_Device_Loss            REAL,

    Discharge_Line_Friction_Loss REAL,

    Suction_Line_Friction_Loss   REAL,

    Line_Total_Frictoin_Loss     REAL,

    CONSTRAINT PK_Nozzles PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Points_UID FOREIGN KEY (

        Points_UID

    )

    REFERENCES Points (UID) 

);

CREATE TABLE IF NOT EXISTS Points (

    UID            TEXT    NOT NULL,

    Components_UID TEXT    NOT NULL,

    [Index]        INTEGER NOT NULL,

    X              REAL    NOT NULL,

    Y              REAL    NOT NULL,

    ConnectedItem_UID TEXT,

    CONSTRAINT PK_Points PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) 

);

CREATE TABLE IF NOT EXISTS Roughness (

    UID       TEXT NOT NULL,

    Material  TEXT NOT NULL,

    Meter     REAL NOT NULL,

    Inch      REAL NOT NULL,

    Feet      REAL NOT NULL,

    Milimeter REAL NOT NULL,

    CONSTRAINT PK_Roughness PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Roughness UNIQUE (

        Material

    )

);

CREATE TABLE IF NOT EXISTS Symbols (

    UID             TEXT NOT NULL,

    Name            TEXT NOT NULL,

    SymbolType_UID  TEXT NOT NULL,

    OriginalPoint   TEXT NOT NULL,

    ConnectionPoint TEXT,

    CONSTRAINT PK_Symbols PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_SymbolType_UID FOREIGN KEY (

        SymbolType_UID

    )

    REFERENCES SymbolType (UID) 

);

CREATE TABLE IF NOT EXISTS SymbolType(

    UID      TEXT NOT NULL,

    Category TEXT NOT NULL,

    Type     TEXT NOT NULL,

    CONSTRAINT PK_SymbolType PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_SymbolType UNIQUE (

        Category,

        Type

    )

);

CREATE TABLE IF NOT EXISTS Units (

    UID         TEXT NOT NULL,

    TABLE_NAME  TEXT NOT NULL,

    COLUMN_NAME TEXT NOT NULL,

    UNIT        TEXT NOT NULL,

    CONSTRAINT PK_Units PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Units UNIQUE (

        TABLE_NAME,

        COLUMN_NAME,

        UNIT

    )

);