HYTOS

CREATE TABLE Components (

    UID                  NVARCHAR (37) PRIMARY KEY,

    Drawings_UID         NVARCHAR (37) REFERENCES Drawings (UID) 

                                      NOT NULL,

    Symbol_UID           INTEGER REFERENCES Symbol (UID) 

    UID            NVARCHAR (37) PRIMARY KEY

                                NOT NULL,

    Type           NVARCHAR(MAX)         NOT NULL,

    Components_UID NVARCHAR(37)         REFERENCES Components (UID) ON DELETE CASCADE 

                                NOT NULL,

    Association    NVARCHAR(37)         REFERENCES Components (UID) 

CREATE TABLE Attributes (

    UID                 NVARCHAR (37) PRIMARY KEY,

    Components_UID      NVARCHAR (37) NOT NULL

                                     REFERENCES Components (UID) ON DELETE CASCADE, 

    SymbolAttribute_UID NVARCHAR (37) NOT NULL,

    Value               NVARCHAR (1024),

CREATE TABLE LineNoAttributes (

    UID                NVARCHAR (37) PRIMARY KEY,

    Components_UID     NVARCHAR (37) NOT NULL

                                    REFERENCES Components (UID) ON DELETE CASCADE, 

    LineProperties_UID NVARCHAR (37) NOT NULL,

    Value              NVARCHAR(MAX),

    Drawings_UID NVARCHAR (37) REFERENCES Drawings (UID) 

                              NOT NULL,

    Type         NVARCHAR(MAX),

    Owner        NVARCHAR (37) REFERENCES Components (UID) ON DELETE CASCADE 

                              NOT NULL,

    [Index]      INTEGER      NOT NULL

    PipeRuns_UID   NVARCHAR (37) REFERENCES PipeRuns (UID) 

                                NOT NULL,

    [Index]        INTEGER      NOT NULL,

    Components_UID NVARCHAR (37) REFERENCES Components (UID) ON DELETE CASCADE 

                                NOT NULL

);

    CONSTRAINT FK_Components_UID FOREIGN KEY (

        Components_UID

    )

    REFERENCES Components (UID) ON DELETE CASCADE, 

    UNIQUE (

        Components_UID,

CREATE TABLE TitleBlockValues (

    UID                      NVARCHAR (37) PRIMARY KEY,

    TitleBlockProperties_UID NVARCHAR (37) REFERENCES TitleBlockProperties (UID),

    VALUE                    NVARCHAR(MAX)

);