CREATE TABLE "url" ( "url" varchar(255), "ID" int PRIMARY KEY ); CREATE TABLE "result" ( "ID" int, "url_ID" int CONSTRAINT url_ID REFERENCES url(ID), "type" varchar(255), "value" varchar(255), "frm_ID" int CONSTRAINT frm_ID REFERENCES frm(ID) ); CREATE TABLE "frm" ( "ID" int, "firma" varchar(255) );