CREATE TABLE `Products` ( `id` int PRIMARY KEY, `name` varchar(255), `qty` varchar(255), `flavour_id` int, FOREIGN KEY(`flavour_id`) REFERENCES `flavours` (`id`) ); CREATE TABLE `stock movement` ( `product_id` int, `qty` varchar(255), `direction` varchar(255), `created_at` datetime, FOREIGN KEY(`product_id`) REFERENCES `Products` (`id`) ); CREATE TABLE `flavours` ( `id` int, `name` varchar(255), `supplier` varchar(255), `box_size` int, `price` varchar, `min` varchar(255), `max` varchar(255) );