CREATE TABLE PART( 
  P_PARTKEY INT,
  P_NAME TEXT,
  P_MFGR TEXT,
  P_BRAND TEXT,
  P_TYPE TEXT,
  P_SIZE INT,
  P_CONTAINER TEXT,
  P_RETAILPRICE FLOAT,
  P_COMMENT TEXT,
  P_EXTRA TEXT
);

CREATE TABLE SUPPLIER(
   S_SUPPKEY INT,
   S_NAME TEXT,
   S_ADDRESS TEXT, 
   S_NATIONKEY INT, 
   S_PHONE TEXT,
   S_ACCTBAL FLOAT, 
   S_COMMENT TEXT,
   S_EXTRA TEXT
);

CREATE TABLE PARTSUPP(
   PS_PARTKEY INT,
   PS_SUPPKEY INT,
   PS_AVAILQTY INT,
   PS_SUPPLYCOST FLOAT,
   PS_COMMENT TEXT,
   PS_EXTRA TEXT
);

CREATE TABLE CUSTOMER(
   C_CUSTKEY INT,
   C_NAME TEXT,
   C_ADDRESS TEXT,
   C_NATIONKEY INT,
   C_PHONE TEXT,
   C_ACCTBAL FLOAT,
   C_MKTSEGMENT TEXT,
   C_COMMENT TEXT,
   C_EXTRA TEXT
);

CREATE TABLE ORDERS(
   O_ORDERKEY INT,
   O_CUSTKEY INT,
   O_ORDERSTATUS TEXT,
   O_TOTALPRICE FLOAT,
   O_ORDERDATE DATE,
   O_ORDERPRIORITY TEXT,
   O_CLERK TEXT,
   O_SHIPPRIORITY INT,
   O_COMMENT TEXT,
   O_EXTRA
);

CREATE TABLE LINEITEM(
   L_ORDERKEY INT,
   L_PARTKEY INT,
   L_SUPPKEY INT,
   L_LINENUMBER INT,
   L_QUANTITY FLOAT,
   L_EXTENDEDPRICE FLOAT,
   L_DISCOUNT FLOAT,
   L_TAX FLOAT,
   L_RETURNFLAG TEXT,
   L_LINESTATUS TEXT,
   L_SHIPDATE DATE,
   L_COMMITDATE DATE,
   L_RECEIPTDATE DATE,
   L_SHIPINSTRUCT TEXT,
   L_SHIPMODE TEXT,
   L_COMMENT TEXT,
   L_EXTRA TEXT
);

CREATE TABLE NATION(
   N_NATIONKEY INT,
   N_NAME TEXT,
   N_REGIONKEY INT,
   N_COMMENT TEXT,
   N_EXTRA TEXT
);

CREATE TABLE REGION(
   R_REGIONKEY INT,
   R_NAME TEXT,
   R_COMMENT TEXT,
   R_EXTRA TEXT
);
