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`)
);