CREATE TABLE `Food` ( `uuid` varchar(255) PRIMARY KEY, `name` varchar(255), `description` varchar(255), `position` int, `category_uuid` varchar(255), FOREIGN KEY(`category_uuid`) REFERENCES `Category` (`uuid`) ); CREATE TABLE `Additional Info` ( `uuid` varchar(255) PRIMARY KEY, `type` varchar(255), `label` varchar(255), `value` varchar(255), `food_uuid` int, FOREIGN KEY(`food_uuid`) REFERENCES `Food` (`uuid`) ); CREATE TABLE `Image` ( `uuid` varchar(255) PRIMARY KEY, `photo` varchar(255), `food_uuid` varchar(255), `priority` bool, `menu_photo_uuid` varchar(255), FOREIGN KEY(`food_uuid`) REFERENCES `Food` (`uuid`), FOREIGN KEY(`menu_photo_uuid`) REFERENCES `Menu Photo` (`uuid`) ); CREATE TABLE `Category` ( `uuid` varchar(255) PRIMARY KEY, `name` varchar(255), `position` int ); CREATE TABLE `Menu Photo` ( `uuid` varchar(255) PRIMARY KEY, `position` int ); CREATE TABLE `Delivery` ( `uuid` varchar(255) PRIMARY KEY, `location` varchar(255), `price` varchar(255), `phone` varchar(255), `currency_symbol` varchar(255), `food_uuid` varchar(255), FOREIGN KEY(`food_uuid`) REFERENCES `Food` (`uuid`) );