HYTOS

CREATE TABLE IF NOT EXISTS Fittings_Input (

	UID                      TEXT    NOT NULL,

    Components_UID           TEXT    NOT NULL,

    Fittings_UID             TEXT    NOT NULL,

    Method                   TEXT    NOT NULL,

    Sub_Size                 REAL,

    Angle                    REAL,

    Count                    INTEGER,

    CONSTRAINT PK_Fittings_Input PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) ON DELETE CASCADE,

	CONSTRAINT FK_Fittings_UID FOREIGN KEY (

        Fittings_UID

    )

    REFERENCES Fittings (UID) ON DELETE RESTRICT,

    CONSTRAINT UQ_Fittings_Input UNIQUE (

        Components_UID,

        Fittings_UID

    )

);