orders

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
influencer_product_sales.order_id influencer_product_sales_order_id_fkey R
inventory_reserves.order_id inventory_reserves_ibfk_1 R
order_commissions.order_id order_commissions_order_id_fkey R
order_items.order_id order_items_ibfk_1 R
payments.order_id payments_ibfk_1 R
raffle_purchases.order_id raffle_purchases_ibfk_2 R
receipts.order_id receipts_order_id_fkey C
refunds.order_id refunds_order_id_fkey R
return_requests.order_id return_requests_order_id_fkey R
shipments.order_id shipments_order_id_fkey C
shipping_labels.order_id shipping_labels_order_id_fkey R
shipping_tracking.ordersId shipping_tracking_ordersId_fkey N
user_id INT 10 null
users.id orders_ibfk_1 R
shop_id INT 10 null
shops.id orders_ibfk_2 R
total_amount DECIMAL 12,2 null
status enum('PENDING', 'PREPARING', 'SHIPPED', 'DELIVERED', 'COMPLETED', 'CANCELLED', 'RETURNED') 9 null
ordered_at DATETIME 19 null
created_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null
updated_at DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
shop_id Performance Asc shop_id
user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation