Tea-Time
Tables (7)
Authority (Admin)
- 음료_ID (drink_id) — INT — Foreign key → Employees.음료_ID
- 권한_ID (auth_id) — INT
- 권한_이름 (auth_nm) — VARCHAR
Drinks (음료)
- 음료_ID (drink_id) — INT — Primary key
- 음료명 (drink_name) — VARCHAR
- 사용가능 (available) — BOOLEAN
Employees (직원)
- 음료_ID (drink_id) — INT — Foreign key → Drinks.음료_ID
- 직원_ID (employee_id) — INT
- 직원명 (name) — VARCHAR
- 직급 (Field) — VARCHAR
HOT&ICE (옵션(hot&ice))
- 음료_ID (drink_id) — INT — Foreign key → Drinks.음료_ID
- HOT (is_hot) — BOOLEAN
- ICE (is_ice) — BOOLEAN
SIZE (옵션(사이즈))
- 음료_ID (drink_id) — INT — Foreign key → Drinks.음료_ID
- 사이즈_M (drink_size_M) — VARCHAR
- 사이즈_L (drink_size_L) — VARCHAR
- 사이즈_S (drink_size_S) — VARCHAR
Selections (선택)
- 선택_ID (selection_id) — INT — Primary key
- 음료_ID (drink_id2) — INT — Foreign key → Employees.음료_ID
- 직원_ID (employee_id) — INT
- 음료_ID (drink_id) — INT
- 날짜 (selection_date) — DATE
Toppings (토핑)
- 음료_ID (drink_id) — INT — Foreign key → Drinks.음료_ID
- 토핑_ID (topping_id) — INT
- 토핌_이름 (topping_nm) — VARCHAR