openSW-kioks
Tables (3)
Menu (메뉴)
- id — PK — Primary key — NOT NULL
- 상품명 (name) — Not NULL
- 가격 (price) — Not NULL
Order (주문)
- id — PK — Primary key — NOT NULL
- 주문시간 (time) — Not NULL
- 총액 (total) — Not NULL
OrderMenu (주문목록)
- id — PK — Primary key — NOT NULL
- 메뉴ID (menu_id) — FK — Foreign key → Menu.id — NOT NULL
- 주문ID (order_id) — FK — Foreign key → Order.id — NOT NULL
- 수량 (amount) — Not NULL