order

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
order_id INT UNSIGNED 10 √ null
order_product.order_id order_product_order_order_id_fk R
status enum('pending', 'cancelled', 'completed') 9 pending
created_date DATETIME 19 CURRENT_TIMESTAMP
pickup_date DATETIME 19 √ null

Date when client picks up his order at the store
client_id INT UNSIGNED 10 √ null
client.user_id order_fk N
store_id INT UNSIGNED 10 null
store.store_id order_store_store_id_fk R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc order_id
order_fk Performance Asc client_id
order_store_store_id_fk Performance Asc store_id

Relationships

Close relationships within degrees of separation