CREATE TABLE Bar_Code (ID int IDENTITY NOT NULL, Item_ID int NOT NULL, Bar_Code image NOT NULL UNIQUE, Is_Active varchar(1) NOT NULL, Description varchar(255) NULL, PRIMARY KEY (ID))

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

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

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

CREATE TABLE Customer (ID int IDENTITY NOT NULL, City_ID int 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) NULL, Tax_Number varchar(50) NULL, Is_Tax_Exempted varchar(1) NOT NULL, Billing_Address varchar(255) NOT NULL, Postal_Code varchar(50) NULL, Is_Registered_Online varchar(1) NOT NULL, Email varchar(50) NULL UNIQUE, Username varchar(50) NULL UNIQUE, Password binary(255) NULL, Credit decimal(14, 2) NULL, Created_Emp_Login_ID int NULL, Created_At_Store_ID int NULL, Created_Time datetime NOT NULL, Last_Login_Time datetime NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

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

CREATE TABLE Discount_Type (ID int IDENTITY NOT NULL, Store_ID int NOT NULL, Name varchar(50) NOT NULL, Description varchar(255) NULL, Is_Percentage varchar(1) NOT NULL, Value decimal(15, 3) NOT NULL, Created_Time datetime NOT NULL, Start_Time datetime NOT NULL, End_Time datetime NULL, Loyalty_Card_Type_ID int NULL, Coupon_Code varchar(50) NULL, Min_Order_Value decimal(15, 3) NOT NULL, Min_Item_Quantity int 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) NULL, PRIMARY KEY (ID))

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

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

CREATE TABLE Item_Category (ID int IDENTITY NOT NULL, Parent_Category_ID int 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 Language (ID int IDENTITY NOT NULL, Name varchar(50) NOT NULL UNIQUE, Short_Name varchar(15) NOT NULL UNIQUE, Description varchar(255) NULL, PRIMARY KEY (ID))

CREATE TABLE Order_Header (ID int IDENTITY NOT NULL, Store_ID int NOT NULL, Sales_Channel_ID int NOT NULL, Delivery_Type_ID int NOT NULL, Payment_Method_ID int NOT NULL, Payment_Time_ID int NOT NULL, Order_No varchar(50) NOT NULL UNIQUE, Customer_ID int NULL, Loyalty_Card_ID int NULL, Created_Emp_Login_ID int NULL, Created_Customer_ID int NULL, Created_Time datetime NOT NULL, Approved_Emp_Login_ID int NULL, Managed_Emp_Login_ID int NULL, Customer_Notes varchar(255) NULL, Price_Before_Tax decimal(15, 3) NOT NULL, Total_Tax_Value decimal(15, 3) NOT NULL, Price_After_Tax int 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) NULL, Price_Adjustment_Reason varchar(255) NULL, Price decimal(15, 3) NOT NULL, Latest_Status varchar(50) NOT NULL, Latest_Status_Update datetime NOT NULL, Is_Submitted varchar(1) NOT NULL, Submitted_Time datetime NULL, Is_Approved varchar(1) NOT NULL, Approved_Time datetime NULL, Is_Canceled varchar(1) NOT NULL, Canceled_Time datetime NULL, Cancel_Reason varchar(255) NULL, Is_Scheduled varchar(1) NOT NULL, Scheduled_Time datetime NULL, Is_Ready varchar(1) NOT NULL, Ready_Time datetime NULL, Is_Delivered varchar(1) NOT NULL, Delivered_Time datetime NULL, Is_Paid varchar(1) NOT NULL, Payment_Time datetime NULL, Is_Completed varchar(1) NOT NULL, Completed_Time datetime NULL, Return_Required varchar(1) NOT NULL, Return_Time datetime NOT NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

CREATE TABLE Order_Line (ID int IDENTITY NOT NULL, Store_ID int NOT NULL, Order_ID int NOT NULL, Item_ID int NOT NULL, Line_No varchar(50) NOT NULL, Description varchar(255) NULL, Customer_Notes varchar(255) NULL, Quantity int NOT NULL, Current_Item_Cost decimal(15, 3) NOT NULL, Markup_Percentage int 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) NULL, Price_Adjustment_Reason varchar(255) NULL, Price decimal(15, 3) NOT NULL, Is_Canceled varchar(1) NOT NULL, Canceled_Time datetime NULL, Cancel_Reason varchar(255) NULL, Return_Required varchar(1) NOT NULL, Return_Quantity int NULL, Return_Time datetime NULL, Customer_Review varchar(255) NULL, Customer_Like varchar(1) NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

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

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

CREATE TABLE Payment_Term (ID int IDENTITY NOT NULL, Sales_Channel_ID int NOT NULL, Delivery_Type_ID int NOT NULL, Payment_Method_ID int NOT NULL, Payment_Time_ID int NOT NULL, Is_Allowed varchar(1) NOT NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, 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 IDENTITY NOT NULL, Name varchar(50) NOT NULL UNIQUE, Description varchar(255) NULL, Is_Active varchar(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Price (ID int IDENTITY NOT NULL, Item_ID int NOT NULL, Store_ID int NOT NULL, Description varchar(255) NULL, Current_Item_Cost decimal(15, 3) NOT NULL, Markup_percentage int 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 datetime NOT NULL, Created_Emp_Login_ID int NOT NULL, Start_Time datetime NOT NULL, End_Time datetime NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

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

CREATE TABLE Sales_Channel (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 Setting (ID int IDENTITY NOT NULL, Store_ID int NOT NULL, Default_Payment_Method_ID int NULL, Default_Tax_Type_ID int NULL, Default_Quantity int NULL, 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 NULL, Decimal_Places int NULL, Public_Reviews_Allowed varchar(1) NOT NULL, Created_Time datetime NOT NULL, Start_Time datetime NOT NULL, End_Time datetime NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

CREATE TABLE Store (ID int IDENTITY NOT NULL, City_ID int NOT NULL, Language_ID int NOT NULL, Currency_ID int NOT NULL, Admin_User_ID int NOT NULL, Code varchar(25) NULL 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) NULL, Postal_Code varchar(50) NULL, Phone varchar(50) NULL, Fax varchar(50) NULL, Email varchar(50) NULL, Website varchar(255) NULL, Logo image NULL, Bank_Branch varchar(255) NULL, Bank_Code varchar(50) NULL, Bank_Account varchar(50) NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

CREATE TABLE Supplier (ID int IDENTITY NOT NULL, Store_ID int NOT NULL, City_ID int 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) NULL, Tax_Number varchar(50) NULL, Is_Tax_Exempted varchar(1) NOT NULL, Billing_Address varchar(255) NOT NULL, Postal_Code varchar(50) NULL, Email varchar(50) NOT NULL, Created_Emp_Login_ID int NOT NULL, Created_Time datetime NOT NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, PRIMARY KEY (ID))

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

CREATE TABLE Supplier_Tax_Type (ID int IDENTITY NOT NULL, Supplier_ID int NOT NULL, Name varchar(50) NOT NULL, Code varchar(25) NOT NULL, Description varchar(255) NULL, Is_Percentage varchar(1) NOT NULL, Value decimal(15, 3) NOT NULL, Created_Time datetime NOT NULL, Start_Time datetime NOT NULL, End_Time datetime NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, 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 IDENTITY NOT NULL, Store_ID int NOT NULL, Name varchar(50) NOT NULL, Code varchar(25) NOT NULL, Description varchar(255) NULL, Is_Percentage varchar(1) NOT NULL, Value decimal(15, 3) NOT NULL, Created_Time datetime NOT NULL, Start_Time datetime NOT NULL, End_Time datetime NULL, Is_Active varchar(1) NOT NULL, Comments varchar(1000) NULL, 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 IDENTITY NOT NULL, Name varchar(50) NOT NULL UNIQUE, Description varchar(255) NULL, PRIMARY KEY (ID))

CREATE TABLE Unit_Of_Measure (ID int IDENTITY NOT NULL, Name varchar(50) NOT NULL UNIQUE, Symbol varchar(15) NOT NULL UNIQUE, Description varchar(255) NULL, 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)