HYTOS

CREATE TABLE IF NOT EXISTS Schedule (

    UID                 TEXT NOT NULL,

    [No]                TEXT NOT NULL,

    CONSTRAINT PK_Schedule PRIMARY KEY (

        UID

    ),

    CONSTRAINT UQ_Schedule UNIQUE (

        [No]

    )

);

CREATE TABLE IF NOT EXISTS InsideDiameter (

    UID                 TEXT NOT NULL,

    NominalDiameter_UID TEXT NOT NULL,

    Schedule_UID        TEXT NOT NULL,

    Milimeter           REAL,

    Inch                REAL,

    CONSTRAINT PK_InsideDiameter PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_NominalDiameter_UID FOREIGN KEY (

        NominalDiameter_UID

    )

    REFERENCES NominalDiameter (UID),

    CONSTRAINT FK_Schedule_UID FOREIGN KEY (

        Schedule_UID

    )

    REFERENCES Schedule (UID),

    CONSTRAINT UQ_InsideDiameter UNIQUE (

        NominalDiameter_UID,

        Schedule_UID

    )

);