orders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
order_items.order_id order_items_ibfk_1 R
order_code VARCHAR 50 √ null
user_id INT 10 √ null
users.id orders_ibfk_1 R
address_id INT 10 √ null
user_addresses.id orders_ibfk_2 R
total_price DECIMAL 10,2 √ null
payment_status enum('pending', 'paid', 'cash') 7 √ null
order_status VARCHAR 50 √ null
driver_id INT 10 √ null
users.id orders_ibfk_3 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
user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation