OPICK
Tables (11)
Admins
- admin_id — INT
- store_id — INT
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- role — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
CartItems
- cart_item_id — INT
- cart_id — INT
- menu_id — INT
- quantity — INT
- price — DECIMAL(10,2)
- created_at — DATETIME
- updated_at — DATETIME
Carts
- cart_id — INT
- user_id — INT
- device_id — VARCHAR(255)
- table_id — INT
- status — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
MenuCategories
- category_id — INT
- store_id — INT
- name — VARCHAR(255)
- display_order — INT
- created_at — DATETIME
- updated_at — DATETIME
MenuItems
- menu_id — INT
- store_id — INT
- category_id — INT
- name — VARCHAR(255)
- description — TEXT
- price — DECIMAL(10,2)
- image_url — VARCHAR(255)
- is_soldout — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
OrderItems
- order_item_id — INT
- order_id — INT
- menu_id — INT
- quantity — INT
- price — DECIMAL(10,2)
- subtotal — DECIMAL(10,2)
- created_at — DATETIME
- updated_at — DATETIME
Orders
- order_id — INT
- store_id — INT
- table_id — INT
- status — VARCHAR(50)
- total_price — DECIMAL(10,2)
- payment_method — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
Payments
- payment_id — INT
- order_id — INT
- pg_transaction_id — VARCHAR(255)
- payment_type — VARCHAR(50)
- amount — DECIMAL(10,2)
- status — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
Stores
- store_id — INT
- store_name — VARCHAR(255)
- address — VARCHAR(255)
- phone_number — VARCHAR(20)
- business_hours — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
TableSessions
- session_id — INT
- table_id — INT
- status — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
Tables
- table_id — INT
- store_id — INT
- table_number — VARCHAR(50)
- nfc_tag_id — VARCHAR(100)
- status — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME