music
Tables (8)
listening
- id (Key) — Primary key — NOT NULL
- session_id (Key4) — Foreign key → session.id — NOT NULL
- user_id (Key3) — Foreign key → user.id — NOT NULL
- track_id (Key2) — Foreign key → track.id — NOT NULL
playlist
- id (Key) — Primary key — NOT NULL
- Field
playlist_track
- id (Key) — Primary key — NOT NULL
- playlist_id (Key3) — Foreign key → playlist.id — NOT NULL
- track_id (Key2) — Foreign key → track.id — NOT NULL
- Field
session
- id (Key) — Primary key — NOT NULL
- Field
session_user
- id (Key) — Primary key — NOT NULL
- session_id (Key2) — Foreign key → session.id — NOT NULL
- user_id (Key3) — Foreign key → user.id — NOT NULL
- Field
track
- id (Key) — Primary key — NOT NULL
- Field
user
- id (Key) — Primary key — NOT NULL
- Field
user_playlist
- id (Key) — Primary key — NOT NULL
- user_id (Key3) — Foreign key → user.id — NOT NULL
- playlist_id (Key2) — Foreign key → playlist.id — NOT NULL
- Field