store_orders_fact

This table contains information about all orders made at the company’s brick-and-mortar stores.

Column Name Data Type NULLs
product_key
INTEGER No
product_version
INTEGER No
store_key
INTEGER No
vendor_key
INTEGER No
employee_key
INTEGER No
order_number
INTEGER No
date_ordered
DATE Yes
date_shipped
DATE Yes
expected_delivery_date
DATE Yes
date_delivered
DATE Yes
quantity_ordered
INTEGER Yes
quantity_delivered
INTEGER Yes
shipper_name
VARCHAR(32) Yes
unit_price
INTEGER Yes
shipping_cost
INTEGER Yes
total_order_cost
INTEGER Yes
quantity_in_stock
INTEGER Yes
reorder_level
INTEGER Yes
overstock_ceiling
INTEGER Yes