ㅊㅇ
Tables (7)
Booth
- booth_id — VARCHAR(255) — Primary key — NOT NULL
- booth_name — VARCHAR(50)
- total_revenues — INT
- booth_field — VARCHAR(255)
BoothTable
- table_id — VARCHAR(255) — Primary key — NOT NULL
- booth_id — VARCHAR(255) — Primary key — NOT NULL
- table_num — INT
Cart
- cart_id — VARCHAR(255) — Primary key — NOT NULL
- table_id — VARCHAR(255)
- is_ordered — BOOLEAN
Manager
- manager_id — VARCHAR(255) — Primary key — NOT NULL
- booth_id — VARCHAR(255)
- username — VARCHAR(50)
- password — VARCHAR(255)
- table_num — INT
- order_check_password — INT
- account_number — VARCHAR(30)
- bank_name — VARCHAR(20)
- seat_type — ENUM('NONE', 'PERSON', 'TABLE')
- seat_tax_person — INT
- seat_tax_table — INT
Menu
- menu_id — VARCHAR(255) — Primary key — NOT NULL
- booth_id — VARCHAR(255)
- name — VARCHAR(50)
- nickname — VARCHAR(50)
- category — ENUM('MENU', 'DRINK', 'CHARGE')
- price — INT
- quantity — INT
- image_url — VARCHAR(255)
- description — VARCHAR(100)
- is_sold_out — BOOLEAN
- created_at — DATETIME
Order
- order_id — VARCHAR(255) — Primary key — NOT NULL
- table_id — VARCHAR(255)
- order_amount — INT
- order_status — VARCHAR(20)
- created_at — DATETIME
- updated_at — DATETIME
OrderMenu
- id — VARCHAR(255) — Primary key — NOT NULL
- order_id — VARCHAR(255)
- menu_id — VARCHAR(255)
- quantity — INT
- price_at_order_time — INT
- status — ENUM('ORDERED', 'CANCELLED', 'SERVED')