| id |
bigint(20)
|
|
|
|
| document_uid |
char(36)
|
utf8mb4_general_ci
|
|
|
| employee_profile_id |
bigint(20)
|
|
|
 Menjelajahi nilai luar
|
| document_type_id |
int(10)
|
|
|
|
| document_number |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| title |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| issue_date |
date
|
|
|
|
| effective_start |
date
|
|
|
|
| effective_end |
date
|
|
|
|
| signer_name |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| signer_position |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| issuing_unit |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| current_version |
int(10)
|
|
|
|
| previous_document_id |
bigint(20)
|
|
|
|
| replacement_document_id |
bigint(20)
|
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| created_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| verified_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| verified_at |
datetime
|
|
|
|
| approved_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| approved_at |
datetime
|
|
|
|
| revoked_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| revoked_at |
datetime
|
|
|
|
| revoke_reason |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| updated_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| updated_at |
datetime
|
|
|
|
