실습2
테이블 (13)
CHATROOM (Untitled5)
- chatroom_id (PK) — 기본 키 — NOT NULL
- room_name (Field)
CHATROOM_MEMBER (Untitled11)
- member_id (PK) — 기본 키 — NOT NULL
- user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
- chatroom_id (PK3) — 외래 키 → CHATROOM.chatroom_id — NOT NULL
FRIENDSHIP (Untitled13)
- friendship_id (PK) — 기본 키 — NOT NULL
- requester_id (PK2) — 외래 키 → USER.user_id — NOT NULL
- receiver_id (PK3) — 외래 키 → USER.user_id — NOT NULL
- status (Field)
- requested_at (Field2)
GAME (Untitled3)
- game_id (PK) — 기본 키 — NOT NULL
- title (Field)
- price (Field2)
- game_id (Field3)
GAME_GENRE (Untitled10)
- game_id (PK) — 외래 키 → GAME.game_id — NOT NULL
- genre_id (PK2) — 외래 키 → GENRE.genre_id — NOT NULL
GENRE (Untitled4)
- genre_id (PK) — 기본 키 — NOT NULL
- genre_name (Field) — NOT NULL
MESSAGE (Untitled7)
- message_id (PK) — 기본 키 — NOT NULL
- chatroom_id (PK2) — 외래 키 → CHATROOM.chatroom_id — NOT NULL
- user_id (PK3) — 외래 키 → USER.user_id — NOT NULL
- content (Field)
- sent_at (Field2)
PLAY_HISTORY (Untitled9)
- history_id (PK) — 기본 키 — NOT NULL
- user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
- game_id (PK3) — 외래 키 → GAME.game_id — NOT NULL
- start_time (Field)
- end_time (Field2)
- play_time (Field3)
PURCHASE (Untitled8)
- purchase (PK) — 기본 키 — NOT NULL
- user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
- game_id (PK3) — 외래 키 → GAME.game_id — NOT NULL
- purchase_date (Field)
- purchase_price (Field2)
REVIEW (Untitled6)
- review_id (PK) — 기본 키 — NOT NULL
- user_id (FK) — 외래 키 → USER.user_id — NOT NULL
- game_id (PK2) — 외래 키 → GAME.game_id — NOT NULL
- content (Field)
- rating (Field2)
STREAM (Untitled2)
- stream_id (PK) — 기본 키 — NOT NULL
- user_id (FK) — 외래 키 → USER.user_id — NOT NULL
- channel_name (Field)
- category (Field2)
STREAM_FOLLOW (Untitled12)
- follow_id (PK) — 기본 키 — NOT NULL
- user_id (PK2) — 외래 키 → USER.user_id — NOT NULL
- stream_id (PK3) — 외래 키 → STREAM.stream_id — NOT NULL
- followed_at (Field)
USER (Untitled)
- user_id (PK) — 기본 키 — NOT NULL
- username (Field)
- email (Field2)
- nickname (Field3)
- created_at (Field4)