CREATE TABLE "apps" ( "id" int PRIMARY KEY, "show" int FOREIGN KEY("show") REFERENCES "shows" ("id"), "name" varchar(255), "link" varchar(255), "image" varchar(255), "provider" int FOREIGN KEY("provider") 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 );