106 lines
2.8 KiB
Plaintext
106 lines
2.8 KiB
Plaintext
CREATE TRIO TABLE PARTSUPP (
|
|
PARTKEY int,
|
|
SUPPKEY int,
|
|
AVAILQTY int,
|
|
SUPPLYCOST float,
|
|
COMMENT varchar(79),
|
|
uncertain(partkey, suppkey, availqty, supplycost)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE LINEITEM (
|
|
ORDERKEY int,
|
|
PARTKEY int,
|
|
SUPPKEY int,
|
|
LINENUMBER int,
|
|
QUANTITY float,
|
|
EXTENDEDPRICE float,
|
|
DISCOUNT float,
|
|
TAX float,
|
|
RETURNFLAG varchar(1),
|
|
LINESTATUS varchar(1),
|
|
SHIPDATE varchar(10),
|
|
COMMITDATE varchar(10),
|
|
RECEIPTDATE varchar(10),
|
|
SHIPINSTRUCT varchar(25),
|
|
SHIPMODE varchar(10),
|
|
COMMENT varchar(44),
|
|
uncertain(ORDERKEY,PARTKEY,SUPPKEY,LINENUMBER,QUANTITY,EXTENDEDPRICE,DISCOUNT,TAX,RETURNFLAG,LINESTATUS,SHIPDATE,COMMITDATE,RECEIPTDATE,SHIPINSTRUCT,SHIPMODE,COMMENT)
|
|
) with confidences;
|
|
|
|
CREATE TRIO TABLE ORDERS (
|
|
ORDERKEY int,
|
|
CUSTKEY int,
|
|
ORDERSTATUS varchar(1),
|
|
TOTALPRICE float,
|
|
ORDERDATE varchar(10),
|
|
ORDERPRIORITY varchar(15),
|
|
CLERK varchar(15),
|
|
SHIPPRIORITY int,
|
|
COMMENT varchar(79),
|
|
uncertain(ORDERKEY,CUSTKEY,ORDERSTATUS,TOTALPRICE,ORDERDATE,ORDERPRIORITY,CLERK,SHIPPRIORITY,COMMENT))
|
|
with confidences;
|
|
|
|
CREATE TRIO TABLE PART (
|
|
PARTKEY int,
|
|
NAME varchar(48),
|
|
MFGR varchar(32),
|
|
BRAND varchar(32),
|
|
TYPE varchar(32),
|
|
SIZE int,
|
|
CONTAINER varchar(32),
|
|
RETAILPRICE float,
|
|
COMMENT varchar(79),
|
|
uncertain(PARTKEY,NAME,MFGR,BRAND,TYPE,SIZE,CONTAINER,RETAILPRICE,COMMENT))
|
|
with confidences;
|
|
|
|
CREATE TRIO TABLE SUPPLIER (
|
|
SUPPKEY int,
|
|
NAME varchar(48),
|
|
ADDRESS varchar(32),
|
|
NATIONKEY int,
|
|
PHONE varchar(32),
|
|
ACCTBAL float,
|
|
COMMENT varchar(79),
|
|
uncertain(SUPPKEY,NAME,ADDRESS,NATIONKEY,PHONE,ACCTBAL,COMMENT))
|
|
with confidences;
|
|
|
|
CREATE TRIO TABLE CUSTOMER (
|
|
CUSTKEY int,
|
|
NAME varchar(48),
|
|
ADDRESS varchar(32),
|
|
NATIONKEY int,
|
|
PHONE varchar(32),
|
|
ACCTBAL float,
|
|
MKTSEGMENT varchar(32),
|
|
COMMENT varchar(79),
|
|
uncertain(CUSTKEY,NAME,ADDRESS,NATIONKEY,PHONE,ACCTBAL,MKTSEGMENT,COMMENT))
|
|
with confidences;
|
|
|
|
CREATE TRIO TABLE NATION (
|
|
NATIONKEY int,
|
|
NAME varchar(48),
|
|
REGIONKEY int,
|
|
COMMENT varchar(79),
|
|
uncertain(NATIONKEY,NAME,REGIONKEY,COMMENT))
|
|
with confidences;
|
|
|
|
CREATE TRIO TABLE REGION (
|
|
REGIONKEY int,
|
|
NAME varchar(48),
|
|
COMMENT varchar(79))
|
|
with confidences;
|
|
|
|
create index lineitem_orderkey_idx on lineitem(orderkey);
|
|
create index lineitem_partkey_idx on lineitem(partkey);
|
|
create index lineitem_suppkey_idx on lineitem(suppkey);
|
|
create index orders_orderkey_idx on orders(orderkey);
|
|
create index orders_custkey_idx on orders(custkey);
|
|
create index partsupp_partkey_idx on partsupp(partkey);
|
|
create index partsupp_suppkey_idx on partsupp(suppkey);
|
|
create index part_partkey_idx on part(partkey);
|
|
create index supplier_suppkey_idx on supplier(suppkey);
|
|
create index customer_custkey_idx on customer(custkey);
|
|
create index nation_nationkey_idx on nation(nationkey);
|
|
create index region_regionkey_idx on region(regionkey);
|
|
|