CREATE TABLE people
(
    "Customer ID"   TEXT,
    "Customer Name" TEXT,
    Segment         TEXT,
    Country         TEXT,
    City            TEXT,
    State           TEXT,
    "Postal Code"   INTEGER,
    Region          TEXT,
    primary key ("Customer ID", Region)
);
people
CREATE TABLE product
(
    "Product ID"   TEXT,
    "Product Name" TEXT,
    Category       TEXT,
    "Sub-Category" TEXT,
    Region         TEXT,
    primary key ("Product ID", Region)
);
product
CREATE TABLE central_superstore
(
    "Row ID"      INTEGER
            primary key,
    "Order ID"    TEXT,
    "Order Date"  DATE,
    "Ship Date"   DATE,
    "Ship Mode"   TEXT,
    "Customer ID" TEXT,
    Region        TEXT,
    "Product ID"  TEXT,
    Sales         REAL,
    Quantity      INTEGER,
    Discount      REAL,
    Profit        REAL,
    foreign key ("Customer ID", Region) references people("Customer ID",Region),
    foreign key ("Product ID", Region) references product("Product ID",Region)
);
central_superstore
CREATE TABLE east_superstore
(
    "Row ID"      INTEGER
            primary key,
    "Order ID"    TEXT,
    "Order Date"  DATE,
    "Ship Date"   DATE,
    "Ship Mode"   TEXT,
    "Customer ID" TEXT,
    Region        TEXT,
    "Product ID"  TEXT,
    Sales         REAL,
    Quantity      INTEGER,
    Discount      REAL,
    Profit        REAL,
    foreign key ("Customer ID", Region) references people("Customer ID",Region),
    foreign key ("Product ID", Region) references product("Product ID",Region)
);
east_superstore
CREATE TABLE south_superstore
(
    "Row ID"      INTEGER
            primary key,
    "Order ID"    TEXT,
    "Order Date"  DATE,
    "Ship Date"   DATE,
    "Ship Mode"   TEXT,
    "Customer ID" TEXT,
    Region        TEXT,
    "Product ID"  TEXT,
    Sales         REAL,
    Quantity      INTEGER,
    Discount      REAL,
    Profit        REAL,
    foreign key ("Customer ID", Region) references people("Customer ID",Region),
    foreign key ("Product ID", Region) references product("Product ID",Region)
);
south_superstore
CREATE TABLE west_superstore
(
    "Row ID"      INTEGER
            primary key,
    "Order ID"    TEXT,
    "Order Date"  DATE,
    "Ship Date"   DATE,
    "Ship Mode"   TEXT,
    "Customer ID" TEXT,
    Region        TEXT,
    "Product ID"  TEXT,
    Sales         REAL,
    Quantity      INTEGER,
    Discount      REAL,
    Profit        REAL,
    foreign key ("Customer ID", Region) references people("Customer ID",Region),
    foreign key ("Product ID", Region) references product("Product ID",Region)
);
west_superstore
original_column_name,column_name,column_description,data_format,value_description
Product ID,,the id of products,text,
Product Name,,the name of products,text,
Category,,the categories of products,text," Furniture 
 Office Supplies 
 Technology"
Sub-Category,,the sub-categories of products,text," Bookcases 
 Chairs 
 Furnishings 
 Tables 
 Appliances 
 Art 
 Binders 
 Envelopes 
 Fasteners 
 Labels 
 Paper 
 Storage 
 Supplies 
 Accessories 
 Copiers 
 Machines 
 Phones "
Region,,the region of products,text," Central: 
 East: 
 West: 
 South:"
product
original_column_name,column_name,column_description,data_format,value_description
Row ID,row id,the unique id for rows,integer,
Order ID,order id,the unique identifier for the order,text,
Order Date,order date,the date of the order,date,yyyy-mm-dd
Ship Date,ship date,the date of the shipment,date,"yyyy-mm-dd
commonsense evidence: 
'shipment time' refers to the time interval between order_date and ship_date."
Ship Mode,ship mode,the ship mode of the order,text,"First Class / Second Class / Standard Class
commonsense evidence: Among three ship modes, First Class has the fastest delivery speed, followed by Second Class and the speed of the Standard Class is the slowest."
Customer ID,customer id,the id of the customer,text,
Region,,region of the customer's address,text,
Product ID,product id,the id of the product,text,
Sales,,the sales of the product,real,
Quantity,,the quantity of the product,integer,
Discount,,the discount of the product,real,commonsense evidence: original price = sales / (1- discount)
Profit,,the profit that the company got by selling the product,real,"commonsense evidence:
total cost of products =  sales / (1- discount) * quantity - profit
deficiency: if the value is negative"
central_superstore
original_column_name,column_name,column_description,data_format,value_description
Row ID,row id,the unique id for rows,integer,
Order ID,order id,the unique identifier for the order,text,
Order Date,order date,the date of the order,date,yyyy-mm-dd
Ship Date,ship date,the date of the shipment,date,"yyyy-mm-dd 
commonsense evidence: 'shipment time' refers to the time interval between order_date and ship_date. "
Ship Mode,ship mode,the ship mode of the order,text,"First Class / Second Class / Standard Class
commonsense evidence: Among three ship modes, First Class has the fastest delivery speed, followed by Second Class and the speed of the Standard Class is the slowest. "
Customer ID,customer id,the id of the customer,text,
Region,,region of the customer's address,text,
Product ID,product id,the id of the product,text,
Sales,,the sales of the product,real,
Quantity,,the quantity of the product,integer,
Discount,,the discount of the product,real,"commonsense evidence: original price = sales / (1- discount)
"
Profit,,the profit that the company got by selling the product,real,"commonsense evidence: total cost of products =  sales / (1- discount) * quantity - profit
deficiency: if the value is negative
"
south_superstore
original_column_name,column_name,column_description,data_format,value_description
Row ID,row id,the unique id for rows,integer,
Order ID,order id,the unique identifier for the order,text,
Order Date,order date,the date of the order,date,yyyy-mm-dd
Ship Date,ship date,the date of the shipment,date,"yyyy-mm-dd
commonsense evidence: 'shipment time' refers to the time interval between order_date and ship_date. "
Ship Mode,ship mode,the ship mode of the order,text,"First Class / Second Class / Standard Class
commonsense evidence: Among three ship modes, First Class has the fastest delivery speed, followed by Second Class and the speed of the Standard Class is the slowest. "
Customer ID,customer id,the id of the customer,text,
Region,,region of the customer's address,text,
Product ID,product id,the id of the product,text,
Sales,,the sales of the product,real,
Quantity,,the quantity of the product,integer,
Discount,,the discount of the product,real,commonsense evidence: original price = sales / (1- discount)
Profit,,the profit that the company got by selling the product,real,"commonsense evidence: total cost of products =  sales / (1- discount) * quantity - profit
deficiency: if the value is negative"
west_superstore
original_column_name,column_name,column_description,data_format,value_description
Row ID,row id,the unique id for rows,integer,
Order ID,order id,the unique identifier for the order,text,
Order Date,order date,the date of the order,date,yyyy-mm-dd
Ship Date,ship date,the date of the shipment,date,"yyyy-mm-dd
commonsense evidence: 'shipment time' refers to the time interval between order_date and ship_date. "
Ship Mode,ship mode,the ship mode of the order,text,"First Class / Second Class / Standard Class
commonsense evidence: Among three ship modes, First Class has the fastest delivery speed, followed by Second Class and the speed of the Standard Class is the slowest.
"
Customer ID,customer id,the id of the customer,text,
Region,,region of the customer's address,text,
Product ID,product id,the id of the product,text,
Sales,,the sales of the product,real,
Quantity,,the quantity of the product,integer,
Discount,,the discount of the product,real,commonsense evidence: original price = sales / (1- discount)
Profit,,the profit that the company got by selling the product,real,"commonsense evidence: total cost of products =  sales / (1- discount) * quantity - profit
deficiency: if the value is negative
"
east_superstore
original_column_name,column_name,column_description,data_format,value_description
Customer ID,,the id of the customers,text,
Customer Name,,the name of the customers,text,
Segment,,the segment that the customers belong to,text,"commonsense evidence: 
 consumer 
 home office: synonym: headquarter. 
 corporate"
Country,,the country of people,text,
City,,the city of people,text,
State,,the state of people,text,"commonsense evidence: please mention its full name in the question, by referring to 
https://www23.statcan.gc.ca/imdb/p3VD.pl?Function=getVD&TVD=53971
e.g., New York --> NY"
Postal Code,,the postal code,integer,
Region,,the region of people,text," Central: 
 East: 
 West: 
 South: "
people