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

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

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

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

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

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

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

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

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

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

CREATE TABLE Menu_Category (ID int IDENTITY NOT NULL, Menu_ID int NOT NULL, Category_ID int NOT NULL, Description varchar(255) NULL, 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)