방탈출 구인

테이블 (7)

cafe (Untitled6)

  • cafe_id (Key) — 기본 키 — NOT NULL
  • cafe_name (Field)
  • address (Field2)
  • hompage (Field3)
  • theme_cnt (Field4)

chat (Untitled7)

  • chat_id (Key) — 기본 키 — NOT NULL
  • sender (Field)
  • message (Field2)
  • time (Field3)
  • room_id (Key3) — 외래 키 → room.room_id — NOT NULL

member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • email (unique)
  • password (Field)
  • phone_number (Field2)
  • user_name (Field3)

review (Untitled4)

  • review_id (Key) — 기본 키 — NOT NULL
  • member_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • member_cnt (Field)
  • result (Field2)
  • play_time (Field3)
  • message (Field4)
  • difficulty (Field5)
  • horror_level (Field6)
  • activity_level (Field7)
  • story (Field8)
  • quiz (Field9)
  • satisfaction (Field10)
  • cafe_name (Field11)
  • address (Field12)
  • play_date (Field13)
  • them_name (Field14)
  • hint_use_cnt (Field15)
  • time_limit (Field16)

room (Untitled3)

  • room_id (Key3) — 기본 키 — NOT NULL
  • leader_id (Field)
  • room_limit (Field3)
  • theme_name (Field2)
  • room_name (Field4)
  • room_desc (Field5)
  • time (Field6)
  • address (Field7)
  • cafe_name (Field8)
  • fee (Field9)
  • current_cnt (Field10)
  • game_result (Field11)

roomMember (Untitled10)

  • room_member_id (Key2) — 기본 키 — NOT NULL
  • paidStatus (filed) — enum
  • member_id (Key) — 외래 키 → member.member_id — NOT NULL
  • room_id (Key3) — 외래 키 → room.room_id — NOT NULL
  • join_ status (Field)

theme_info (Untitled9)

  • theme_name (Key) — 기본 키 — NOT NULL
  • cafe_id (Key2) — 외래 키 → cafe.cafe_id — NOT NULL
  • play_time (Field)
  • difficulty (Field2)
  • horror_level (Field3)
  • activity_level (Field4)
  • story (Field5)
  • quiz (Field6)
  • satisfaction (Field7)
  • desc (Field8)