users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
carts.user_id carts_ibfk_1 R
daily_reports.created_by daily_reports_ibfk_1 R
delivery_requests.driver_id delivery_requests_ibfk_1 R
delivery_status_history.driver_id delivery_status_history_ibfk_2 R
laundry_orders.driver_id laundry_orders_ibfk_4 R
laundry_orders.user_id laundry_orders_ibfk_1 R
laundry_status_history.driver_id laundry_status_history_ibfk_2 R
orders.driver_id orders_ibfk_3 R
orders.user_id orders_ibfk_1 R
pos_orders.cashier_id pos_orders_ibfk_1 R
product_stock.updated_by product_stock_ibfk_2 R
stock_movements.created_by stock_movements_ibfk_2 R
user_addresses.user_id user_addresses_ibfk_1 R
user_devices.user_id user_devices_ibfk_1 R
role_id INT 10 null
roles.id users_ibfk_1 R
name VARCHAR 100 √ null
phone VARCHAR 20 √ null
email VARCHAR 100 √ null
password VARCHAR 255 √ null
profile_image VARCHAR 255 √ null
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
email Must be unique Asc email
role_id Performance Asc role_id

Relationships

Close relationships within degrees of separation