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