CREATE TABLE Category (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Description varchar(255), Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Category_Item (ID int(10) NOT NULL AUTO_INCREMENT, Category_ID int(10) NOT NULL, Item_ID int(10) NOT NULL, Description varchar(255), PRIMARY KEY (ID), CONSTRAINT UK_Category_Item UNIQUE (Category_ID, Item_ID))

CREATE TABLE Customization (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Display_Title varchar(50) NOT NULL UNIQUE, Description varchar(255), Is_Active varchar(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Customization_Option (ID int(10) NOT NULL AUTO_INCREMENT, Customization_ID int(10) NOT NULL, Name varchar(50) NOT NULL UNIQUE, Description varchar(255), Is_Active varchar(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Diet_Item (ID int(10) NOT NULL AUTO_INCREMENT, Diet_Type_ID int(10) NOT NULL, Item_ID int(10) NOT NULL, Description varchar(255), PRIMARY KEY (ID), CONSTRAINT UK_Diet_Item UNIQUE (Diet_Type_ID, Item_ID))

CREATE TABLE Diet_Type (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Description varchar(255), Is_Active varchar(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Item (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Description varchar(255), In_Stock varchar(1) NOT NULL, Calories int(10), Ingredients varchar(1000), Recipe varchar(1000), Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Item_Customization (ID int(10) NOT NULL AUTO_INCREMENT, Item_ID int(10) NOT NULL, Customization_ID int(10) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID), CONSTRAINT UK_Item_Customization UNIQUE (Item_ID, Customization_ID))

CREATE TABLE Item_Option (ID int(10) NOT NULL AUTO_INCREMENT, Item_Customization_ID int(10) NOT NULL, Customization_Option_ID int(10) NOT NULL, In_Stock varchar(1) NOT NULL, Default_Quantity int(10) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID), CONSTRAINT UK_Item_Option UNIQUE (Item_Customization_ID, Customization_Option_ID))

CREATE TABLE Menu (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Name varchar(50) NOT NULL UNIQUE, Description varchar(255), Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Menu_Category (ID int(10) NOT NULL AUTO_INCREMENT, Menu_ID int(10) NOT NULL, Category_ID int(10) NOT NULL, Description varchar(255), PRIMARY KEY (ID), CONSTRAINT UK_Menu_Category UNIQUE (Menu_ID, Category_ID))

ALTER TABLE Category_Item ADD CONSTRAINT FK_Category_Item_Category FOREIGN KEY (Category_ID) REFERENCES Category (ID)

ALTER TABLE Category_Item ADD CONSTRAINT FK_Category_Item_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Customization_Option ADD CONSTRAINT FK_Customization_Option_Customization FOREIGN KEY (Customization_ID) REFERENCES Customization (ID)

ALTER TABLE Diet_Item ADD CONSTRAINT FK_Diet_Item_Diet_Type FOREIGN KEY (Diet_Type_ID) REFERENCES Diet_Type (ID)

ALTER TABLE Diet_Item ADD CONSTRAINT FK_Diet_Item_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Item_Customization ADD CONSTRAINT FK_Item_Customization_Customization FOREIGN KEY (Customization_ID) REFERENCES Customization (ID)

ALTER TABLE Item_Customization ADD CONSTRAINT FK_Item_Customization_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Item_Option ADD CONSTRAINT FK_Item_Option_Customization_Option FOREIGN KEY (Customization_Option_ID) REFERENCES Customization_Option (ID)

ALTER TABLE Item_Option ADD CONSTRAINT FK_Item_Option_Item_Customization FOREIGN KEY (Item_Customization_ID) REFERENCES Item_Customization (ID)

ALTER TABLE Menu_Category ADD CONSTRAINT FK_Menu_Category_Category FOREIGN KEY (Category_ID) REFERENCES Category (ID)

ALTER TABLE Menu_Category ADD CONSTRAINT FK_Menu_Category_Menu FOREIGN KEY (Menu_ID) REFERENCES Menu (ID)