Table
order_line
Products and quantities in an order, with the price charged.
Replaces in 2020: Invoices
Rows 2,801–2,825 of 5,412
| order_id→ purchase_order.order_id | product_id→ product.product_id | quantityINTEGER | unit_price_centsINTEGER |
|---|---|---|---|
| 2801 | 3 | 1 | 800 |
| 2802 | 3 | 1 | 800 |
| 2803 | 1 | 1 | 1500 |
| 2804 | 1 | 1 | 1500 |
| 2805 | 1 | 1 | 1500 |
| 2806 | 1 | 5 | 1500 |
| 2807 | 1 | 1 | 1500 |
| 2808 | 1 | 4 | 1500 |
| 2809 | 1 | 3 | 1500 |
| 2810 | 3 | 1 | 800 |
| 2811 | 3 | 1 | 800 |
| 2812 | 1 | 1 | 1500 |
| 2813 | 1 | 4 | 1500 |
| 2814 | 1 | 1 | 1500 |
| 2815 | 1 | 1 | 1500 |
| 2816 | 3 | 1 | 800 |
| 2817 | 1 | 56 | 1500 |
| 2818 | 1 | 1 | 1500 |
| 2819 | 2 | 2 | 1700 |
| 2820 | 3 | 1 | 800 |
| 2821 | 2 | 1 | 1700 |
| 2822 | 3 | 1 | 800 |
| 2823 | 4 | 1 | 400 |
| 2824 | 1 | 2 | 1500 |
| 2825 | 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;