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