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