app.person_emergency_contacts
TableRow level security on
People to call when something happens to the person on site (Section 4.5.6 item 10, Section 4.3 item 13), in the owner's order, at most five live. Owned and read only by the person; shared with an engagement under the Emergency Contacts category.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| person_id | uuid | No | Owner.References app.people.id |
| full_name | text | No | Contact's name as the person writes it. Confidential. |
| relationship | text | Yes | How the contact relates to the person, for example Partner or Sister. |
| phone_e164 | text | No | Contact's phone in E.164, for example +13055550142 (Section 15). Shown in national or international format. Confidential. |
| alternate_phone_e164 | text | Yes | A second phone in E.164. Confidential. |
| text | Yes | Contact's email address. Confidential. | |
| sort_order | smallint | No | Order to call in, lowest first. |
| 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 |