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