CREATE TABLE NATION (N_NATIONKEY INTEGER NOT NULL , N_NAME CHAR(25) ,N_REGIONKEY INTEGER , N_COMMENT VARCHAR(152) ) CREATE TABLE REGION (R_REGIONKEY INTEGER NOT NULL , R_NAME CHAR(25) , R_COMMENT VARCHAR(152) ) CREATE TABLE PARTSUPP (PS_PARTKEY INTEGER NOT NULL , PS_SUPPKEY INTEGER NOT NULL , PS_AVAILQTY INTEGER , PS_SUPPLYCOST DECIMAL(10,2) , PS_COMMENT VARCHAR(199) ) CREATE TABLE PART (P_PARTKEY INTEGER NOT NULL , P_NAME VARCHAR(55) , P_MFGR CHAR(25) , P_BRAND CHAR(10) , P_TYPE VARCHAR(25) , P_SIZE INTEGER , P_CONTAINER CHAR(10) , P_RETAILPRICE DECIMAL(10,2) , P_COMMENT VARCHAR(23) ) CREATE TABLE ORDERS (O_ORDERKEY INTEGER NOT NULL , O_CUSTKEY INTEGER , O_ORDERSTATUS CHAR(1) , O_TOTALPRICE DECIMAL(10,2) , O_ORDERDATE DATE , O_ORDERPRIORITY CHAR(15) , O_CLERK CHAR(15) , O_SHIPPRIORITY INTEGER , O_COMMENT VARCHAR(79) ) CREATE TABLE LINEITEM (L_ORDERKEY INTEGER NOT NULL , L_PARTKEY INTEGER , L_SUPPKEY INTEGER , L_LINENUMBER INTEGER NOT NULL , L_QUANTITY DECIMAL(10,2) , L_EXTENDEDPRICE DECIMAL(10,2) , L_DISCOUNT DECIMAL(10,2) , L_TAX DECIMAL(10,2) , L_RETURNFLAG CHAR(1) , L_LINESTATUS CHAR(1) , L_SHIPDATE DATE , L_COMMITDATE DATE , L_RECEIPTDATE DATE , L_SHIPINSTRUCT CHAR(25) , L_SHIPMODE CHAR(10) , L_COMMENT VARCHAR(44) ) CREATE TABLE CUSTOMER (C_CUSTKEY INTEGER NOT NULL , C_NAME VARCHAR(25) , C_ADDRESS VARCHAR(40) , C_NATIONKEY INTEGER , C_PHONE CHAR(15) , C_ACCTBAL DECIMAL(10,2) , C_MKTSEGMENT CHAR(10) , C_COMMENT VARCHAR(117) ) CREATE TABLE SUPPLIER (S_SUPPKEY INTEGER NOT NULL , S_NAME CHAR(25) , S_ADDRESS VARCHAR(40) , S_NATIONKEY INTEGER , S_PHONE CHAR(15) , S_ACCTBAL DECIMAL(10,2) , S_COMMENT VARCHAR(101) ) ALTER TABLE NATION ADD PRIMARY KEY (N_NATIONKEY); ALTER TABLE REGION ADD PRIMARY KEY (R_REGIONKEY); ALTER TABLE PARTSUPP ADD PRIMARY KEY(PS_PARTKEY,PS_SUPPKEY); ALTER TABLE PART ADD PRIMARY KEY (P_PARTKEY); ALTER TABLE ORDERS ADD PRIMARY KEY(O_ORDERKEY); ALTER TABLE LINEITEM ADD PRIMARY KEY(L_ORDERKEY,L_LINENUMBER); ALTER TABLE CUSTOMER ADD PRIMARY KEY(C_CUSTKEY); ALTER TABLE SUPPLIER ADD PRIMARY KEY(S_SUPPKEY);