DB
Tables (4)
Music (Untitled2)
- musicId (Key) — Primary key — NOT NULL
- code (Key22) — string — Foreign key → Playlist.code — NOT NULL
- Key (Key2) — Foreign key → Playlist.playlistId — NOT NULL
- userId (Key3) — string — Foreign key → Playlist.userId — NOT NULL
- code (Key222) — string — Foreign key → Playlist.code — NOT NULL
- title (Field) — string
- artist (Field2) — string
- link (Field3) — string
- agree (Field4) — number
- reject (Field5) — number
Playlist (Untitled3)
- playlistId (Key) — string — Primary key — NOT NULL
- code (Key2) — string — Foreign key → Room.code — NOT NULL
- userId (Key3) — string — Foreign key → User.userId — NOT NULL
- code (Key22) — string — Foreign key → User.code — NOT NULL
- musics (Field) — [Music]
Room (Untitled4)
- code (Key) — string — Primary key — NOT NULL
- users (Field) — [Users]
- currentMusicId (Field2) — Music
- remainPlaylist (Field3) — Playlist
- acceptPlaylist (Field4) — Playlist
- rejectPlaylist (Field5) — Playlist
User (Untitled)
- userId (Key) — string — Primary key — NOT NULL
- code (Key2) — string — Foreign key → Room.code — NOT NULL
- email (Field6) — string
- nickname (Field2) — string
- password (Field) — string
- isMember (Field4) — boolean
- playlist (Field5) — Playlist
- acceptPlaylist (Field3) — Playlist
- rejectPlaylist (Field7) — Playlist