You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
nsc_ba_public/tpch/03_ddl/exasol/10.exasol.lineitem.sql

20 lines
431 B

CREATE TABLE tpch.lineitem
(L_ORDERKEY DECIMAL(36,0),
L_PARTKEY DECIMAL(18,0),
L_SUPPKEY DECIMAL(18,0),
L_LINENUMBER DECIMAL(18,0),
L_QUANTITY DECIMAL(15,2),
L_EXTENDEDPRICE DECIMAL(15,2),
L_DISCOUNT DECIMAL(15,2),
L_TAX DECIMAL(15,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),
dummy VARCHAR(2000000));