app.role_library
TablaSeguridad a nivel de fila activa
The org's job descriptions per canon role: its editable copy of the Roles Library (xpms.role, decision D12). Role codes stay canon; the org edits the title and the description. One row per role, kept when removed, so adopting again never brings it back.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.Hace referencia a app.organizations.id |
| role_code | text | No | Canon role code (xpms.role) the row describes.Hace referencia a xpms.role.role_code |
| job_title | text | No | The org's job title for the role. |
| job_summary | text | Sí | Summary of the job. |
| key_responsibilities | text | Sí | Key responsibilities. |
| qualifications | text | Sí | Qualifications. |
| physical_requirements | text | Sí | Physical requirements. |
| required_certifications | text | Sí | Certifications the role requires. |
| default_clearance_tier | text | Sí | Clearance tier the role usually carries. |
| default_radio_channel | text | Sí | Radio channel the role usually monitors. |
| deleted_at | timestamp with time zone | Sí | 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 | 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 |