Personnel Certification
Overview
The PersonnelCertification entity represents specific certifications held by personnel within the organization. Each
certification includes a name and a description, which provides context on the purpose or requirements of the
certification.
Table Structure
The following table outlines the SQL columns for the personnel_certifications table, providing a brief description of
each, along with sample data where applicable.
| Column | Type | Description | Example |
|---|---|---|---|
id | String (ULID) | Unique identifier for the certification. | 01JAP8RJBN-8ZTPXSGY-J9GSDPE1 |
enabled | Boolean | If the entity is enabled or not. | true |
created_date | DateTime | Date the entity was created. | 2024-12-31T19:48:44Z |
created_by | String | Person who created the entity. | TamakiMES |
modified_date | DateTime | Date the entity was modified. Value is null upon creation, and gets initially populated upon the first edit. | 2024-12-31T19:48:44Z |
modified_by | String | Last person to modify the entity. Value is null upon creation, and gets initially populated upon the first edit. | TamakiMES |
notes | String | Notes about the entity. | This entity has these extra notes |
spare1 | String | The first spare column that can be used for additional context on the entity. | some extra context 1 |
spare2 | String | The second spare column that can be used for additional context on the entity. | some extra context 2 |
spare3 | String | The third spare column that can be used for additional context on the entity. | some extra context 3 |
name | String (Unique) | Name of the certification. Must be unique. | Forklift Operator |
description | String | Detailed description of the certification requirements or scope. | Certified to operate forklifts in the warehouse environment. |
Field Details
name
Provides a concise unique identifier for the certification, such as Forklift Operator or Safety Training.
This field must be unique within the table, ensuring each certification is distinct.
description
An optional field that offers additional details about the certification, such as requirements, training content, or context. This description can be up to 2048 characters long, providing ample space for details that may help clarify the certification’s relevance or scope within the organization.