Table

order_line

Products and quantities in an order, with the price charged.

Replaces in 2020: Invoices

Rows 126–150 of 5,412

order_line, page 6 of 217
order_id→ purchase_order.order_id	product_id→ product.product_id	quantityINTEGER	unit_price_centsINTEGER
126	2	3	1700
127	3	1	800
128	2	1	1700
129	2	2	1700
130	1	1	1500
131	2	1	1700
132	4	1	400
133	3	1	800
134	2	1	1700
135	1	1	1500
136	3	1	800
137	3	1	800
138	1	4	1500
139	2	2	1700
140	1	1	1500
141	2	2	1700
142	1	2	1500
143	1	2	1500
144	1	2	1500
145	1	2	1500
146	1	3	1500
147	1	1	1500
148	1	2	1500
149	1	2	1500
150	4	1	400

Table definition

CREATE TABLE order_line (
  order_id         INTEGER NOT NULL REFERENCES purchase_order (order_id),
  product_id       INTEGER NOT NULL REFERENCES product (product_id),
  quantity         INTEGER NOT NULL CHECK (quantity > 0),
  unit_price_cents INTEGER NOT NULL CHECK (unit_price_cents >= 0),
  PRIMARY KEY (order_id, product_id)
) STRICT;