3,5카페 키오스크

테이블 (5)

menu (Untitled2)

  • Key (menu_seq) — not null — 기본 키 — NOT NULL
  • Field (menu_name) — not null
  • Field (menu_cost) — not null
  • Field (menu_img) — null

menu_option (Untitled5)

  • Key (menu_option_seq) — not null — 기본 키 — NOT NULL
  • Key (menu_seq) — not null — 외래 키 → menu.Key — NOT NULL
  • Key (option_key) — not null — 외래 키 → option.Key — NOT NULL

option (Untitled3)

  • Key (option_key) — not null — 기본 키 — NOT NULL
  • Field (option_name) — not null
  • Field (option_code) — not null

order (Untitled4)

  • Key (order_seq) — not null — 기본 키 — NOT NULL
  • Key (menu_seq) — not null — 외래 키 → menu.Key — NOT NULL
  • Field (order_temp) — not null
  • Field (order_milk) — null
  • Field (order_shot) — null

point (Untitled)

  • Key (user_seq) — not null — 기본 키 — NOT NULL
  • Key (order_seq) — not null — 외래 키 → order.Key — NOT NULL
  • Key (menu_seq) — not null — 외래 키 → order.Key — NOT NULL
  • Field (phone_num) — not null
  • Field (point) — not null