-- The genre tags of the music files, read offline by the scanner. A track has a -- handful at most (the scanner keeps five), lower case. They are the user's own -- data: they come from the files and are never sent anywhere. CREATE TABLE track_genres ( track_id BIGINT NOT NULL REFERENCES tracks(id) ON DELETE CASCADE, genre TEXT NOT NULL, PRIMARY KEY (track_id, genre) );