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