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,
	FOREIGN KEY("domain_id") REFERENCES "domains" ("id")
);
CREATE TABLE "a_title" (
	"id" int PRIMARY KEY,
	"atag" varchar(255),
	"atitle" varchar(255),
	"status" int,
	"pagelinks_id5" int,
	FOREIGN KEY("pagelinks_id5") REFERENCES "pagelinks" ("id")
);
CREATE TABLE "atag" (
	"id" int PRIMARY KEY,
	"atag_url" varchar(255),
	"status" int,
	"pagelinks_id2" int,
	FOREIGN KEY("atag_url") REFERENCES "atag" ("url"),
	FOREIGN KEY("pagelinks_id2") REFERENCES "pagelinks" ("id")
);
CREATE TABLE "image" (
	"id" int PRIMARY KEY,
	"image_url" varchar(255),
	"status" int,
	"pagelinks_id" int,
	FOREIGN KEY("image_url") REFERENCES "image" ("url"),
	FOREIGN KEY("pagelinks_id") REFERENCES "pagelinks" ("id")
);
CREATE TABLE "image_alt" (
	"id" int PRIMARY KEY,
	"img" varchar(255),
	"alt" varchar(255),
	"status" int,
	"pagelinks_id4" int,
	FOREIGN KEY("pagelinks_id4") REFERENCES "pagelinks" ("id")
);
CREATE TABLE "metatag" (
	"id" int PRIMARY KEY,
	"key" varchar(255),
	"status" int,
	"value" varchar(255),
	"paglinks_id3" int,
	FOREIGN KEY("paglinks_id3") REFERENCES "pagelinks" ("id")
);