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