방탈출 구인
테이블 (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)