Appearance
tracks
Access tracks — group products together to grant or revoke access in bulk. Each track may carry origin rules (purchase, import, manual assignment, etc.).
- ETL strategy:
merge - PK:
id
Columns
| Column | Type | Description |
|---|---|---|
id | BIGINT | PK. |
id_tenant | BIGINT | FK → tenants.id. |
id_origin | BIGINT | Parent track id when replicated. |
title | TEXT | Track name. |
reference | TEXT | Track engine identifier — origin of the access. |
created_at | TIMESTAMPTZ | |
deleted_at | TIMESTAMPTZ |
Relationships
- Parent:
tenants. - M:N with products: via
track_products. - M:N with tags: via
track_tags. - M:N with users: via
user_tracks(with history). - Children:
metrics.track_access_aggregates.