-- Tables

/***** Object:  Table VCLib.T_RESERVED_WORD_SET *****/
CREATE TABLE VCLib.T_RESERVED_WORD_SET
(
    "reservedwordsetid" uuid NOT NULL,
    "name" varchar(255) NOT NULL,
    "entity" integer NOT NULL,
    "lexem" varchar NULL
);

-- Alters

ALTER TABLE VCLib.T_RESERVED_WORD_SET ADD CONSTRAINT PK_T_RESERVED_WORD_SET
PRIMARY KEY (ReservedWordSetID);

ALTER TABLE VCLib.T_RESERVED_WORD_SET ADD CONSTRAINT FK_T_ENTITIES_T_RESERVED_WORD_SET_Entity
FOREIGN KEY("entity") REFERENCES VCLib.T_ENTITIES (EntityID);

-- Tables

/***** Object:  Table VCLib.T_RESERVED_WORD *****/
CREATE TABLE VCLib.T_RESERVED_WORD
(
    "reservedwordid" uuid NOT NULL,
    "name" varchar(255) NOT NULL,
    "reservedwordset" uuid NOT NULL,
    "path" varchar(255) NULL,
    "code" varchar(255) NULL
);

-- Alters

ALTER TABLE VCLib.T_RESERVED_WORD ADD CONSTRAINT PK_T_RESERVED_WORD
PRIMARY KEY (ReservedWordID);

ALTER TABLE VCLib.T_RESERVED_WORD ADD CONSTRAINT FK_T_RESERVED_WORD_SET_T_RESERVED_WORD_ReservedWordSet
FOREIGN KEY("reservedwordset") REFERENCES VCLib.T_RESERVED_WORD_SET (ReservedWordSetID);
