test
Tables (21)
BOYFRIEND
- boyfriend_id — Primary key — NOT NULL
- 이름
- 나이
- MBTI (Field3)
- 매력포인트
CAFE
- cafe_id — Primary key — NOT NULL
- cafe_name
- location
- phone
CHATROOM
- chatroom_id — Primary key — NOT NULL
- room_name
CHATROOM_MEMBER
- member_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- chatroom_id — Foreign key → CHATROOM.chatroom_id — NOT NULL
- ast_read_at
CUSTOMER
- customer_id — Primary key — NOT NULL
- nickname
- name
- phone
FRIENDSHIP
- friendship_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- user_id (user_id2) — Foreign key → USER.user_id — NOT NULL
- status
- requested_at
GAME
- game_id — Primary key — NOT NULL
- title
- price
- publisher
GAME_GENRE
- game_id — Foreign key → GAME.game_id — NOT NULL
- genre_id — Foreign key → GENRE.genre_id — NOT NULL
GENRE
- genre_id — Primary key — NOT NULL
- genre_name
MESSAGE
- message_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- chatroom_id — Foreign key → CHATROOM.chatroom_id — NOT NULL
- content
- sent_at
PLACE
- place_id — Primary key — NOT NULL
- 상호명
- 분위기
- 예약여부
PLAY_HISTORY
- history_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- game_id — Foreign key → GAME.game_id — NOT NULL
- start_time
- end_time
- play_time
PURCHASE
- purchase_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- game_id — Foreign key → GAME.game_id — NOT NULL
- purchase_date
- purchase_price
RESERVATION
- reservation_id — Primary key — NOT NULL
- customer_id — Foreign key → CUSTOMER.customer_id — NOT NULL
- theme_id — Foreign key → THEME.theme_id — NOT NULL
- cafe_id — Foreign key → THEME.cafe_id — NOT NULL
- 날짜
- Field (시간)
- Field2 (player_cnt)
- Field3 (is_success)
- Field4 (escape_time)
- hint_cnt
REVIEW
- review_id — Primary key — NOT NULL
- reservation_id — Foreign key → RESERVATION.reservation_id — NOT NULL
- customer_id — Foreign key → RESERVATION.customer_id — NOT NULL
- theme_id — Foreign key → RESERVATION.theme_id — NOT NULL
- cafe_id — Foreign key → RESERVATION.cafe_id — NOT NULL
- rating
- content
- created_at (Field)
REVIEW2
- review_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- game_id — Foreign key → GAME.game_id — NOT NULL
- content
- rating
SCHEDULE
- schedule_id — Primary key — NOT NULL
- boyfriend_id — Foreign key → BOYFRIEND.boyfriend_id — NOT NULL
- place_id — Foreign key → PLACE.place_id — NOT NULL
- 날짜
- 만족도
- 후기
STREAM
- stream_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- channel_name
- category
STREAM_FOLLOW
- follow_id — Primary key — NOT NULL
- user_id — Foreign key → USER.user_id — NOT NULL
- stream_id — Foreign key → STREAM.stream_id — NOT NULL
- user_id (user_id2) — Foreign key → STREAM.user_id — NOT NULL
- followed_at
THEME
- theme_id — Primary key — NOT NULL
- cafe_id — Foreign key → CAFE.cafe_id — NOT NULL
- theme_name
- difficulty
- genre
- Field
USER
- user_id — Primary key — NOT NULL
- username (Field)
- nickname
- created_at