-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathcatalog
102 lines (93 loc) · 1.24 KB
/
catalog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
BEGIN
region
region.tbl
r_regionkey Int
r_name String
r_comment String
END
BEGIN
nation
nation.tbl
n_nationkey Int
n_name String
n_regionkey Int
n_comment String
END
BEGIN
part
part.tbl
p_partkey Int
p_name String
p_mfgr String
p_brand String
p_type String
p_size Int
p_container String
p_retailprice Double
p_comment String
END
BEGIN
supplier
supplier.tbl
s_suppkey Int
s_name String
s_address String
s_nationkey Int
s_phone String
s_acctbal Double
s_comment String
END
BEGIN
partsupp
partsupp.tbl
ps_partkey Int
ps_suppkey Int
ps_availqty Int
ps_supplycost Double
ps_comment String
END
BEGIN
customer
customer.tbl
c_custkey Int
c_name String
c_address String
c_nationkey Int
c_phone String
c_acctbal Double
c_mktsegment String
c_comment String
END
BEGIN
orders
orders.tbl
o_orderkey Int
o_custkey Int
o_orderstatus String
o_totalprice Double
o_orderdate String
o_orderpriority String
o_clerk String
o_shippriority Int
o_comment String
END
BEGIN
lineitem
lineitem.tbl
l_orderkey Int
l_partkey Int
l_suppkey Int
l_linenumber Int
l_quantity Double
l_extendedprice Double
l_discount Double
l_tax Double
l_returnflag String
l_linestatus String
l_shipdate String
l_commitdate String
l_receiptdate String
l_shipinstruct String
l_shipmode String
l_comment String
END