zxcv
Tables (5)
inventory
- inventory_id — int — Primary key — NOT NULL
- menu_id — int — Foreign key → menu.menu_id — NOT NULL
- stock — int — NOT NULL
menu
- menu_id — int — Primary key — NOT NULL
- menu_name — varchar(255) — NOT NULL
- price — decimal(10,0) — NOT NULL
order
- order_id — int — Primary key — NOT NULL
- order_time — timestamp — NOT NULL
order_menu
- order_menu_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → order.order_id — NOT NULL
- menu_id — int — Foreign key → menu.menu_id — NOT NULL
- quantity — int — NOT NULL
payment
- payment_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → order.order_id — NOT NULL
- payment_method — enum('카드','현금') — NOT NULL
- payment_amount — decimal(20,0) — NOT NULL
- payment_time — timestamp — NOT NULL