Appearance
tags
Labels applicable to users and tracks for segmentation.
- ETL strategy:
merge - PK:
id
Columns
| Column | Type | Description |
|---|---|---|
id | BIGINT | PK. |
id_tenant | BIGINT | FK → tenants.id. |
id_origin | BIGINT | Parent tag id when replicated across tenants. |
title | TEXT | Tag label. |
created_at | TIMESTAMPTZ | |
deleted_at | TIMESTAMPTZ |
Relationships
- Parent:
tenants. - M:N with users: via
user_tags. - M:N with tracks: via
track_tags.