pos_orders


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
pos_order_items.pos_order_id pos_order_items_ibfk_1 R
order_code VARCHAR 50 √ null
cashier_id INT 10 √ null
users.id pos_orders_ibfk_1 R
total_price DECIMAL 10,2 √ null
payment_method enum('cash') 4 √ null
created_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cashier_id Performance Asc cashier_id

Relationships

Close relationships within degrees of separation