Table

order_line

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

Replaces in 2020: Invoices

Rows 1–25 of 5,412

order_line, page 1 of 217
order_id→ purchase_order.order_id	product_id→ product.product_id	quantityINTEGER	unit_price_centsINTEGER
1	1	2	1500
2	1	2	1500
3	1	2	1500
4	1	1	1500
5	1	58	1500
6	1	2	1500
7	1	4	1500
8	3	1	800
9	1	1	1500
10	4	1	400
11	4	1	400
12	2	2	1700
13	1	1	1500
14	1	2	1500
15	1	2	1500
16	1	1	1500
17	2	1	1700
18	1	1	1500
19	4	1	400
20	1	3	1500
21	2	1	1700
22	2	1	1700
23	2	2	1700
24	3	1	800
25	2	1	1700

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;