4 lines
1.1 KiB
Plaintext
4 lines
1.1 KiB
Plaintext
CREATE TABLE CUSTOMER(C_CUSTKEY BIGINT NOT NULL, C_NAME VARCHAR(25) NOT NULL, C_ADDRESS VARCHAR(40) NOT NULL, C_NATIONKEY BIGINT NOT NULL, C_PHONE CHAR(15) NOT NULL, C_ACCTBAL DOUBLE NOT NULL, C_MKTSEGMENT CHAR(10) NOT NULL, C_COMMENT VARCHAR(117) NOT NULL, PRIMARY KEY(C_CUSTKEY))
|
|
CREATE TABLE ORDERS(O_ORDERKEY BIGINT NOT NULL, O_CUSTKEY BIGINT NOT NULL, O_ORDERSTATUS CHAR(1) NOT NULL, O_TOTALPRICE DOUBLE NOT NULL, O_ORDERDATE DATE NOT NULL, O_ORDERPRIORITY CHAR(15) NOT NULL, O_CLERK CHAR(15) NOT NULL, O_SHIPPRIORITY BIGINT NOT NULL, O_COMMENT VARCHAR(79) NOT NULL, PRIMARY KEY(O_ORDERKEY))
|
|
CREATE TABLE LINEITEM(L_ORDERKEY BIGINT NOT NULL, L_LINENUMBER BIGINT NOT NULL, L_PARTKEY BIGINT NOT NULL, L_SUPPKEY BIGINT NOT NULL, L_QUANTITY DOUBLE NOT NULL, L_EXTENDEDPRICE DOUBLE NOT NULL, L_DISCOUNT DOUBLE NOT NULL, L_TAX DOUBLE NOT NULL, L_RETURNFLAG CHAR(1) NOT NULL, L_LINESTATUS CHAR(1) NOT NULL, L_SHIPDATE DATE NOT NULL, L_COMMITDATE DATE NOT NULL, L_RECEIPTDATE DATE NOT NULL, L_SHIPINSTRUCT CHAR(25) NOT NULL, L_SHIPMODE CHAR(10) NOT NULL, L_COMMENT VARCHAR(44) NOT NULL, PRIMARY KEY(L_ORDERKEY,L_LINENUMBER))
|