jihyeT

테이블 (3)

손님 (CUSTOMER)

  • customer_id — char — 기본 키 — NOT NULL — PK
  • nickname — char
  • name — char
  • phone — char

카페 (CAFE)

  • cafe_id — char — 기본 키 — NOT NULL — PK
  • cafe_name — char
  • location — char
  • phone — char

테마 (THEME)

  • theme_id — char — 기본 키 — NOT NULL — PK
  • cafe_id — char — 외래 키 → 카페.cafe_id — NOT NULL — FK
  • theme_name — char
  • difficulty — number
  • genre — char
  • time_limit