github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/benchmark/tpch/01_DDL/01_create_table.result (about)

     1  drop database if exists TPCH;
     2  create database if not exists TPCH;
     3  use TPCH;
     4  CREATE TABLE NATION(
     5  N_NATIONKEY  INTEGER NOT NULL,
     6  N_NAME       CHAR(25) NOT NULL,
     7  N_REGIONKEY  INTEGER NOT NULL,
     8  N_COMMENT    VARCHAR(152),
     9  PRIMARY KEY (N_NATIONKEY)
    10  );
    11  
    12  CREATE TABLE REGION(
    13  R_REGIONKEY  INTEGER NOT NULL,
    14  R_NAME       CHAR(25) NOT NULL,
    15  R_COMMENT    VARCHAR(152),
    16  PRIMARY KEY (R_REGIONKEY)
    17  );
    18  
    19  CREATE TABLE PART(
    20  P_PARTKEY     INTEGER NOT NULL,
    21  P_NAME        VARCHAR(55) NOT NULL,
    22  P_MFGR        CHAR(25) NOT NULL,
    23  P_BRAND       CHAR(10) NOT NULL,
    24  P_TYPE        VARCHAR(25) NOT NULL,
    25  P_SIZE        INTEGER NOT NULL,
    26  P_CONTAINER   CHAR(10) NOT NULL,
    27  P_RETAILPRICE DECIMAL(15,2) NOT NULL,
    28  P_COMMENT     VARCHAR(23) NOT NULL,
    29  PRIMARY KEY (P_PARTKEY)
    30  );
    31  
    32  CREATE TABLE SUPPLIER(
    33  S_SUPPKEY     INTEGER NOT NULL,
    34  S_NAME        CHAR(25) NOT NULL,
    35  S_ADDRESS     VARCHAR(40) NOT NULL,
    36  S_NATIONKEY   INTEGER NOT NULL,
    37  S_PHONE       CHAR(15) NOT NULL,
    38  S_ACCTBAL     DECIMAL(15,2) NOT NULL,
    39  S_COMMENT     VARCHAR(101) NOT NULL,
    40  PRIMARY KEY (S_SUPPKEY)
    41  );
    42  
    43  CREATE TABLE PARTSUPP(
    44  PS_PARTKEY     INTEGER NOT NULL,
    45  PS_SUPPKEY     INTEGER NOT NULL,
    46  PS_AVAILQTY    INTEGER NOT NULL,
    47  PS_SUPPLYCOST  DECIMAL(15,2)  NOT NULL,
    48  PS_COMMENT     VARCHAR(199) NOT NULL,
    49  PRIMARY KEY (PS_SUPPLYCOST)
    50  );
    51  
    52  CREATE TABLE CUSTOMER(
    53  C_CUSTKEY     INTEGER NOT NULL,
    54  C_NAME        VARCHAR(25) NOT NULL,
    55  C_ADDRESS     VARCHAR(40) NOT NULL,
    56  C_NATIONKEY   INTEGER NOT NULL,
    57  C_PHONE       CHAR(15) NOT NULL,
    58  C_ACCTBAL     DECIMAL(15,2)   NOT NULL,
    59  C_MKTSEGMENT  CHAR(10) NOT NULL,
    60  C_COMMENT     VARCHAR(117) NOT NULL,
    61  PRIMARY KEY (C_CUSTKEY)
    62  );
    63  
    64  CREATE TABLE ORDERS(
    65  O_ORDERKEY       BIGINT NOT NULL,
    66  O_CUSTKEY        INTEGER NOT NULL,
    67  O_ORDERSTATUS    CHAR(1) NOT NULL,
    68  O_TOTALPRICE     DECIMAL(15,2) NOT NULL,
    69  O_ORDERDATE      DATE NOT NULL,
    70  O_ORDERPRIORITY  CHAR(15) NOT NULL,
    71  O_CLERK          CHAR(15) NOT NULL,
    72  O_SHIPPRIORITY   INTEGER NOT NULL,
    73  O_COMMENT        VARCHAR(79) NOT NULL,
    74  PRIMARY KEY (O_ORDERKEY)
    75  );
    76  
    77  CREATE TABLE LINEITEM(
    78  L_LINEITEM_ID BIGINT NOT NULL,
    79  L_ORDERKEY    BIGINT NOT NULL,
    80  L_PARTKEY     INTEGER NOT NULL,
    81  L_SUPPKEY     INTEGER NOT NULL,
    82  L_LINENUMBER  INTEGER NOT NULL,
    83  L_QUANTITY    DECIMAL(15,2) NOT NULL,
    84  L_EXTENDEDPRICE  DECIMAL(15,2) NOT NULL,
    85  L_DISCOUNT    DECIMAL(15,2) NOT NULL,
    86  L_TAX         DECIMAL(15,2) NOT NULL,
    87  L_RETURNFLAG  VARCHAR(1) NOT NULL,
    88  L_LINESTATUS  VARCHAR(1) NOT NULL,
    89  L_SHIPDATE    DATE NOT NULL,
    90  L_COMMITDATE  DATE NOT NULL,
    91  L_RECEIPTDATE DATE NOT NULL,
    92  L_SHIPINSTRUCT CHAR(25) NOT NULL,
    93  L_SHIPMODE     CHAR(10) NOT NULL,
    94  L_COMMENT      VARCHAR(44) NOT NULL,
    95  PRIMARY KEY (L_LINEITEM_ID)
    96  );