HYTOS

    UID                                  VARCHAR (37) PRIMARY KEY,

    StreamNumber                         TEXT,

    StreamDescription                    TEXT,

    DATACASE                             TEXT,

    STREAMPHASE                          TEXT,

    Unitno                               TEXT,

    OVERALLVAPORFRACTION                 TEXT,

    OVERALLTEMPERATURE                   TEXT,

    OVERALLPRESSURE                      TEXT,

    OVERALLMOLECULARWEIGHT               TEXT,

    OVERALLMOLARFLOW                     TEXT,

    OVERALLMASSFLOW                      TEXT,

    OVERALLACTUALVOLUMEFLOW              TEXT,

    OVERALLMASSDENSITY                   TEXT,

    OVERALLVISCOSITY                     TEXT,

    OVERALLMASSHEATCAPACITY              TEXT,

    OVERALLHEATFLOW                      TEXT,

    OverallMassEnthalpy                  TEXT,

    [OverallSp.Gravity]                  TEXT,

    OverallAPIGravity                    TEXT,

    OverallCriticalPressure              TEXT,

    OverallCriticalTemperature           TEXT,

    OverallUOPKfactor                    TEXT,

    LIQUIDMOLEFRACTION                   TEXT,

    VaporTemperature                     TEXT,

    VaporPressure                        TEXT,

    VaporPseudocriticalTemperature       TEXT,

    VaporPseudocriticalPressure          TEXT,

    VAPORMOLARRATE                       TEXT,

    VAPORMASSRATE                        TEXT,

    VAPORACTUALVOLUMERATE                TEXT,

    [VAPORSTD.VOLUMERATE]                TEXT,

    VAPORMOLECULARWEIGHT                 TEXT,

    VaporHeatFlow                        TEXT,

    VAPORCOMPRESSIBILITY                 TEXT,

    VAPORSPECIFICENTHALPY                TEXT,

    VAPORSPECIFICHEATCAPACITY            TEXT,

    IDEALVAPORSPECIFICHEATRATIO          TEXT,

    VAPORACTUALDENSITY                   TEXT,

    VAPORTHERMALCONDUCTIVITY             TEXT,

    VAPORVISCOSITY                       TEXT,

    LiquidTemperature                    TEXT,

    LiquidPressure                       TEXT,

    LiquidPseudocriticalTemperature      TEXT,

    LiquidPseudocriticalPressure         TEXT,

    LIQUIDMOLARRATE                      TEXT,

    LIQUIDMASSRATE                       TEXT,

    LIQUIDACTUALVOLUMEFLOW               TEXT,

    [LIQUIDSTD.VOLUMEFLOW]               TEXT,

    LIQUIDMOLECULARWEIGHT                TEXT,

    LiquidHeatFlow                       TEXT,

    LIQUIDSPECIFICENTHALPY               TEXT,

    LIQUIDBoilingPointPressureatStreamT  TEXT,

    LIQUIDSPECIFICHEATCAPACITY           TEXT,

    LIQUIDACTUALDENSITY                  TEXT,

    LiquidStdDensity                     TEXT,

    [LiquidSpecificGravity@15°C]         TEXT,

    LIQUIDSURFACETENSION                 TEXT,

    LIQUIDTHERMALCONDUCTIVITY            TEXT,

    LIQUIDVISCOSITY                      TEXT,

    AQUEOUSPseudocriticalTemperature     TEXT,

    AQUEOUSPseudocriticalPressure        TEXT,

    AQUEOUSMOLARRATE                     TEXT,

    AQUEOUSMASSRATE                      TEXT,

    AQUEOUSACTUALVOLUMEFLOW              TEXT,

    [AQUEOUSSTD.LIQUIDFLOW]              TEXT,

    AQUEOUSMolecularWeight               TEXT,

    AQUEOUSHeatFlow                      TEXT,

    AQUEOUSSPECIFICENTHALPY              TEXT,

    AQUEOUSBoilingPointPressureatStreamT TEXT,

    AQUEOUSSPECIFICHEATCAPACITY          TEXT,

    AQUEOUSACTUALDENSITY                 TEXT,

    AQUEOUSStdDensity                    TEXT,

    [AQUEOUSSpecificGravity@15°C]        TEXT,

    AQUEOUSSURFACETENSION                TEXT,

    AQUEOUSTHERMALCONDUCTIVITY           TEXT,

    AQUEOUSVISCOSITY                     TEXT,

    DataSource                           TEXT

);

CREATE TABLE IF NOT EXISTS Streamlines (

    UID     INTEGER      PRIMARY KEY AUTOINCREMENT

                         NOT NULL,

    HMB_UID VARCHAR (37) REFERENCES HMB (UID) ON DELETE CASCADE,

    [From]  VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL,

    [To]    VARCHAR (37) REFERENCES Components (UID) ON DELETE SET NULL