github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/testutils/opttester/testfixtures/tpcc_schema (about) 1 exec-ddl 2 CREATE TABLE warehouse 3 ( 4 w_id integer not null primary key, 5 w_name varchar(10), 6 w_street_1 varchar(20), 7 w_street_2 varchar(20), 8 w_city varchar(20), 9 w_state char(2), 10 w_zip char(9), 11 w_tax decimal(4,4), 12 w_ytd decimal(12,2) 13 ) 14 ---- 15 16 exec-ddl 17 CREATE TABLE district 18 ( 19 d_id integer not null, 20 d_w_id integer not null, 21 d_name varchar(10), 22 d_street_1 varchar(20), 23 d_street_2 varchar(20), 24 d_city varchar(20), 25 d_state char(2), 26 d_zip char(9), 27 d_tax decimal(4,4), 28 d_ytd decimal(12,2), 29 d_next_o_id integer, 30 primary key (d_w_id, d_id), 31 foreign key (d_w_id) references warehouse (w_id) 32 ) interleave in parent warehouse (d_w_id) 33 ---- 34 35 exec-ddl 36 CREATE TABLE customer 37 ( 38 c_id integer not null, 39 c_d_id integer not null, 40 c_w_id integer not null, 41 c_first varchar(16), 42 c_middle char(2), 43 c_last varchar(16), 44 c_street_1 varchar(20), 45 c_street_2 varchar(20), 46 c_city varchar(20), 47 c_state char(2), 48 c_zip char(9), 49 c_phone char(16), 50 c_since timestamp, 51 c_credit char(2), 52 c_credit_lim decimal(12,2), 53 c_discount decimal(4,4), 54 c_balance decimal(12,2), 55 c_ytd_payment decimal(12,2), 56 c_payment_cnt integer, 57 c_delivery_cnt integer, 58 c_data varchar(500), 59 primary key (c_w_id, c_d_id, c_id), 60 index customer_idx (c_w_id, c_d_id, c_last, c_first), 61 foreign key (c_w_id, c_d_id) references district (d_w_id, d_id) 62 ) interleave in parent district (c_w_id, c_d_id) 63 ---- 64 65 exec-ddl 66 CREATE TABLE history 67 ( 68 rowid uuid not null default gen_random_uuid(), 69 h_c_id integer not null, 70 h_c_d_id integer not null, 71 h_c_w_id integer not null, 72 h_d_id integer not null, 73 h_w_id integer not null, 74 h_date timestamp, 75 h_amount decimal(6,2), 76 h_data varchar(24), 77 primary key (h_w_id, rowid), 78 index history_customer_fk_idx (h_c_w_id, h_c_d_id, h_c_id), 79 index history_district_fk_idx (h_w_id, h_d_id), 80 foreign key (h_c_w_id, h_c_d_id, h_c_id) references customer (c_w_id, c_d_id, c_id), 81 foreign key (h_w_id, h_d_id) references district (d_w_id, d_id) 82 ) 83 ---- 84 85 exec-ddl 86 CREATE TABLE "order" 87 ( 88 o_id integer not null, 89 o_d_id integer not null, 90 o_w_id integer not null, 91 o_c_id integer, 92 o_entry_d timestamp, 93 o_carrier_id integer, 94 o_ol_cnt integer, 95 o_all_local integer, 96 primary key (o_w_id, o_d_id, o_id DESC), 97 unique index order_idx (o_w_id, o_d_id, o_c_id, o_id DESC) storing (o_entry_d, o_carrier_id), 98 foreign key (o_w_id, o_d_id, o_c_id) references customer (c_w_id, c_d_id, c_id) 99 ) interleave in parent district (o_w_id, o_d_id) 100 ---- 101 102 exec-ddl 103 CREATE TABLE new_order 104 ( 105 no_o_id integer not null, 106 no_d_id integer not null, 107 no_w_id integer not null, 108 primary key (no_w_id, no_d_id, no_o_id), 109 foreign key (no_w_id, no_d_id, no_o_id) references "order" (o_w_id, o_d_id, o_id) 110 ) interleave in parent "order" (no_w_id, no_d_id, no_o_id) 111 ---- 112 113 exec-ddl 114 CREATE TABLE item 115 ( 116 i_id integer not null, 117 i_im_id integer, 118 i_name varchar(24), 119 i_price decimal(5,2), 120 i_data varchar(50), 121 primary key (i_id) 122 ) 123 ---- 124 125 exec-ddl 126 CREATE TABLE stock 127 ( 128 s_i_id integer not null, 129 s_w_id integer not null, 130 s_quantity integer, 131 s_dist_01 char(24), 132 s_dist_02 char(24), 133 s_dist_03 char(24), 134 s_dist_04 char(24), 135 s_dist_05 char(24), 136 s_dist_06 char(24), 137 s_dist_07 char(24), 138 s_dist_08 char(24), 139 s_dist_09 char(24), 140 s_dist_10 char(24), 141 s_ytd integer, 142 s_order_cnt integer, 143 s_remote_cnt integer, 144 s_data varchar(50), 145 primary key (s_w_id, s_i_id), 146 index stock_item_fk_idx (s_i_id), 147 foreign key (s_w_id) references warehouse (w_id), 148 foreign key (s_i_id) references item (i_id) 149 ) interleave in parent warehouse (s_w_id) 150 ---- 151 152 exec-ddl 153 CREATE TABLE order_line 154 ( 155 ol_o_id integer not null, 156 ol_d_id integer not null, 157 ol_w_id integer not null, 158 ol_number integer not null, 159 ol_i_id integer not null, 160 ol_supply_w_id integer, 161 ol_delivery_d timestamp, 162 ol_quantity integer, 163 ol_amount decimal(6,2), 164 ol_dist_info char(24), 165 primary key (ol_w_id, ol_d_id, ol_o_id DESC, ol_number), 166 index order_line_stock_fk_idx (ol_supply_w_id, ol_i_id), 167 foreign key (ol_w_id, ol_d_id, ol_o_id) references "order" (o_w_id, o_d_id, o_id), 168 foreign key (ol_supply_w_id, ol_i_id) references stock (s_w_id, s_i_id) 169 ) interleave in parent "order" (ol_w_id, ol_d_id, ol_o_id) 170 ----