CREATE TABLE "Files" (
    "Id" serial NOT NULL,
    "Urn" char(100) NOT NULL,
    "Version" char(100) NOT NULL,
    CONSTRAINT "Files_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Elements" (
    "Id" serial NOT NULL,
    "FileID" serial NOT NULL,
    "Name" char(50) NOT NULL,
    "RvtId" int NOT NULL,
    "StateID" serial,
    "BuildingTimeID" serial,
    CONSTRAINT "Elements_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Parameters" (
    "Id" serial NOT NULL,
    "Name" char(50) NOT NULL,
    "ElementId" serial NOT NULL,
    "type" int,
    "value" bytea,
    CONSTRAINT "Parameters_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "BuildingTimes" (
    "Id" serial NOT NULL,
    "Start" DATE,
    "End" DATE,
    CONSTRAINT "BuildingTimes_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "States" (
    "Id" serial NOT NULL,
    "WorkType" char(50),
    "WorkGroup" char(50),
    "WorkTypes" char(50),
    "Norms" char(50),
    "WorkPeriod" char(50),
    CONSTRAINT "States_pk" PRIMARY KEY ("Id")
) WITH (
  OIDS=FALSE
);




ALTER TABLE "Elements" ADD CONSTRAINT "Elements_fk0" FOREIGN KEY ("FileID") REFERENCES "Files"("Id");
ALTER TABLE "Elements" ADD CONSTRAINT "Elements_fk1" FOREIGN KEY ("StateID") REFERENCES "States"("Id");
ALTER TABLE "Elements" ADD CONSTRAINT "Elements_fk2" FOREIGN KEY ("BuildingTimeID") REFERENCES "BuildingTimes"("Id");

ALTER TABLE "Parameters" ADD CONSTRAINT "Parameters_fk0" FOREIGN KEY ("ElementId") REFERENCES "Elements"("Id");