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