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