맥도날드 키오스크
테이블 (7)
customer
- customer_id — INT
- name — VARCHAR(100)
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- membership_status — BOOLEAN
employee
- employee_id — INT
- name — VARCHAR(100)
- role — VARCHAR(50)
- kiosk_id — INT
kiosk
- kiosk_id — INT
- location — VARCHAR(100)
- status — VARCHAR(20)
- last_maintenance — TIMESTAMP
order
- order_id — INT
- customer_id — INT
- order_date — TIMESTAMP
- total_amount — DECIMAL(10, 2)
- payment_status — VARCHAR(20)
- order_status — VARCHAR(20)
order_item
- order_item_id — INT
- order_id — INT
- menu_id — INT
- quantity — INT
- subtotal — DECIMAL(10, 2)
payment
- payment_id — INT
- order_id — INT
- payment_method — VARCHAR(50)
- payment_date — TIMESTAMP
- amount — DECIMAL(10, 2)
메뉴 (menu)
- 메뉴아이디 (menu_id) — INT
- 메뉴명 (name) — VARCHAR(100)
- 가격 (price) — DECIMAL(10, 2)
- 카테고리 (category) — VARCHAR(50)
- 가능한지여부 (is_available) — BOOLEAN
- 칼로리 (Field) — INT