db
Tables (13)
CHATROOM
- chatroom_id — INT — Primary key — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
CHATROOM_MEMBER
- member_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- chatroom_id — INT — Foreign key → CHATROOM.chatroom_id — NOT NULL
- last_read_at — TIMESTAMP
FRIENDSHIP
- friendship_id — INT — Primary key — NOT NULL
- requester_id — INT — Foreign key → USER.user_id — NOT NULL
- receiver_id — INT — Foreign key → USER.user_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- requested_at — TIMESTAMP — NOT NULL
GAME
- game_id — INT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- publisher — VARCHAR(100)
GAME_GENRE
- game_id — INT — Foreign key → GAME.game_id — NOT NULL
- genre_id — INT — Foreign key → GENRE.genre_id — NOT NULL
GENRE
- genre_id — INT — Primary key — NOT NULL
- genre_name — VARCHAR(50) — NOT NULL
MESSAGE
- message_id — INT — Primary key — NOT NULL
- chatroom_id — INT — Foreign key → CHATROOM.chatroom_id — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- content — TEXT — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
PLAY_HISTORY
- history_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- game_id — INT — Foreign key → GAME.game_id — NOT NULL
- start_time — TIMESTAMP — NOT NULL
- end_time — TIMESTAMP
- play_time — INT
PURCHASE
- purchase_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- game_id — INT — Foreign key → GAME.game_id — NOT NULL
- purchase_date — DATE — NOT NULL
- purchase_price — INT — NOT NULL
REVIEW
- review_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- game_id — INT — Foreign key → GAME.game_id — NOT NULL
- content — TEXT
- rating — INT — NOT NULL
STREAM
- stream_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- channel_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
STREAM_FOLLOW
- follow_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- stream_id — INT — Foreign key → STREAM.stream_id — NOT NULL
- followed_at — TIMESTAMP — NOT NULL
USER
- user_id — INT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL