Worker Assignments
Worker Assignments
| Field | Type | Description |
|---|---|---|
id 🔑 | INTEGER | The unique identifier for the worker assignment record. |
agency_id 🔗 | INTEGER | The ID of the agency this worker assignment belongs to. |
agency_worker_id 🔗 | INTEGER | The ID of the agency worker being assigned. |
application_id 🔗 | INTEGER | The ID of the application this worker is assigned to. |
license_id 🔗 | INTEGER | The ID of the license this worker assignment is associated with. |
role | STRING | The role or responsibility of the worker in this assignment. |
created_at | TIMESTAMP | The timestamp when the worker assignment was created. |
assigned_at | TIMESTAMP | The timestamp when the worker was assigned to this role. |
unassigned_at | TIMESTAMP | The timestamp when the worker was unassigned from this role, if applicable. |
Key Information
Primary Keys
id- The unique identifier for the worker assignment record.
Foreign Keys
agency_id- The ID of the agency this worker assignment belongs to.agency_worker_id- The ID of the agency worker being assigned.application_id- The ID of the application this worker is assigned to.license_id- The ID of the license this worker assignment is associated with.
Updated 6 days ago