bundesfeeds-3.0.sql

CREATE TABLE "Persons" (
	"id" serial NOT NULL,
	"firstname" TEXT NOT NULL,
	"lastname" TEXT NOT NULL,
	"created" DATE NOT NULL,
	CONSTRAINT Persons_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Parties" (
	"id" serial NOT NULL,
	"name" TEXT NOT NULL,
	"shortname" TEXT NOT NULL,
	"created" DATE NOT NULL,
	CONSTRAINT Parties_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Membership" (
	"id" serial NOT NULL,
	"parties_id" bigint NOT NULL,
	"persons_id" bigint NOT NULL,
	"created" DATE NOT NULL,
	CONSTRAINT Membership_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Urls" (
	"id" serial NOT NULL,
	"url" TEXT NOT NULL UNIQUE,
	"created" DATE NOT NULL,
	CONSTRAINT Urls_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Links" (
	"id" serial NOT NULL,
	"from_urls_id" serial NOT NULL,
	"to_urls_id" serial NOT NULL,
	"created" DATE NOT NULL,
	CONSTRAINT Links_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Meta" (
	"id" serial NOT NULL,
	"urls_id" bigint NOT NULL,
	"name" TEXT NOT NULL,
	"value" TEXT NOT NULL,
	"created" TEXT NOT NULL,
	CONSTRAINT Meta_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "TextExtracts" (
	"id" serial NOT NULL,
	"urls_id" bigint NOT NULL,
	"text" TEXT NOT NULL,
	"created" bigint NOT NULL,
	CONSTRAINT TextExtracts_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "Images" (
	"id" serial NOT NULL,
	"url" TEXT NOT NULL,
	"created" DATE NOT NULL,
	CONSTRAINT Images_pk PRIMARY KEY ("id")
) WITH (
  OIDS=FALSE
);



CREATE TABLE "UrlsImages" (
	"from_urls_id" bigint NOT NULL,
	"to_image_id" bigint NOT NULL,
	"created" DATE NOT NULL
) WITH (
  OIDS=FALSE
);





ALTER TABLE "Membership" ADD CONSTRAINT "Membership_fk0" FOREIGN KEY ("parties_id") REFERENCES "Parties"("id");
ALTER TABLE "Membership" ADD CONSTRAINT "Membership_fk1" FOREIGN KEY ("persons_id") REFERENCES "Persons"("id");


ALTER TABLE "Links" ADD CONSTRAINT "Links_fk0" FOREIGN KEY ("from_urls_id") REFERENCES "Urls"("id");
ALTER TABLE "Links" ADD CONSTRAINT "Links_fk1" FOREIGN KEY ("to_urls_id") REFERENCES "Urls"("id");

ALTER TABLE "Meta" ADD CONSTRAINT "Meta_fk0" FOREIGN KEY ("urls_id") REFERENCES "Urls"("id");

ALTER TABLE "TextExtracts" ADD CONSTRAINT "TextExtracts_fk0" FOREIGN KEY ("urls_id") REFERENCES "Urls"("id");


ALTER TABLE "UrlsImages" ADD CONSTRAINT "UrlsImages_fk0" FOREIGN KEY ("from_urls_id") REFERENCES "Urls"("id");
ALTER TABLE "UrlsImages" ADD CONSTRAINT "UrlsImages_fk1" FOREIGN KEY ("to_image_id") REFERENCES "Images"("id");