CREATE TABLE `app` (
	`id` int PRIMARY KEY,
	`title` varchar(255),
	`` int,
	`description` longtext,
	`web_link` longtext,
	`support_link` longtext,
	`` int,
	`` int,
	`` int,
	`category_id` int,
	FOREIGN KEY(``) REFERENCES `author` (``),
	FOREIGN KEY(`category_id`) REFERENCES `category` (``)
);
CREATE TABLE `category` (
	`id` int PRIMARY KEY,
	`name` varchar(255)
);
CREATE TABLE `screen` (
	`id` int PRIMARY KEY,
	`src` longtext,
	`device` varchar(255),
	`app_id` int,
	FOREIGN KEY(`app_id`) REFERENCES `app` (`id`)
);
CREATE TABLE `icon` (
	`id` int PRIMARY KEY,
	`src` longtext,
	`app_id` int,
	FOREIGN KEY(`app_id`) REFERENCES `app` (`id`)
);
CREATE TABLE `author` (
	`id` int PRIMARY KEY,
	`name` varchar(255),
	`profile_link` longtext
);
CREATE TABLE `author_app` (
	`id` int PRIMARY KEY,
	`author_id` int,
	`app_id` int,
	FOREIGN KEY(`author_id`) REFERENCES `author` (`id`),
	FOREIGN KEY(`app_id`) REFERENCES `app` (`id`)
);