CREATE TABLE Bar_Code (ID number(10) GENERATED AS IDENTITY, Item_ID number(10) NOT NULL, Bar_Code blob NOT NULL UNIQUE, Is_Active varchar2(1) NOT NULL, Description varchar2(255), PRIMARY KEY (ID))

CREATE TABLE City (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL, Region_ID number(10) NOT NULL, Time_Zone_ID number(10) NOT NULL, Zip_Code number(30), PRIMARY KEY (ID), CONSTRAINT UK_City UNIQUE (Name, Region_ID))

CREATE TABLE Country (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, PRIMARY KEY (ID))

CREATE TABLE Currency (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Short_Name varchar2(15) NOT NULL UNIQUE, Symbol varchar2(5) NOT NULL UNIQUE, Description varchar2(255), PRIMARY KEY (ID))

CREATE TABLE Customer (ID number(10) GENERATED AS IDENTITY, City_ID number(10) NOT NULL, Code varchar2(25) NOT NULL, Phone varchar2(50) NOT NULL UNIQUE, First_Name varchar2(50) NOT NULL, Last_Name varchar2(50) NOT NULL, Is_Company varchar2(1) NOT NULL, Company_Name varchar2(255), Tax_Number varchar2(50), Is_Tax_Exempted varchar2(1) NOT NULL, Billing_Address varchar2(255) NOT NULL, Postal_Code varchar2(50), Is_Registered_Online varchar2(1) NOT NULL, Email varchar2(50) UNIQUE, Username varchar2(50) UNIQUE, Password raw(255), Credit number(14, 2), Created_Emp_Login_ID number(10), Created_At_Store_ID number(10), Created_Time timestamp(0) NOT NULL, Last_Login_Time timestamp(0), Is_Active varchar2(1) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

CREATE TABLE Delivery_Type (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Description varchar2(255), Is_Active varchar2(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Discount (ID number(10) GENERATED AS IDENTITY, Discount_Type_ID number(10) NOT NULL, Item_Category_ID number(10), Item_ID number(10), Description varchar2(255), Comments varchar2(1000), PRIMARY KEY (ID))

CREATE TABLE Discount_Type (ID number(10) GENERATED AS IDENTITY, Store_ID number(10) NOT NULL, Name varchar2(50) NOT NULL, Description varchar2(255), Is_Percentage varchar2(1) NOT NULL, Value number(15, 3) NOT NULL, Created_Time timestamp(0) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), Loyalty_Card_Type_ID number(10), Coupon_Code varchar2(50), Min_Order_Value number(15, 3) NOT NULL, Min_Item_Quantity number(10) NOT NULL, Apply_To_All varchar2(1) NOT NULL, Apply_To_Next varchar2(1) NOT NULL, Max_Discount_Value number(15, 3) NOT NULL, Is_Active varchar2(1) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

CREATE TABLE Employee_Login (ID number(10) GENERATED AS IDENTITY, Employee_ID number(10) NOT NULL, Employee_Role_ID number(10) NOT NULL, Login_Time timestamp(0) NOT NULL, Logout_Time timestamp(0), Device_IP varchar2(50) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

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

CREATE TABLE Item_Category (ID number(10) GENERATED AS IDENTITY, Parent_Category_ID number(10), Name varchar2(50) NOT NULL UNIQUE, Description varchar2(255), Is_Active varchar2(1) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

CREATE TABLE Language (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Short_Name varchar2(15) NOT NULL UNIQUE, Description varchar2(255), PRIMARY KEY (ID))

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

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

CREATE TABLE Order_Status (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Description varchar2(255), Is_Active varchar2(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Order_Status_History (ID number(10) GENERATED AS IDENTITY, Order_ID number(10) NOT NULL, Order_Status_ID number(10) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), PRIMARY KEY (ID))

CREATE TABLE Payment_Method (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Code varchar2(25) NOT NULL UNIQUE, Sequence_No number(3), Is_Active varchar2(1) NOT NULL, Is_Customer_Required varchar2(1) NOT NULL, Description varchar2(255), PRIMARY KEY (ID))

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

CREATE TABLE Price (ID number(10) GENERATED AS IDENTITY, Item_ID number(10) NOT NULL, Store_ID number(10) NOT NULL, Description varchar2(255), Current_Item_Cost number(15, 3) NOT NULL, Markup_percentage number(3) NOT NULL, Price_Before_Tax number(15, 3) NOT NULL, Tax_Value number(15, 3) NOT NULL, Price_After_Tax number(15, 3) NOT NULL, Sale_Price number(15, 3) NOT NULL, Price_Change_Allowed varchar2(1) NOT NULL, Created_Time timestamp(0) NOT NULL, Created_Emp_Login_ID number(10) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), Is_Active varchar2(1) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

CREATE TABLE Region (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL, Country_ID number(10) NOT NULL, PRIMARY KEY (ID), CONSTRAINT UK_Region UNIQUE (Name, Country_ID))

CREATE TABLE Sales_Channel (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Description varchar2(255), Is_Active varchar2(1) NOT NULL, PRIMARY KEY (ID))

CREATE TABLE Setting (ID number(10) GENERATED AS IDENTITY, Store_ID number(10) NOT NULL, Default_Payment_Method_ID number(10), Default_Tax_Type_ID number(10), Default_Quantity number(10), In_Stock_Check varchar2(1) NOT NULL, Negative_Stock_Allowed varchar2(1) NOT NULL, Price_Includes_Tax varchar2(1) NOT NULL, Negative_Price_Allowed varchar2(1) NOT NULL, Moving_Average_Price varchar2(1) NOT NULL, Discount_Before_Tax varchar2(1) NOT NULL, Default_Due_Days number(10), Decimal_Places number(2), Public_Reviews_Allowed varchar2(1) NOT NULL, Created_Time timestamp(0) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), Is_Active varchar2(1) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

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

CREATE TABLE Supplier (ID number(10) GENERATED AS IDENTITY, Store_ID number(10) NOT NULL, City_ID number(10) NOT NULL, Code varchar2(10) NOT NULL UNIQUE, Phone varchar2(50) NOT NULL, First_Name varchar2(50) NOT NULL, Last_Name varchar2(50) NOT NULL, Is_Company varchar2(1) NOT NULL, Company_Name varchar2(255), Tax_Number varchar2(50), Is_Tax_Exempted varchar2(1) NOT NULL, Billing_Address varchar2(255) NOT NULL, Postal_Code varchar2(50), Email varchar2(50) NOT NULL, Created_Emp_Login_ID number(10) NOT NULL, Created_Time timestamp(0) NOT NULL, Is_Active varchar2(1) NOT NULL, Comments varchar2(1000), PRIMARY KEY (ID))

CREATE TABLE Supplier_Item_Tax_Type (ID number(10) GENERATED AS IDENTITY, Item_ID number(10) NOT NULL, Supplier_Tax_Type_ID number(10) NOT NULL, Created_Time timestamp(0) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), Description varchar2(255), PRIMARY KEY (ID))

CREATE TABLE Supplier_Tax_Type (ID number(10) GENERATED AS IDENTITY, Supplier_ID number(10) NOT NULL, Name varchar2(50) NOT NULL, Code varchar2(25) NOT NULL, Description varchar2(255), Is_Percentage varchar2(1) NOT NULL, Value number(15, 3) NOT NULL, Created_Time timestamp(0) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), Is_Active varchar2(1) NOT NULL, Comments varchar2(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 number(10) GENERATED AS IDENTITY, Store_ID number(10) NOT NULL, Name varchar2(50) NOT NULL, Code varchar2(25) NOT NULL, Description varchar2(255), Is_Percentage varchar2(1) NOT NULL, Value number(15, 3) NOT NULL, Created_Time timestamp(0) NOT NULL, Start_Time timestamp(0) NOT NULL, End_Time timestamp(0), Is_Active varchar2(1) NOT NULL, Comments varchar2(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 number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Description varchar2(255), PRIMARY KEY (ID))

CREATE TABLE Unit_Of_Measure (ID number(10) GENERATED AS IDENTITY, Name varchar2(50) NOT NULL UNIQUE, Symbol varchar2(15) NOT NULL UNIQUE, Description varchar2(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)