shipments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
shipping_tracking.shipment_id shipping_tracking_shipment_id_fkey C
order_id INT 10 null
orders.id shipments_order_id_fkey C
tracking_number VARCHAR 255 null
carrier VARCHAR 100 null
status enum('PENDING', 'SHIPPED', 'DELIVERED', 'CANCELLED') 9 null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_shipments_order_id Performance Asc order_id
idx_shipments_tracking_number Performance Asc tracking_number

Relationships

Close relationships within degrees of separation