vibeList

Tables (11)

AudioFeature (Untitled9)

  • id (Key) — Long — Primary key — NOT NULL
  • track_id (Key2) — Long — Foreign key → Track.id — NOT NULL
  • danceability (Field) — double
  • energy (Field2) — double
  • key (Field3) — int
  • loudness (Field4) — double
  • mood (Field5) — int
  • speechiness (Field6) — double
  • acousticness (Field7) — double
  • instrumentalness (Field8) — double
  • liveness (Field9) — double
  • valence (Field10) — double
  • tempo (Field11) — double
  • durationMs (Field12) — int
  • timeSignature (Field13) — int
  • spotifyId (Field14) — String
  • genres (Field15) — String

Auth (Untitled6)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Board (Untitled4)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

Comment (Untitled5)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Playlist (Untitled2)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • totalSeconds (Field) — int
  • Field2
  • Field3
  • Field4
  • Field5

PlaylistTrack (Untitled8)

  • id (Key) — Long — Primary key — NOT NULL
  • playlist_id (Key2) — Long — Foreign key → Playlist.id — NOT NULL
  • track_id (Key3) — Long — Foreign key → Track.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Track (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • artist (Field2) — String
  • album (Field3) — String
  • popularity (Field4) — int

User (Untitled3)

  • id (Key) — Long — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

UserProfile (Untitled11)

  • id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

Youtube (Untitled10)

  • id (Key) — Long — Primary key — NOT NULL
  • track_id (Key2) — Long — Foreign key → Track.id — NOT NULL
  • url (Field) — String
  • durationSeconds (Field2) — int

like (Untitled7)

  • id (Key) — Long — Primary key — NOT NULL
  • board_id (Key2) — Long — Foreign key → Board.id — NOT NULL
  • user_id (Key3) — Long — Foreign key → User.id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5