| profile_id | int(11) |
|
|
|
| profile_group_id | char(20) |
|
|
|
| profile_subgroup_id | varchar(50) |
|
|
|
| profile_operator_id | int(11) |
|
|
|
| profile_fullname | varchar(100) |
|
|
|
| profile_employee_id | varchar(25) |
|
|
|
| profile_birth_place | varchar(50) |
|
|
|
| profile_dob | date |
|
|
|
| profile_gender | int(11) |
|
|
|
| profile_religion | int(11) |
|
|
|
| profile_address | varchar(300) |
|
|
|
| profile_city_code | char(5) |
|
|
|
| profile_city_name | varchar(30) |
|
|
|
| profile_district_code | char(7) |
|
|
|
| profile_village_code | char(10) |
|
|
|
| profile_postcode | varchar(5) |
|
|
|
| profile_living_address | varchar(300) |
|
|
|
| profile_living_city_code | char(5) |
|
|
|
| profile_living_province_code | char(2) |
|
|
|
| profile_living_district_code | char(7) |
|
|
|
| profile_living_village_code | char(10) |
|
|
|
| profile_living_postcode | varchar(5) |
|
|
|
| profile_province_code | char(2) |
|
|
|
| profile_province_name | varchar(30) |
|
|
|
| profile_handphone1 | char(20) |
|
|
|
| profile_handphone2 | char(20) |
|
|
|
| profile_email | varchar(100) |
|
|
|
| profile_gmail | varchar(100) |
|
|
|
| profile_npwp | varchar(25) |
|
|
|
| profile_fullname_npwp | varchar(50) |
|
|
|
| profile_bank | varchar(50) |
|
|
|
| profile_bank_account | varchar(25) |
|
|
|
| profile_bank_account_holder | varchar(50) |
|
|
|
| profile_competency_id | varchar(8) |
|
|
|
| profile_nationality_id | varchar(20) |
|
|
|
| profile_str_id | varchar(50) |
|
|
|
| profile_str_expired | date |
|
|
|
| profile_sip_id | varchar(50) |
|
|
|
| profile_sip_expired | date |
|
|
|
| profile_spk_id | varchar(50) |
|
|
|
| profile_spk_expired | date |
|
|
|
| profile_rkk_id | varchar(50) |
|
|
|
| profile_rkk_expired | date |
|
|
|
| profile_work_type | char(1) |
|
|
|
| profile_work_status | int(11) |
|
|
|
| profile_work_position | int(11) |
|
|
|
| profile_work_date | date |
|
|
|
| profile_workshop_partnership_id | int(11) |
|
|
|
| profile_department_id | varchar(10) |
|
|
|
| profile_signs | char(36) |
|
|
|
| profile_specialize_id | char(1) |
|
|
|
| profile_major | char(1) |
|
|
|
| profile_insert_by | varchar(5) |
|
|
|
| profile_insert_date | datetime |
|
|
|
| profile_update_by | varchar(5) |
|
|
|
| profile_update_date | datetime |
|
|
|
| profile_delete_date | datetime |
|
|
|
| profile_delete_by | int(11) |
|
|
|
| profile_institution_code | varchar(11) |
|
|
|
| profile_institution_name | varchar(200) |
|
|
|
| profile_institution_ownership_id | char(2) |
|
|
|
| profile_institution_province_code | varchar(50) |
|
|
|
| profile_institution_city_code | varchar(10) |
|
|
|
| profile_institution_group_id | varchar(10) |
|
|
|
| profile_regional_city_code | varchar(6) |
|
|
|
| profile_batch | char(4) |
|
|
|
| profile_bpjs_number | varchar(25) |
|
|
|
| profile_toefl_score | varchar(5) |
|
|
|
| profile_photo | varchar(250) |
|
|
|
| profile_grade_code | varchar(2) |
|
|
|
| profile_password | varchar(32) |
|
|
|
| profile_last_change_password | datetime |
|
|
|
| profile_online_status | int(11) |
|
|
0
|
| profile_disable | int(11) |
|
|
0
|
| profile_disable_reason | int(11) |
|
|
|
| profile_note | varchar(250) |
|
|
|
| profile_last_login | datetime |
|
|
|
| profile_partnership_code | varchar(32) |
|
|
|
| profile_partnership_ed | date |
|
|
|
| profile_record_status | char(1) |
|
|
A
|
