app.notifications
TablaParticionada por mesSeguridad a nivel de fila activa
Inbox notifications (Section 7.3), one per recipient, in monthly partitions. Readable only by the recipient while they belong to the org (invariant 3). Copy is rendered from the i18n catalogs by kind with message_args.
Clave primaria: id, created_at
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Notification id, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.Hace referencia a app.organizations.id |
| recipient_person_id | uuid | No | Person the notification is for.Hace referencia a app.people.id |
| kind | text | No | Notification kind from app.notification_templates. |
| actor_person_id | uuid | Sí | Person whose action caused it, when one did.Hace referencia a app.people.id |
| subject_table | text | Sí | Table of the record it is about. |
| subject_id | uuid | Sí | Id of the record it is about. |
| project_id | uuid | Sí | Project of the record, when it belongs to one.Hace referencia a app.projects.id |
| message_args | jsonb | No | ICU message arguments for the kind's catalog messages (display values such as a record title). Never relational data. |
| read_at | timestamp with time zone | Sí | When the recipient read it. |
| archived_at | timestamp with time zone | Sí | When the recipient archived it. |
| 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 |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |