ㅁㄴㅇㄹㅁㄴㅇㄹㅁ

Tables (6)

CAFE

  • cafe_id — INT — Primary key — NOT NULL
  • theme_id — INT — Foreign key → THEME.theme_id — NOT NULL
  • cafe_id (cafe_id3) — INT — Foreign key → THEME.cafe_id — NOT NULL
  • Key — Foreign key → THEME.Key — NOT NULL
  • cafe_name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100)
  • phone — VARCHAR(20)
  • theme_id (theme_id2) — INT — Foreign key → THEME.theme_id — NOT NULL
  • cafe_id (cafe_id32) — INT — Foreign key → THEME.cafe_id — NOT NULL
  • theme_id (theme_id22) — INT — Foreign key → THEME.theme_id — NOT NULL
  • cafe_id (cafe_id322) — INT — Foreign key → THEME.cafe_id — NOT NULL
  • Key (Key2) — Foreign key → THEME.Key — NOT NULL

CUSTOMER

  • customer_id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)

RESERVATION

  • reservation_id — INT — Primary key — NOT NULL
  • customer_id (customer_id2) — INT — Foreign key → CUSTOMER.customer_id — NOT NULL
  • customer_id — INT — NOT NULL
  • theme_id — INT — NOT NULL
  • reserved_at — DATETIME — NOT NULL
  • participant_count — INT
  • is_success — BOOLEAN
  • escape_time — INT
  • hint_count — INT

REVIEW

  • review_id — INT — Primary key — NOT NULL
  • reservation_id — INT — NOT NULL
  • rating — INT
  • content — TEXT
  • written_at — DATETIME

THEME

  • theme_id — INT — Primary key — NOT NULL
  • cafe_id (cafe_id3) — INT — Foreign key → CAFE.cafe_id — NOT NULL
  • theme_id (theme_id2) — INT — Foreign key → CAFE.theme_id — NOT NULL
  • cafe_id (cafe_id32) — INT — Foreign key → CAFE.cafe_id — NOT NULL
  • Key — Foreign key → Untitled.Key — NOT NULL
  • cafe_id — INT — NOT NULL
  • theme_name — VARCHAR(100) — NOT NULL
  • difficulty — VARCHAR(10)
  • genre — VARCHAR(20)
  • time_limit — INT
  • max_capacity — INT
  • cafe_id (cafe_id2) — INT — Foreign key → CAFE.cafe_id — NOT NULL
  • theme_id (theme_id3) — INT — Foreign key → CAFE.theme_id — NOT NULL
  • cafe_id (cafe_id33) — INT — Foreign key → CAFE.cafe_id — NOT NULL

Untitled

  • Key — Primary key — NOT NULL
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field