prote
Tables (6)
Untitled (songs)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (title) — NOT NULL
- Field (artist) — NOT NULL
- Field (album_image) — NOT NULL
- Field (category) — NOT NULL
- Field (like_count) — NOT NULL
Untitled (play_histories)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
- Key (song_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field (played_at) — NOT NULL
Untitled (likes)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
- Key (song_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
Untitled (user_emotions)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
- Field (emotion) — NOT NULL
- Field (search_count) — NOT NULL
Untitled (prefer_songs)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (user_id) — NOT NULL — Foreign key → users.Key — NOT NULL
- Key (song_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
users
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (username) — NOT NULL
- Field (password) — NOT NULL
- Field (nickname) — NOT NULL
- Field (profile_image) — NOT NULL
- Field (email) — NOT NULL
- Field (role) — NOT NULL