CREATE TABLE "apps" (
	"id" int PRIMARY KEY,
	"show" int CONSTRAINT shows_id REFERENCES shows(id),
	"name" varchar(255),
	"link" varchar(255),
	"image" varchar(255),
	"provider" int CONSTRAINT providers_id REFERENCES providers(id),
	"price" varchar,
	"" datetime,
	"like" int,
	"" datetime,
	"date_added" datetime
);
CREATE TABLE "providers" (
	"id" int PRIMARY KEY,
	"full_name" varchar(255),
	"short_name" varchar(255),
	"image" varchar(255),
	"social" varchar(255),
	"created_at" datetime,
	"" datetime
);
CREATE TABLE "shows" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"description" varchar(255),
	"air_date" datetime,
	"podcast_url" varchar(255),
	"" datetime,
	"" datetime
);