과제

테이블 (10)

CAFE (Untitled5)

  • pk (Key) — 기본 키 — NOT NULL
  • Field
  • Field2

CAFE

  • cafe_id — VARCHAR(50) — 기본 키 — NOT NULL
  • phone (.) — VARCHAR(50)
  • cafe_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100)

CUSTOMER

  • customer_id — VARCHAR(50) — 기본 키 — NOT NULL
  • nickname — VARCHAR(50)
  • name — VARCHAR(50)
  • phone — VARCHAR(50)

RESERVATION

  • reservation_id — VARCHAR(50) — 기본 키 — NOT NULL
  • customer_id — VARCHAR(50) — 외래 키 → CUSTOMER.customer_id — NOT NULL
  • theme_id — VARCHAR(50) — 외래 키 → THEME.theme_id — NOT NULL
  • reservation_date — DATE
  • reservation_time — TIME
  • player_cnt — INT
  • is_success — VARCHAR(10)
  • escape_time — TIME
  • hint_cnt — INT

REVIEW

  • review_id — VARCHAR(50) — 기본 키 — NOT NULL
  • reservation_id — VARCHAR(50) — 외래 키 → RESERVATION.reservation_id — NOT NULL
  • rating — INT
  • content — TEXT
  • created_at — DATETIME
  • customer_id (2) — VARCHAR(50) — 외래 키 — NOT NULL

THEME

  • theme_id — VARCHAR(50) — 기본 키 — NOT NULL
  • cafe_id — VARCHAR(50) — 외래 키 → CAFE.cafe_id — NOT NULL
  • theme_name — VARCHAR(100)
  • difficulty — INT
  • genre — VARCHAR(50)
  • time_limit — INT
  • max_players — INT

Untitled

    Untitled2

      Untitled3

        Untitled4