방송
테이블 (13)
chatroom
- chatroom_id — int — 기본 키 — NOT NULL
- room_name — varchar — NOT NULL
chatroom_member
- member_id — int — 기본 키 — NOT NULL
- last_read_at — datetime
- user_id — int — 외래 키 → users.user_id — NOT NULL
- chatroom_id — int — 외래 키 → chatroom.chatroom_id — NOT NULL
friendship
- friendship_id — int — 기본 키 — NOT NULL
- status — varchar — NOT NULL
- requested_at — datetime — NOT NULL
- requester_id — int — 외래 키 → users.user_id — NOT NULL
- receiver_id — int — 외래 키 → users.user_id — NOT NULL
game
- game_id — int — 기본 키 — NOT NULL
- title — varchar — NOT NULL
- price — int — NOT NULL
- publisher — varchar — NOT NULL
game_genre
- game_genre_id — int — 기본 키 — NOT NULL
- game_id — int — 외래 키 → game.game_id — NOT NULL
- genre_id — int — 외래 키 → genre.genre_id — NOT NULL
genre
- genre_id — int — 기본 키 — NOT NULL
- genre_name — varchar — NOT NULL
message
- message_id — int — 기본 키 — NOT NULL
- content — text — NOT NULL
- sent_at — datetime — NOT NULL
- chatroom_id — int — 외래 키 → chatroom.chatroom_id — NOT NULL
- user_id — int — 외래 키 → users.user_id — NOT NULL
play_history
- history_id — int — 기본 키 — NOT NULL
- start_time — datetime — NOT NULL
- end_time — datetime
- play_time — int — NOT NULL
- user_id — int — 외래 키 → users.user_id — NOT NULL
- game_id — int — 외래 키 → game.game_id — NOT NULL
purchase
- purchase_id — int — 기본 키 — NOT NULL
- purchase_date — datetime — NOT NULL
- purchase_price — int — NOT NULL
- user_id — int — 외래 키 → users.user_id — NOT NULL
- game_id — int — 외래 키 → game.game_id — NOT NULL
review
- review_id — int — 기본 키 — NOT NULL
- content — text
- rating — int — NOT NULL
- user_id — int — 외래 키 → users.user_id — NOT NULL
- game_id — int — 외래 키 → game.game_id — NOT NULL
- purchase_id — int — 외래 키 → purchase.purchase_id — NOT NULL
stream
- stream_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → users.user_id — NOT NULL
- channel_name — varchar — NOT NULL
- category — varchar — NOT NULL
stream_follow
- follow_id — int — 기본 키 — NOT NULL
- followed_at — datetime — NOT NULL
- user_id — int — 외래 키 → users.user_id — NOT NULL
- stream_id — int — 외래 키 → stream.stream_id — NOT NULL
users
- user_id — int — 기본 키 — NOT NULL
- username — varchar — NOT NULL
- email — varchar — NOT NULL
- nickname — varchar — NOT NULL
- created_at — datetime — NOT NULL