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)
  • email
  • nickname
  • created_at