| id | bigint(20) unsigned |
|
|
|
| pegawai_id | int(11) |
|
|
|
| nama_lengkap | varchar(255) |
|
|
|
| nik | varchar(50) |
|
|
|
| jenis_kelamin | enum | -- |
|
|
| tempat_lahir | varchar(100) |
|
|
|
| tanggal_lahir | date |
|
|
|
| alamat | text |
|
|
|
| kota | varchar(100) |
|
|
|
| no_telepon | varchar(20) |
|
|
|
| email | varchar(255) |
|
|
|
| no_ktp | varchar(20) |
|
|
|
| npwp | varchar(20) |
|
|
|
| no_rekening | varchar(50) |
|
|
|
| pendidikan | varchar(100) |
|
|
|
| jabatan | varchar(100) |
|
|
|
| departemen | varchar(100) |
|
|
|
| bidang | varchar(100) |
|
|
|
| mulai_kerja | date |
|
|
|
| status_kerja | varchar(50) |
|
|
|
| informasi_tambahan | text |
|
|
|
| foto_profile | varchar(255) |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
