app.representations
TableRow level security on
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.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Representing account: the artist agency or management company.References app.organizations.id |
| artist_person_id | uuid | No | Represented artist.References app.people.id |
| representative_person_id | uuid | Yes | Named agent or manager in the account; NULL when every Account Owner and Admin acts for the artist.References app.people.id |
| expires_on | date | No | Last day the representation holds. |
| accepted_at | timestamp with time zone | Yes | When the artist accepted. Without acceptance the representation grants nothing. |
| revoked_at | timestamp with time zone | Yes | When the artist or the account revoked it. |
| deleted_at | timestamp with time zone | Yes | 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 | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |