CREATE TABLE "app" (
	"id" int PRIMARY KEY,
	"title" varchar(255),
	"" int CONSTRAINT author_ REFERENCES author(),
	"description" longtext,
	"web_link" longtext,
	"support_link" longtext,
	"" int,
	"" int,
	"" int,
	"category_id" int CONSTRAINT category_ 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 CONSTRAINT app_id REFERENCES app(id)
);
CREATE TABLE "icon" (
	"id" int PRIMARY KEY,
	"src" longtext,
	"app_id" int CONSTRAINT 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 CONSTRAINT author_id REFERENCES author(id),
	"app_id" int CONSTRAINT app_id REFERENCES app(id)
);