A postgreSQL Data ModeL related to customer's order :
CREATE TABLE customer ( c_since timestamp with time zone NOT NULL, c_id integer NOT NULL, c_w_id integer NOT NULL, c_d_id smallint NOT NULL, c_payment_cnt smallint NOT NULL, c_delivery_cnt smallint NOT NULL, c_first character varying(16) NOT NULL, c_middle character(2) NOT NULL, c_last character varying(16) NOT NULL, c_street_1 character varying(20) NOT NULL, c_street_2 character varying(20) NOT NULL, c_city character varying(20) NOT NULL, c_state character(2) NOT NULL, c_zip character(9) NOT NULL, c_phone character(16) NOT NULL, c_credit character(2) NOT NULL, c_credit_lim numeric(12,2) NOT NULL, c_discount numeric(4,4) NOT NULL, c_balance numeric(12,2) NOT NULL, c_ytd_payment numeric(12,2) NOT NULL, c_data character varying(500) NOT NULL, CONSTRAINT customer_i1 PRIMARY KEY (c_w_id, c_d_id, c_id) ); CREATE UNIQUE INDEX customer_i2 ON customer USING btree (c_w_id, c_d_id, c_last, c_first, c_id); CREATE TABLE district ( d_w_id integer NOT NULL, d_next_o_id integer NOT NULL, d_id smallint NOT NULL, d_ytd numeric(12,2) NOT NULL, d_tax numeric(4,4) NOT NULL, d_name character varying(10) NOT NULL, d_street_1 character varying(20) NOT NULL, d_street_2 character varying(20) NOT NULL, d_city character varying(20) NOT NULL, d_state character(2) NOT NULL, d_zip character(9) NOT NULL, CONSTRAINT district_i1 PRIMARY KEY (d_w_id, d_id) ); CREATE TABLE history ( h_date timestamp with time zone NOT NULL, h_c_id integer, h_c_w_id integer NOT NULL, h_w_id integer NOT NULL, h_c_d_id smallint NOT NULL, h_d_id smallint NOT NULL, h_amount numeric(6,2) NOT NULL, h_data character varying(24) NOT NULL ); CREATE TABLE item ( i_id integer NOT NULL, i_im_id integer NOT NULL, i_name character varying(24) NOT NULL, i_price numeric(5,2) NOT NULL, i_data character varying(50) NOT NULL, CONSTRAINT item_i1 PRIMARY KEY (i_id) ); CREATE TABLE new_order ( no_w_id integer NOT NULL, no_o_id integer NOT NULL, no_d_id smallint NOT NULL, CONSTRAINT new_order_i1 PRIMARY KEY (no_w_id, no_d_id, no_o_id) ); CREATE TABLE order_line ( ol_delivery_d timestamp with time zone, ol_o_id integer NOT NULL, ol_w_id integer NOT NULL, ol_i_id integer NOT NULL, ol_supply_w_id integer NOT NULL, ol_d_id smallint NOT NULL, ol_number smallint NOT NULL, ol_quantity smallint NOT NULL, ol_amount numeric(6,2), ol_dist_info character(24), CONSTRAINT order_line_i1 PRIMARY KEY (ol_w_id, ol_d_id, ol_o_id, ol_number) ); CREATE TABLE orders ( o_entry_d timestamp with time zone NOT NULL, o_id integer NOT NULL, o_w_id integer NOT NULL, o_c_id integer NOT NULL, o_d_id smallint NOT NULL, o_carrier_id smallint, o_ol_cnt smallint NOT NULL, o_all_local smallint NOT NULL, CONSTRAINT orders_i1 PRIMARY KEY (o_w_id, o_d_id, o_id) ); CREATE UNIQUE INDEX orders_i2 ON orders USING btree (o_w_id, o_d_id, o_c_id, o_id); CREATE TABLE stock ( s_i_id integer NOT NULL, s_w_id integer NOT NULL, s_ytd integer NOT NULL, s_quantity smallint NOT NULL, s_order_cnt smallint NOT NULL, s_remote_cnt smallint NOT NULL, s_dist_01 character(24) NOT NULL, s_dist_02 character(24) NOT NULL, s_dist_03 character(24) NOT NULL, s_dist_04 character(24) NOT NULL, s_dist_05 character(24) NOT NULL, s_dist_06 character(24) NOT NULL, s_dist_07 character(24) NOT NULL, s_dist_08 character(24) NOT NULL, s_dist_09 character(24) NOT NULL, s_dist_10 character(24) NOT NULL, s_data character varying(50) NOT NULL, CONSTRAINT stock_i1 PRIMARY KEY (s_w_id, s_i_id) ); CREATE TABLE warehouse ( w_id integer NOT NULL, w_name character varying(10) NOT NULL, w_street_1 character varying(20) NOT NULL, w_street_2 character varying(20) NOT NULL, w_city character varying(20) NOT NULL, w_state character(2) NOT NULL, w_zip character(9) NOT NULL, w_tax numeric(4,4) NOT NULL, w_ytd numeric(12,2) NOT NULL, CONSTRAINT warehouse_i1 PRIMARY KEY (w_id) ); https://www.enterprisedb.com/blog/postgresql-tproc-c-benchmarks-postgresql-12-vs-postgresql-13-performance
