CREATE TABLE "Isik" (
	"perenimi" character varying(50),
	"eesnimi" character varying(50) NOT NULL,
	"isanimi" character varying(50),
	"sugu" char(1) NOT NULL,
	"vanus" numeric,
	"synniaeg" DATE,
	"suhe_leibkonnapeaga" character varying,
	"markus" TEXT,
	"isik_id" serial NOT NULL,
	"leibkond" integer NOT NULL,
	CONSTRAINT "Isik_pk" PRIMARY KEY ("isik_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Leidumine" (
	"leidumine_id" serial NOT NULL,
	"lehed" character varying,
	"leibkond" integer NOT NULL,
	"allikas" integer NOT NULL,
	CONSTRAINT "Leidumine_pk" PRIMARY KEY ("leidumine_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Arhiiviallikas" (
	"allikas_id" serial NOT NULL,
	"nimetus" TEXT NOT NULL,
	"viide" TEXT NOT NULL,
	CONSTRAINT "Arhiiviallikas_pk" PRIMARY KEY ("allikas_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Leibkond" (
	"leibkond_id" serial NOT NULL,
	"vara_vaartus" numeric,
	"elukoht" integer NOT NULL,
	"sihtkoht" integer NOT NULL,
	"ymberkirjutus" integer NOT NULL,
	CONSTRAINT "Leibkond_pk" PRIMARY KEY ("leibkond_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Elukoht" (
	"elukoht_id" serial NOT NULL,
	"nimi" character varying(100) NOT NULL,
	"kihelkond" integer NOT NULL,
	CONSTRAINT "Elukoht_pk" PRIMARY KEY ("elukoht_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Maakond" (
	"maakond_id" serial NOT NULL,
	"nimi" character varying(50) NOT NULL,
	CONSTRAINT "Maakond_pk" PRIMARY KEY ("maakond_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Sihtkoht" (
	"sihtkoht_id" serial NOT NULL,
	"kubermang" character varying(50),
	"maakond" character varying(50),
	"kyla" character varying(50),
	"asundus" character varying(50),
	"vald" character varying(50),
	"linn" character varying(50),
	CONSTRAINT "Sihtkoht_pk" PRIMARY KEY ("sihtkoht_id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Kihelkond" (
	"kihelkond_id" serial NOT NULL,
	"nimi" character varying NOT NULL,
	"maakond_id" integer NOT NULL,
	CONSTRAINT "Kihelkond_pk" PRIMARY KEY ("kihelkond_id")
) WITH (
  OIDS=FALSE
);



ALTER TABLE "Isik" ADD CONSTRAINT "Isik_fk0" FOREIGN KEY ("leibkond") REFERENCES "Leibkond"("leibkond_id");

ALTER TABLE "Leidumine" ADD CONSTRAINT "Leidumine_fk0" FOREIGN KEY ("leibkond") REFERENCES "Leibkond"("leibkond_id");
ALTER TABLE "Leidumine" ADD CONSTRAINT "Leidumine_fk1" FOREIGN KEY ("allikas") REFERENCES "Arhiiviallikas"("allikas_id");


ALTER TABLE "Leibkond" ADD CONSTRAINT "Leibkond_fk0" FOREIGN KEY ("elukoht") REFERENCES "Elukoht"("elukoht_id");
ALTER TABLE "Leibkond" ADD CONSTRAINT "Leibkond_fk1" FOREIGN KEY ("sihtkoht") REFERENCES "Sihtkoht"("sihtkoht_id");

ALTER TABLE "Elukoht" ADD CONSTRAINT "Elukoht_fk0" FOREIGN KEY ("kihelkond") REFERENCES "Kihelkond"("kihelkond_id");



ALTER TABLE "Kihelkond" ADD CONSTRAINT "Kihelkond_fk0" FOREIGN KEY ("maakond_id") REFERENCES "Maakond"("maakond_id");