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