| id |
bigint(20)
|
|
|
|
| legacy_employee_id |
bigint(20)
|
|
|
|
| employee_code |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| nik |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| username |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| full_name |
varchar(180)
|
utf8mb4_general_ci
|
|
|
| title_prefix |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| title_suffix |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| birth_place |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| birth_date |
date
|
|
|
|
| gender |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_name |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| emergency_contact_phone |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| unit_master_id |
int(10)
|
|
|
 Menjelajahi nilai luar
|
| position_master_id |
int(10)
|
|
|
Menjelajahi nilai luar
|
| profession_master_id |
int(10)
|
|
|
Menjelajahi nilai luar
|
| supervisor_profile_id |
bigint(20)
|
|
|
|
| work_location |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| employment_status |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| hire_date |
date
|
|
|
|
| permanent_date |
date
|
|
|
|
| end_date |
date
|
|
|
|
| education |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| bank_account |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| bank_account_name |
varchar(160)
|
utf8mb4_general_ci
|
|
|
| tax_number |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| medical_record_number |
varchar(40)
|
utf8mb4_general_ci
|
|
|
| is_active |
tinyint(1)
|
|
|
|
| status_reason |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| photo_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| source |
varchar(60)
|
utf8mb4_general_ci
|
|
|
| created_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_by |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| updated_at |
datetime
|
|
|
|
