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 );