app.blocks
TableRow level security on
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.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| person_id | uuid | No | Person who blocked, from the session.References 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 | Yes | Blocked person, resolved from the URN; NULL when an organization is blocked.References app.people.id |
| blocked_organization_id | uuid | Yes | Blocked organization, resolved from the URN; NULL when a person is blocked.References app.organizations.id |
| created_at | timestamp with time zone | No | When the block was made. |
| created_by | uuid | Yes | Person who made it.References app.people.id |
| updated_at | timestamp with time zone | No | When it last changed. |
| updated_by | uuid | Yes | Person who last changed it.References app.people.id |
| deleted_at | timestamp with time zone | Yes | When the person unblocked; the block no longer applies. |