과제2
테이블 (25)
CHATROOM
- chatroom_id — int — 기본 키 — NOT NULL
- room_name — varchar(100)
CHATROOM (Untitled5)
- chatroom_id (Key) — VARCHAR(100) — 기본 키 — NOT NULL
- room_name (Field) — VARCHAR(100)
CHATROOM_MEMBER
- member_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- chatroom_id — int — 외래 키 → CHATROOM.chatroom_id
- last_read_at — date
CHATROOM_MEMBER' (Untitled11)
- Key — 기본 키 — NOT NULL
- Field
FRIENDSHIP
- friendship_id — int — 기본 키 — NOT NULL
- requester_id — int — 외래 키 → USER.user_id
- receiver_id — int — 외래 키 → USER.user_id
- status — varchar(100)
- requested_at — date
FRIENDSHIP (Untitled13)
- Key — 기본 키 — NOT NULL
- Field
GAME (Untitled3)
- game_id (Key) — VARCHAR(100) — 기본 키 — NOT NULL
- title (Field) — VARCHAR(100)
- price (Field2) — INT
- publisher (Field3) — VARCHAR(100)
GAME
- game_id — int — 기본 키 — NOT NULL
- title — varchar(100)
- price — int
- publisher — varchar(100)
GAME_GENRE (Untitled9)
- Key — 기본 키 — NOT NULL
- Field
GAME_GENRE
- game_id — int — 외래 키 → GAME.game_id — NOT NULL
- genre_id — int — 외래 키 → GENRE.genre_id — NOT NULL
GENRE (Untitled4)
- genre_id (Key) — VARCHAR(100) — 기본 키 — NOT NULL
- genre_name (Field) — VARCHAR(100)
GENRE
- genre_id — int — 기본 키 — NOT NULL
- genre_name — varchar(100)
MESSAGE (Untitled7)
- Key — 기본 키 — NOT NULL
- Field
MESSAGE
- message_id — int — 기본 키 — NOT NULL
- chatroom_id — int — 외래 키 → CHATROOM.chatroom_id
- user_id — int — 외래 키 → USER.user_id
- content — varchar(100)
- sent_at — date
PLAY_HISTORY (Untitled10)
- Key — 기본 키 — NOT NULL
- Field
PLAY_HISTORY
- history_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- game_id — int — 외래 키 → GAME.game_id
- start_time — date
- end_time — date
- play_time — int
PURCHASE (Untitled8)
- Key — 기본 키 — NOT NULL
- Field
PURCHASE
- purchase_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- game_id — int — 외래 키 → GAME.game_id
- purchase_date — date
- purchase_price — int
REVIEW
- review_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- game_id — int — 외래 키 → GAME.game_id
- content — varchar(100)
- rating — int
STREAM (Untitled2)
- stream_id (Key) — varchar(100) — 기본 키 — NOT NULL
- user_id (Key2) — VARCHAR(100) — 외래 키 → USER.user_id — NOT NULL
- game_id (Key3) — VARCHAR(100) — 외래 키 → GAME.game_id — NOT NULL
- review_id (Key22) — VARCHAR(100) — 외래 키 — NOT NULL
- user_id (Key222) — VARCHAR(100) — 외래 키 — NOT NULL
- chatroom_id (Key32) — VARCHAR(100) — 외래 키 — NOT NULL
- user_id (Field) — VARCHAR(100)
- channel_name (Field2) — VARCHAR(100)
- category (Field3) — VARCHAR(100)
STREAM
- stream_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- channel_name — varchar(100)
- category — varchar(100)
STREAM_FOLLOW (Untitled12)
- Key — 기본 키 — NOT NULL
- Field
STREAM_FOLLOW
- follow_id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → USER.user_id
- stream_id — int — 외래 키 → STREAM.stream_id
- followed_at — date
USER
- user_id — int — 기본 키 — NOT NULL
- username — varchar(100)
- email — varchar(100)
- nickname — varchar(100)
- created_at — date
USER (Untitled)
- user_id (Key) — VARCHAR(100) — 기본 키 — NOT NULL
- username (Field2) — VARCHAR(100)
- email (Field3) — VARCHAR(100)
- nickname (Field4) — VARCHAR(100)
- created_at (Field5) — INT