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