HYTOS

CREATE TABLE IF NOT EXISTS Geometry_Input (

    UID            		TEXT    NOT NULL,

    Components_UID 		TEXT    NOT NULL,

    Element   	   		TEXT    NOT NULL,

    Nominal_Pipe_Size   REAL,

    Schedule_No       	REAL,

    Inside_Pipe_Size    REAL,

    Roughness          	REAL,

	Length         		REAL,

    Angle       		REAL,

    RPD          		REAL,

    D1_D2          		REAL,

	K          			REAL,

    CONSTRAINT PK_Geometry_Input PRIMARY KEY (

        UID

    ),

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) ON DELETE CASCADE

);