맥도날드 키오스크

테이블 (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