CREATE TABLE "domains" ( "id" int PRIMARY KEY, "domain_url" varchar(255), "time" varchar(255) ); CREATE TABLE "pagelinks" ( "id" int PRIMARY KEY, "page_url" varchar(255), "domain_id" int CONSTRAINT domains_id REFERENCES domains(id) ); CREATE TABLE "a_title" ( "id" int PRIMARY KEY, "atag" varchar(255), "atitle" varchar(255), "status" int, "pagelinks_id5" int CONSTRAINT pagelinks_id REFERENCES pagelinks(id) ); CREATE TABLE "atag" ( "id" int PRIMARY KEY, "atag_url" varchar(255) CONSTRAINT atag_url REFERENCES atag(url), "status" int, "pagelinks_id2" int CONSTRAINT pagelinks_id REFERENCES pagelinks(id) ); CREATE TABLE "image" ( "id" int PRIMARY KEY, "image_url" varchar(255) CONSTRAINT image_url REFERENCES image(url), "status" int, "pagelinks_id" int CONSTRAINT pagelinks_id REFERENCES pagelinks(id) ); CREATE TABLE "image_alt" ( "id" int PRIMARY KEY, "img" varchar(255), "alt" varchar(255), "status" int, "pagelinks_id4" int CONSTRAINT pagelinks_id REFERENCES pagelinks(id) ); CREATE TABLE "metatag" ( "id" int PRIMARY KEY, "key" varchar(255), "status" int, "value" varchar(255), "paglinks_id3" int CONSTRAINT pagelinks_id REFERENCES pagelinks(id) );