track_tags

M:N junction between tracks and tags. Lets you label a track.

• ETL strategy: merge
• PK: id

Columns

Column	Type	Description
id	BIGINT	PK.
id_tag	BIGINT	FK → tags.id.
id_track	BIGINT	FK → tracks.id.
created_at	TIMESTAMPTZ
deleted_at	TIMESTAMPTZ

This is the only table without a direct id_tenant. To filter by tenant, join with tracks:

SELECT tt.*
FROM lms.track_tags tt
JOIN lms.tracks t ON t.id = tt.id_track
WHERE t.id_tenant = 100;