db

Tables (20)

BOYFRIEND

  • boyfriend_id — INT — Primary key — NOT NULL
  • name — VARCHAR
  • age — INT
  • mbti — VARCHAR
  • charm_point — VARCHAR

CAFE

  • cafe_id — INT — Primary key — NOT NULL
  • cafe_name — VARCHAR
  • location — VARCHAR
  • phone — VARCHAR

CHATROOM

  • chatroom_id — INT — Primary key — NOT NULL
  • room_name — VARCHAR

CHATROOM_MEMBER

  • member_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • chatroom_id — INT — Foreign key → CHATROOM.chatroom_id
  • last_read_at — DATETIME

CUSTOMER

  • customer_id — INT — Primary key — NOT NULL
  • nickname — VARCHAR
  • name — VARCHAR
  • phone — VARCHAR

FRIENDSHIP

  • friendship_id — INT — Primary key — NOT NULL
  • requester_id — INT — Foreign key → USER.user_id
  • receiver_id — INT — Foreign key → USER.user_id
  • status — VARCHAR
  • requested_at — DATETIME

GAME

  • game_id — INT — Primary key — NOT NULL
  • title — VARCHAR
  • price — INT
  • publisher — VARCHAR

GAME_GENRE

  • game_id — INT — Foreign key → GAME.game_id — NOT NULL
  • genre_id — INT — Foreign key → GENRE.genre_id — NOT NULL

GENRE

  • genre_id — INT — Primary key — NOT NULL
  • genre_name — VARCHAR

MESSAGE

  • message_id — INT — Primary key — NOT NULL
  • chatroom_id — INT — Foreign key → CHATROOM.chatroom_id
  • user_id — INT — Foreign key → USER.user_id
  • content — TEXT
  • sent_at — DATETIME

PLACE

  • place_id — INT — Primary key — NOT NULL
  • place_name — VARCHAR
  • atmosphere — VARCHAR
  • is_reserved — BOOLEAN

PLAY_HISTORY

  • history_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • game_id — INT — Foreign key → GAME.game_id
  • start_time — DATETIME
  • end_time — DATETIME
  • play_time — INT

PURCHASE

  • purchase_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • game_id — INT — Foreign key → GAME.game_id
  • purchase_date — DATE
  • purchase_price — INT

RESERVATION

  • reservation_id — INT — Primary key — NOT NULL
  • customer_id — INT — Foreign key → CUSTOMER.customer_id
  • theme_id — INT — Foreign key → THEME.theme_id
  • reservation_date — DATE
  • reservation_time — TIME
  • player_cnt — INT
  • is_success — BOOLEAN
  • escape_time — INT
  • hint_cnt — INT

REVIEW

  • review_id — INT — Primary key — NOT NULL
  • content — TEXT
  • rating — INT
  • user_id — INT — Foreign key → USER.user_id — NOT NULL
  • game_id — INT — Foreign key → GAME.game_id — NOT NULL

SCHEDULE

  • schedule_id — INT — Primary key — NOT NULL
  • boyfriend_id — INT — Foreign key → BOYFRIEND.boyfriend_id
  • place_id — INT — Foreign key → PLACE.place_id
  • schedule_date — DATE
  • satisfaction — INT
  • review — TEXT

STREAM

  • stream_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • channel_name — VARCHAR
  • category — VARCHAR

STREAM_FOLLOW

  • follow_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • stream_id — INT — Foreign key → STREAM.stream_id
  • followed_at — DATETIME

THEME

  • theme_id — INT — Primary key — NOT NULL
  • cafe_id — INT — Foreign key → CAFE.cafe_id
  • theme_name — VARCHAR
  • difficulty — INT
  • genre — VARCHAR
  • time_limit — INT
  • max_players — INT

USER

  • user_id — INT — Primary key — NOT NULL
  • username — VARCHAR
  • email — VARCHAR
  • nickname — VARCHAR
  • created_at — DATETIME