Data
Tables (3)
ALBUM
- id — INT — Primary key — NOT NULL
- album_id (album_id2) — VARCHAR(255) — Foreign key → TRACK.album_id — NOT NULL
- album_id — VARCHAR(255) — NOT NULL
- album_images_url — VARCHAR(255) — NOT NULL
- album_images_height — INT — NOT NULL
- album_images_width — INT — NOT NULL
- album_name — VARCHAR(255) — NOT NULL
- album_restrictions_reason — VARCHAR(255) — NOT NULL
- album_uri — VARCHAR(255) — NOT NULL
- album_genres — VARCHAR(255) — NOT NULL
- album_label — VARCHAR(255) — NOT NULL
- album_popularity — INT — NOT NULL
- album_group — VARCHAR(255) — NOT NULL
ARTIST
- id — INT — Primary key — NOT NULL
- artist_id — VARCHAR(255) — Foreign key → TRACK.artist_id — NOT NULL
- artists_external_urls_spotify — VARCHAR(255)
- artists_followers_href — VARCHAR(255)
- artists_genres — VARCHAR(255)
- artists_href — VARCHAR(255)
- artists_popularity — INT
- artists_type — VARCHAR(255)
TRACK
- id — INT — Primary key — NOT NULL
- album_id — VARCHAR(255) — Primary key — NOT NULL
- artist_id — VARCHAR(255) — Primary key — NOT NULL
- track_name — VARCHAR(255) — NOT NULL
- tracks_total — INT — NOT NULL
- popularity — FLOAT