Table Definitions - Teradata Database

Table Definitions

     CREATE TABLE customer (

       c_custkey    INTEGER NOT NULL,

       c_name       CHARACTER(26),

       c_address    VARCHAR(41),

       c_nationkey  INTEGER,

       c_phone      CHARACTER(16),

       c_acctbal    DECIMAL(13,2),

       c_mktsegment CHARACTER(21),

       c_comment    VARCHAR(127))

     UNIQUE PRIMARY INDEX(c_custkey);

     CREATE TABLE orders (

       o_orderkey      INTEGER NOT NULL,

       o_custkey       INTEGER,

       o_orderstatus   CHARACTER(1),

       o_totalprice    DECIMAL(13,2) NOT NULL,

       o_orderdate     DATE FORMAT 'yyyy-mm-dd' NOT NULL,

       o_orderpriority CHARACTER(21),

       o_clerk         CHARACTER(16),

       o_shippriority  INTEGER,

       o_commment      VARCHAR(79))

     UNIQUE PRIMARY INDEX (o_orderkey);

     CREATE TABLE lineitem (

       l_orderkey      INTEGER NOT NULL,

       l_partkey       INTEGER NOT NULL,

       l_suppkey       INTEGER,

       l_linenumber    INTEGER,

       l_quantity      INTEGER NOT NULL,

       l_extendedprice DECIMAL(13,2) NOT NULL,

       l_discount      DECIMAL(13,2),

       l_tax           DECIMAL(13,2),

       l_returnflag    CHARACTER(1),

       l_linestatus    CHARACTER(1),

       l_shipdate      DATE FORMAT 'yyyy-mm-dd',

       l_commitdate    DATE FORMAT 'yyyy-mm-dd',

       l_receiptdate   DATE FORMAT 'yyyy-mm-dd',

       l_shipinstruct  VARCHAR(25),

       l_shipmode      VARCHAR(10),

       l_comment       VARCHAR(44))

     PRIMARY INDEX (l_orderkey);