CREATE TABLE Bar_Code (ID int(10) NOT NULL AUTO_INCREMENT, Item_ID int(10) NOT NULL, Bar_Code blob NOT NULL UNIQUE, Is_Active varchar(1) NOT NULL, Description varchar(255), PRIMARY KEY (ID))

CREATE TABLE City (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL, Region_ID int(10) NOT NULL, Time_Zone_ID int(10) NOT NULL, Zip_Code int(30), PRIMARY KEY (ID), CONSTRAINT UK_City UNIQUE (Name, Region_ID))

CREATE TABLE Country (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, PRIMARY KEY (ID))

CREATE TABLE Currency (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Short_Name varchar(15) NOT NULL UNIQUE, Symbol varchar(5) NOT NULL UNIQUE, Description varchar(255), PRIMARY KEY (ID))

CREATE TABLE Customer (ID int(10) NOT NULL AUTO_INCREMENT, City_ID int(10) NOT NULL, Code varchar(25) NOT NULL, Phone varchar(50) NOT NULL UNIQUE, First_Name varchar(50) NOT NULL, Last_Name varchar(50) NOT NULL, Is_Company varchar(1) NOT NULL, Company_Name varchar(255), Tax_Number varchar(50), Is_Tax_Exempted varchar(1) NOT NULL, Billing_Address varchar(255) NOT NULL, Postal_Code varchar(50), Is_Registered_Online varchar(1) NOT NULL, Email varchar(50) UNIQUE, Username varchar(50) UNIQUE, Password binary(255), Credit decimal(14, 2), Created_Emp_Login_ID int(10), Created_At_Store_ID int(10), Created_Time timestamp NOT NULL, Last_Login_Time timestamp NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Delivery_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 Discount (ID int(10) NOT NULL AUTO_INCREMENT, Discount_Type_ID int(10) NOT NULL, Item_Category_ID int(10), Item_ID int(10), Description varchar(255), Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Discount_Type (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Name varchar(50) NOT NULL, Description varchar(255), Is_Percentage varchar(1) NOT NULL, Value decimal(15, 3) NOT NULL, Created_Time timestamp NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, Loyalty_Card_Type_ID int(10), Coupon_Code varchar(50), Min_Order_Value decimal(15, 3) NOT NULL, Min_Item_Quantity int(10) NOT NULL, Apply_To_All varchar(1) NOT NULL, Apply_To_Next varchar(1) NOT NULL, Max_Discount_Value decimal(15, 3) NOT NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Employee_Login (ID int(10) NOT NULL AUTO_INCREMENT, Employee_ID int(10) NOT NULL, Employee_Role_ID int(10) NOT NULL, Login_Time timestamp NOT NULL, Logout_Time timestamp NULL, Device_IP varchar(50) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Item (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Item_Category_ID int(10) NOT NULL, Supplier_ID int(10) NOT NULL, Unit_Of_Measure_ID int(10) NOT NULL, SKU_Code varchar(25) NOT NULL UNIQUE, Name varchar(50) NOT NULL, Description varchar(255), Is_Service varchar(1) NOT NULL, In_Stock varchar(1) NOT NULL, Using_Default_Quantity varchar(1) NOT NULL, Default_Quantity int(10), Current_Stock_Quantity int(10) NOT NULL, Preferred_Stock_Quantity int(10) NOT NULL, Min_Stock_Quantity int(10) NOT NULL, Low_Stock_Warning varchar(1) NOT NULL, Low_Stock_Quantity int(10), Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

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

CREATE TABLE Language (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Short_Name varchar(15) NOT NULL UNIQUE, Description varchar(255), PRIMARY KEY (ID))

CREATE TABLE Order_Header (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Sales_Channel_ID int(10) NOT NULL, Delivery_Type_ID int(10) NOT NULL, Payment_Method_ID int(10) NOT NULL, Payment_Time_ID int(10) NOT NULL, Order_No varchar(50) NOT NULL UNIQUE, Customer_ID int(10), Loyalty_Card_ID int(10), Created_Emp_Login_ID int(10), Created_Customer_ID int(10), Created_Time timestamp NOT NULL, Approved_Emp_Login_ID int(10), Managed_Emp_Login_ID int(10), Customer_Notes varchar(255), Price_Before_Tax decimal(15, 3) NOT NULL, Total_Tax_Value decimal(15, 3) NOT NULL, Price_After_Tax int(10) NOT NULL, Price_Before_Discount decimal(15, 3) NOT NULL, Order_Items_Discount decimal(15, 3) NOT NULL, Order_Discount decimal(15, 3) NOT NULL, Total_Discount_Value decimal(15, 3) NOT NULL, Price_After_Discount decimal(15, 3) NOT NULL, Price_Adjustment decimal(15, 3), Price_Adjustment_Reason varchar(255), Price decimal(15, 3) NOT NULL, Latest_Status varchar(50) NOT NULL, Latest_Status_Update timestamp NOT NULL, Is_Submitted varchar(1) NOT NULL, Submitted_Time timestamp NULL, Is_Approved varchar(1) NOT NULL, Approved_Time timestamp NULL, Is_Canceled varchar(1) NOT NULL, Canceled_Time timestamp NULL, Cancel_Reason varchar(255), Is_Scheduled varchar(1) NOT NULL, Scheduled_Time timestamp NULL, Is_Ready varchar(1) NOT NULL, Ready_Time timestamp NULL, Is_Delivered varchar(1) NOT NULL, Delivered_Time timestamp NULL, Is_Paid varchar(1) NOT NULL, Payment_Time timestamp NULL, Is_Completed varchar(1) NOT NULL, Completed_Time timestamp NULL, Return_Required varchar(1) NOT NULL, Return_Time timestamp NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Order_Line (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Order_ID int(10) NOT NULL, Item_ID int(10) NOT NULL, Line_No varchar(50) NOT NULL, Description varchar(255), Customer_Notes varchar(255), Quantity int(10) NOT NULL, Current_Item_Cost decimal(15, 3) NOT NULL, Markup_Percentage int(3) NOT NULL, Price_Before_Tax decimal(15, 3) NOT NULL, Tax_Value decimal(15, 3) NOT NULL, Price_After_Tax decimal(15, 3) NOT NULL, Price_Before_Discount decimal(15, 3) NOT NULL, Discount_Value decimal(15, 3) NOT NULL, Price_After_Discount decimal(15, 3) NOT NULL, Price_Adjustment decimal(15, 3), Price_Adjustment_Reason varchar(255), Price decimal(15, 3) NOT NULL, Is_Canceled varchar(1) NOT NULL, Canceled_Time timestamp NULL, Cancel_Reason varchar(255), Return_Required varchar(1) NOT NULL, Return_Quantity int(10), Return_Time timestamp NULL, Customer_Review varchar(255), Customer_Like varchar(1), Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Order_Status (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 Order_Status_History (ID int(10) NOT NULL AUTO_INCREMENT, Order_ID int(10) NOT NULL, Order_Status_ID int(10) NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, PRIMARY KEY (ID))

CREATE TABLE Payment_Method (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Code varchar(25) NOT NULL UNIQUE, Sequence_No int(3), Is_Active varchar(1) NOT NULL, Is_Customer_Required varchar(1) NOT NULL, Description varchar(255), PRIMARY KEY (ID))

CREATE TABLE Payment_Term (ID int(10) NOT NULL AUTO_INCREMENT, Sales_Channel_ID int(10) NOT NULL, Delivery_Type_ID int(10) NOT NULL, Payment_Method_ID int(10) NOT NULL, Payment_Time_ID int(10) NOT NULL, Is_Allowed varchar(1) NOT NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID), CONSTRAINT UK_Payment_Term UNIQUE (Sales_Channel_ID, Delivery_Type_ID, Payment_Method_ID, Payment_Time_ID))

CREATE TABLE Payment_Time (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 Price (ID int(10) NOT NULL AUTO_INCREMENT, Item_ID int(10) NOT NULL, Store_ID int(10) NOT NULL, Description varchar(255), Current_Item_Cost decimal(15, 3) NOT NULL, Markup_percentage int(3) NOT NULL, Price_Before_Tax decimal(15, 3) NOT NULL, Tax_Value decimal(15, 3) NOT NULL, Price_After_Tax decimal(15, 3) NOT NULL, Sale_Price decimal(15, 3) NOT NULL, Price_Change_Allowed varchar(1) NOT NULL, Created_Time timestamp NOT NULL, Created_Emp_Login_ID int(10) NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Region (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL, Country_ID int(10) NOT NULL, PRIMARY KEY (ID), CONSTRAINT UK_Region UNIQUE (Name, Country_ID))

CREATE TABLE Sales_Channel (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 Setting (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Default_Payment_Method_ID int(10), Default_Tax_Type_ID int(10), Default_Quantity int(10), In_Stock_Check varchar(1) NOT NULL, Negative_Stock_Allowed varchar(1) NOT NULL, Price_Includes_Tax varchar(1) NOT NULL, Negative_Price_Allowed varchar(1) NOT NULL, Moving_Average_Price varchar(1) NOT NULL, Discount_Before_Tax varchar(1) NOT NULL, Default_Due_Days int(10), Decimal_Places int(2), Public_Reviews_Allowed varchar(1) NOT NULL, Created_Time timestamp NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Store (ID int(10) NOT NULL AUTO_INCREMENT, City_ID int(10) NOT NULL, Language_ID int(10) NOT NULL, Currency_ID int(10) NOT NULL, Admin_User_ID int(10) NOT NULL, Code varchar(25) UNIQUE, Name varchar(50) NOT NULL UNIQUE, Is_Active varchar(1) NOT NULL, Legal_Entity_Name varchar(255) NOT NULL, Tax_Code varchar(50) NOT NULL, Address varchar(255) NOT NULL, Registration_Number varchar(50) NOT NULL, GPS_Location varchar(50), Postal_Code varchar(50), Phone varchar(50), Fax varchar(50), Email varchar(50), Website varchar(255), Logo blob, Bank_Branch varchar(255), Bank_Code varchar(50), Bank_Account varchar(50), Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Supplier (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, City_ID int(10) NOT NULL, Code varchar(10) NOT NULL UNIQUE, Phone varchar(50) NOT NULL, First_Name varchar(50) NOT NULL, Last_Name varchar(50) NOT NULL, Is_Company varchar(1) NOT NULL, Company_Name varchar(255), Tax_Number varchar(50), Is_Tax_Exempted varchar(1) NOT NULL, Billing_Address varchar(255) NOT NULL, Postal_Code varchar(50), Email varchar(50) NOT NULL, Created_Emp_Login_ID int(10) NOT NULL, Created_Time timestamp NOT NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID))

CREATE TABLE Supplier_Item_Tax_Type (ID int(10) NOT NULL AUTO_INCREMENT, Item_ID int(10) NOT NULL, Supplier_Tax_Type_ID int(10) NOT NULL, Created_Time timestamp NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, Description varchar(255), PRIMARY KEY (ID))

CREATE TABLE Supplier_Tax_Type (ID int(10) NOT NULL AUTO_INCREMENT, Supplier_ID int(10) NOT NULL, Name varchar(50) NOT NULL, Code varchar(25) NOT NULL, Description varchar(255), Is_Percentage varchar(1) NOT NULL, Value decimal(15, 3) NOT NULL, Created_Time timestamp NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID), CONSTRAINT UK_Supplier_Name UNIQUE (Supplier_ID, Name), CONSTRAINT UK_Supplier_Code UNIQUE (Supplier_ID, Code))

CREATE TABLE Tax_Type (ID int(10) NOT NULL AUTO_INCREMENT, Store_ID int(10) NOT NULL, Name varchar(50) NOT NULL, Code varchar(25) NOT NULL, Description varchar(255), Is_Percentage varchar(1) NOT NULL, Value decimal(15, 3) NOT NULL, Created_Time timestamp NOT NULL, Start_Time timestamp NOT NULL, End_Time timestamp NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000), PRIMARY KEY (ID), CONSTRAINT UK_Store_Name UNIQUE (Store_ID, Name), CONSTRAINT UK_Store_Code UNIQUE (Store_ID, Code))

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

CREATE TABLE Unit_Of_Measure (ID int(10) NOT NULL AUTO_INCREMENT, Name varchar(50) NOT NULL UNIQUE, Symbol varchar(15) NOT NULL UNIQUE, Description varchar(255), PRIMARY KEY (ID))

ALTER TABLE Bar_Code ADD CONSTRAINT FK_Bar_Code_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE City ADD CONSTRAINT FK_City_Region FOREIGN KEY (Region_ID) REFERENCES Region (ID)

ALTER TABLE City ADD CONSTRAINT FK_City_Time_Zone FOREIGN KEY (Time_Zone_ID) REFERENCES Time_Zone (ID)

ALTER TABLE Customer ADD CONSTRAINT FK_Customer_City FOREIGN KEY (City_ID) REFERENCES City (ID)

ALTER TABLE Customer ADD CONSTRAINT FK_Customer_Created_Emp_Login FOREIGN KEY (Created_Emp_Login_ID) REFERENCES Employee_Login (ID)

ALTER TABLE Customer ADD CONSTRAINT FK_Customer_Store FOREIGN KEY (Created_At_Store_ID) REFERENCES Store (ID)

ALTER TABLE Discount ADD CONSTRAINT FK_Discount_Discount_Type FOREIGN KEY (Discount_Type_ID) REFERENCES Discount_Type (ID)

ALTER TABLE Discount ADD CONSTRAINT FK_Discount_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Discount ADD CONSTRAINT FK_Discount_Item_Category FOREIGN KEY (Item_Category_ID) REFERENCES Item_Category (ID)

ALTER TABLE Discount_Type ADD CONSTRAINT FK_Discount_Type_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Item_Category ADD CONSTRAINT FK_Item_Category_Item_Category FOREIGN KEY (Parent_Category_ID) REFERENCES Item_Category (ID)

ALTER TABLE Item ADD CONSTRAINT FK_Item_Item_Category FOREIGN KEY (Item_Category_ID) REFERENCES Item_Category (ID)

ALTER TABLE Item ADD CONSTRAINT FK_Item_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Item ADD CONSTRAINT FK_Item_Supplier FOREIGN KEY (Supplier_ID) REFERENCES Supplier (ID)

ALTER TABLE Item ADD CONSTRAINT FK_Item_Unit_Of_Measure FOREIGN KEY (Unit_Of_Measure_ID) REFERENCES Unit_Of_Measure (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Approved_Emp_Login FOREIGN KEY (Approved_Emp_Login_ID) REFERENCES Employee_Login (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Created_Customer FOREIGN KEY (Created_Customer_ID) REFERENCES Customer (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Created_Emp_Login FOREIGN KEY (Created_Emp_Login_ID) REFERENCES Employee_Login (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Customer FOREIGN KEY (Customer_ID) REFERENCES Customer (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Delivery_Type FOREIGN KEY (Delivery_Type_ID) REFERENCES Delivery_Type (ID)

ALTER TABLE Order_Line ADD CONSTRAINT FK_Order_Line_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Order_Line ADD CONSTRAINT FK_Order_Line_Order FOREIGN KEY (Order_ID) REFERENCES Order_Header (ID)

ALTER TABLE Order_Line ADD CONSTRAINT FK_Order_Line_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Loyalty_Card FOREIGN KEY (Loyalty_Card_ID) REFERENCES Loyalty_Card (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Managed_Emp_Login FOREIGN KEY (Managed_Emp_Login_ID) REFERENCES Employee_Login (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Payment_Method FOREIGN KEY (Payment_Method_ID) REFERENCES Payment_Method (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Payment_Time FOREIGN KEY (Payment_Time_ID) REFERENCES Payment_Time (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Sales_Channel FOREIGN KEY (Sales_Channel_ID) REFERENCES Sales_Channel (ID)

ALTER TABLE Order_Status_History ADD CONSTRAINT FK_Order_Status_History_Order FOREIGN KEY (Order_ID) REFERENCES Order_Header (ID)

ALTER TABLE Order_Status_History ADD CONSTRAINT FK_Order_Status_History_Order_Status FOREIGN KEY (Order_Status_ID) REFERENCES Order_Status (ID)

ALTER TABLE Order_Header ADD CONSTRAINT FK_Order_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Payment_Term ADD CONSTRAINT FK_Payment_Term_Delivery_Type FOREIGN KEY (Delivery_Type_ID) REFERENCES Delivery_Type (ID)

ALTER TABLE Payment_Term ADD CONSTRAINT FK_Payment_Term_Payment_Method FOREIGN KEY (Payment_Method_ID) REFERENCES Payment_Method (ID)

ALTER TABLE Payment_Term ADD CONSTRAINT FK_Payment_Term_Payment_Time FOREIGN KEY (Payment_Time_ID) REFERENCES Payment_Time (ID)

ALTER TABLE Payment_Term ADD CONSTRAINT FK_Payment_Term_Sales_Channel FOREIGN KEY (Sales_Channel_ID) REFERENCES Sales_Channel (ID)

ALTER TABLE Price ADD CONSTRAINT FK_Price_Employee_Login FOREIGN KEY (Created_Emp_Login_ID) REFERENCES Employee_Login (ID)

ALTER TABLE Price ADD CONSTRAINT FK_Price_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Price ADD CONSTRAINT FK_Price_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Region ADD CONSTRAINT FK_Region_Country FOREIGN KEY (Country_ID) REFERENCES Country (ID)

ALTER TABLE Setting ADD CONSTRAINT FK_Setting_Payment_Method FOREIGN KEY (Default_Payment_Method_ID) REFERENCES Payment_Method (ID)

ALTER TABLE Setting ADD CONSTRAINT FK_Setting_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Setting ADD CONSTRAINT FK_Setting_Tax_Type FOREIGN KEY (Default_Tax_Type_ID) REFERENCES Tax_Type (ID)

ALTER TABLE Store ADD CONSTRAINT FK_Store_City FOREIGN KEY (City_ID) REFERENCES City (ID)

ALTER TABLE Store ADD CONSTRAINT FK_Store_Currency FOREIGN KEY (Currency_ID) REFERENCES Currency (ID)

ALTER TABLE Store ADD CONSTRAINT FK_Store_Language FOREIGN KEY (Language_ID) REFERENCES Language (ID)

ALTER TABLE Supplier ADD CONSTRAINT FK_Supplier_City FOREIGN KEY (City_ID) REFERENCES City (ID)

ALTER TABLE Supplier ADD CONSTRAINT FK_Supplier_Created_Emp_Login FOREIGN KEY (Created_Emp_Login_ID) REFERENCES Employee_Login (ID)

ALTER TABLE Supplier_Item_Tax_Type ADD CONSTRAINT FK_Supplier_Item_Tax_Type_Item FOREIGN KEY (Item_ID) REFERENCES Item (ID)

ALTER TABLE Supplier_Item_Tax_Type ADD CONSTRAINT FK_Supplier_Item_Tax_Type_Supplier_Tax_Type FOREIGN KEY (Supplier_Tax_Type_ID) REFERENCES Supplier_Tax_Type (ID)

ALTER TABLE Supplier ADD CONSTRAINT FK_Supplier_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)

ALTER TABLE Supplier_Tax_Type ADD CONSTRAINT FK_Supplier_Tax_Type_Supplier FOREIGN KEY (Supplier_ID) REFERENCES Supplier (ID)

ALTER TABLE Tax_Type ADD CONSTRAINT FK_Tax_Type_Store FOREIGN KEY (Store_ID) REFERENCES Store (ID)