app.representations
TablaSeguridad a nivel de fila activa
An agency or management account acting for an artist (Section 4.4.1, Section 4.8.1 Representation). It takes effect once the artist accepts, within its scopes and until it expires or is revoked.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Representing account: the artist agency or management company.Hace referencia a app.organizations.id |
| artist_person_id | uuid | No | Represented artist.Hace referencia a app.people.id |
| representative_person_id | uuid | Sí | Named agent or manager in the account; NULL when every Account Owner and Admin acts for the artist.Hace referencia a app.people.id |
| expires_on | date | No | Last day the representation holds. |
| accepted_at | timestamp with time zone | Sí | When the artist accepted. Without acceptance the representation grants nothing. |
| revoked_at | timestamp with time zone | Sí | When the artist or the account revoked it. |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |