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