test3
Tables (13)
STREAM
- Key (stream_id) — int — Primary key — NOT NULL
- Field (channel_name) — varchar
- Field (category) — varchar
- user_id — int — Foreign key → USER.user_id — NOT NULL
USER
- user_id — int — Primary key — NOT NULL
- user_name — varchar
- email — varchar
- nickname — varchar
- created_at
Untitled (GAME)
- Key (game_id) — int — Primary key — NOT NULL
- Field (title) — varchar
- Field (price) — int
- Field (publisher) — varchar
Untitled (GENRE)
- Key (genre_id) — int — Primary key — NOT NULL
- Field (genre_name) — varchar
Untitled (CHATROOM)
- Key (chatroom_id) — int — Primary key — NOT NULL
- Field (room_name) — varchar
Untitled (REVIEW)
- Key (review_id) — int — Primary key — NOT NULL
- Field (content) — varchar
- Field (rating) — varchar
- user_id — int — Foreign key → USER.user_id — NOT NULL
- Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (MESSAGE)
- Key (message_id) — int — Primary key — NOT NULL
- Key (chatroom_id) — int — Foreign key → Untitled.Key — NOT NULL
- user_id — int — Foreign key → USER.user_id — NOT NULL
- Field (content) — varchar
- Field (sent_at) — varchar
Untitled (PURCHASE)
- Key (purchase_id) — int — Primary key — NOT NULL
- Field (purchase_date) — varchar
- Field (purchase_price) — int
- user_id — int — Foreign key → USER.user_id — NOT NULL
- Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (PLAY_HISTORY)
- Key (history_id) — int — Primary key — NOT NULL
- Field (start_time) — char
- Field (end_time) — char
- Field (play_time) — int
- user_id — int — Foreign key → USER.user_id — NOT NULL
- Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (GAME_GENRE)
- Key (game_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (genre_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (CHATROOM_MEMBER)
- Key (member_id) — int — Primary key — NOT NULL
- Field (last_read_at) — char
- user_id — int — Foreign key → USER.user_id — NOT NULL
- Key (chatroom_id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (STREAM_FOLLOW)
- Key (follow_id) — int — Primary key — NOT NULL
- Field (followed_at) — char
- user_id — int — Foreign key → USER.user_id — NOT NULL
- Key (stream_id) — int — Foreign key → STREAM.Key — NOT NULL
Untitled (FRIENDSHIP)
- Key (friendship_id) — int — Primary key — NOT NULL
- Field (status) — char
- Field (requested_at) — char