app.blocks
TablaSeguridad a nivel de fila activa
People and organizations a person has blocked (Section 4.5.6 Profile Privacy). A block hides the blocker's profile from the blocked person and from every member of a blocked organization, and hides the blocked profile from the blocker. A person block also hides the blocked person's feed posts (except those that require acknowledgment), comments on posts, shout-outs and chat messages, and the notifications about them, from the blocker (ADR 0033 decision 57, 1631). It never ends a membership or an engagement. Read and written only by the blocker.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| person_id | uuid | No | Person who blocked, from the session.Hace referencia a app.people.id |
| blocked_urn | text | No | URN of the blocked profile: urn:xpms:person:{id} or urn:xpms:organization:{id}. |
| blocked_person_id | uuid | Sí | Blocked person, resolved from the URN; NULL when an organization is blocked.Hace referencia a app.people.id |
| blocked_organization_id | uuid | Sí | Blocked organization, resolved from the URN; NULL when a person is blocked.Hace referencia a app.organizations.id |
| created_at | timestamp with time zone | No | When the block was made. |
| created_by | uuid | Sí | Person who made it.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When it last changed. |
| updated_by | uuid | Sí | Person who last changed it.Hace referencia a app.people.id |
| deleted_at | timestamp with time zone | Sí | When the person unblocked; the block no longer applies. |