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