order_items

source

Line-level detail behind every order.

Definition

Per-line basket items for each order — quantity × unit_price captured at order time (so the figure is stable even if the catalog price changes later). The grain when a revenue question needs a product-mix breakdown rather than an order-total breakdown.

7 of 7

Column

Description

Tests · PII

order_item_id

Primary key — BIGSERIAL on the source.

2 tests

order_id

FK to `orders.order_id`. NOT NULL.

customer +3 PII1 test

product_id

FK to `products.product_id`. NOT NULL.

1 test

quantity

Units purchased on this line.

unit_price

Per-unit price captured at order time. Source-of-truth for revenue (may differ from current catalog `products.unit_price`).

line_amount

Line subtotal — `quantity * unit_price` materialised at write time.

created_at

Row insert timestamp in the source DB.