-- sessions -> genre mapping
CREATE TABLE genres_music_sessions (
    id VARCHAR(64) PRIMARY KEY DEFAULT uuid_generate_v4(),
    genre_id VARCHAR(64) REFERENCES genres(id) ON DELETE CASCADE,
    music_session_id VARCHAR(64) REFERENCES music_sessions(id) ON DELETE CASCADE
);

INSERT INTO genres (description) VALUES 
    ('African'),
    ('Ambient'),
    ('Asian'),
    ('Blues'),
    ('Classical'),
    ('Country'),
    ('Electronic'),
    ('Folk'),
    ('Hip Hop'),
    ('Jazz'),
    ('Latin'),
    ('Metal'),
    ('Pop'),
    ('R&B'),
    ('Reggae'),
    ('Religious'),
    ('Rock'),
    ('Ska'),
    ('Other');
