실습2
테이블 (13)
CHATROOM
- chatroom_id — int — 기본 키 — NOT NULL
- room_name — varchar
CHATROOM_MEMBER
- member_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- chatroom_id — int — 외래 키 → CHATROOM.chatroom_id
- last_read_at — datetime
- Field
FRIENDSHIP
- friendship_id — int — 기본 키 — NOT NULL
- requester_id — int — 외래 키 → USER.user_id
- receiver_id — int — 외래 키 → USER.user_id
- status — varchar
- requested_at — datetime
GAME
- game_id — int — 기본 키 — NOT NULL
- title — varchar
- price — int
- publisher — varchar
GAME_GENRE
- game_id — int — 외래 키 → GAME.game_id — NOT NULL
- genre_id — int — 외래 키 → GENRE.genre_id — NOT NULL
- Field
GENRE
- genre_id — int — 기본 키 — NOT NULL
- genre_name — varchar
MESSAGE
- message_id — int — 기본 키 — NOT NULL
- chatroom_id — int — 외래 키 → CHATROOM.chatroom_id
- user_id — int — 외래 키 → USER.user_id
- content — varchar
- sent_at — datetime
PLAY_HISTORY
- history_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- game_id — int — 외래 키 → GAME.game_id
- start_time — datetime
- end_time — datetime
- play_time — int
- Field
PURCHASE
- purchase_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- game_id — int — 외래 키 → GAME.game_id
- purchase_date — datetime
- purchase_price — int
- Field
REVIEW
- review_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- game_id — int — 외래 키 → GAME.game_id
- content — varchar
- rating — int
- Field
STREAM
- stream_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- channel_name — varchar
- category — varchar
- Field
STREAM_FOLLOW
- follow_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- stream_id — int — 외래 키 → STREAM.stream_id
- followed_at — datetime
- Field
USER
- user_id — int — 기본 키 — NOT NULL
- username — varchar
- email — varchar
- nickname — varchar
- created_at — datetime