laundry_orders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
laundry_order_addons.laundry_order_id laundry_order_addons_ibfk_1 R
laundry_order_items.laundry_order_id laundry_order_items_ibfk_1 R
laundry_status_history.laundry_order_id laundry_status_history_ibfk_1 R
order_code VARCHAR 50 √ null
user_id INT 10 √ null
users.id laundry_orders_ibfk_1 R
package_id INT 10 √ null
laundry_packages.id laundry_orders_ibfk_2 R
address_id INT 10 √ null
user_addresses.id laundry_orders_ibfk_3 R
pickup_time DATETIME 19 √ null
delivery_time DATETIME 19 √ null
weight_input DECIMAL 5,2 √ null
total_price DECIMAL 10,2 √ null
payment_status enum('pending', 'paid', 'cash') 7 √ pending
order_status VARCHAR 50 √ null
driver_id INT 10 √ null
users.id laundry_orders_ibfk_4 R
notes TEXT 65535 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
address_id Performance Asc address_id
driver_id Performance Asc driver_id
package_id Performance Asc package_id
user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation