ATS (Applicant Tracking System) New
Tables (24)
api_meeting_config
- api_id — smallint(6) — Primary key — NOT NULL
- api_name — varchar(20) — NOT NULL
- client_id — varchar(50) — NOT NULL
- client_secret — varchar(50) — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
applicant
- applicant_id — varchar(36) — Primary key — NOT NULL
- project_id — smallint(6) — Foreign key → project_task.project_id — NOT NULL
- user_id — varchar(36) — NOT NULL — user_id applicant
- applicant_name — varchar(100) — NOT NULL
- email — varchar(100) — NOT NULL
- phone_no — varchar(20)
- intv_method — tinyint(1) — 0 = OFFLINE 1 = ONLINE
- has_detail — tinyint(1)
- has_schedule — tinyint(1)
- has_result — tinyint(1)
- has_final — tinyint(1) — 0 = reject 1 = new candidate
- status — varchar(50) — NOT NULL
- notes — text
- approval_by_hr — varchar(20) — NOT NULL
- approval_date_by_hr — datetime — NOT NULL
- expired_date — datetime
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
applicant_schedule
- applicant_schedule_id — smallint(6) — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → applicant.applicant_id — NOT NULL
- project_id — smallint(6) — Foreign key → applicant.project_id — NOT NULL
- schedule — datetime — NOT NULL
- active — tinyint(1) — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
available_schedule (avail_schedule)
- available_sched_id — smallint(6) — Primary key — NOT NULL
- project_id — smallint(6) — Foreign key → project_task.project_id — NOT NULL
- user_id — varchar(36) — Foreign key → project_task.user_id — NOT NULL — role manager
- avail_date — datetime — NOT NULL
- active — smallint(1) — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
certification
- certification_id — smallint(6) — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- competence — varchar(100) — NOT NULL
- competence_date — date
- location — varchar(100)
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
departement_mst
- dept_id — smallint — Primary key — NOT NULL
- dept_name — varchar(100)
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
education
- education_id — smallint — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- institution_name — varchar(50)
- grade — varchar(5)
- major — varchar(50)
- start_date — date
- graduate_date — date
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
family
- family_id — smallint — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- label — varchar(10) — NOT NULL
- name — varchar(30) — NOT NULL
- gender — char — NOT NULL
- birth_location — varchar(30) — NOT NULL
- birth_date — date — NOT NULL
- education — varchar(5) — NOT NULL
- occupation — varchar(30) — NOT NULL
- living_together — smallint(1) — NOT NULL
- have_family — smallint(1) — NOT NULL
- order — tinyint — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
file_upload
- file_id — smallint — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- file_category — varchar(50)
- file_name — varchar(100) — NOT NULL
- file_size — int(11) — NOT NULL
- folder — varchar(50) — NOT NULL
- file_path — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- deleted — tinyint(1) — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
holiday_mst
- date — Date — Primary key — NOT NULL
- remarks — varchar(150) — NOT NULL
- create_user — VARCHAR(20) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — VARCHAR(20) — NOT NULL
- update_date — DATETIME — NOT NULL
intvsched
- schedule_id — smallint(6) — Primary key — NOT NULL
- applicant_id — VARCHAR(36) — Primary key — NOT NULL — user_id applicant
- project_id — smallint(6) — Foreign key → project_task.project_id — NOT NULL
- manager_id — varchar(36) — NOT NULL
- interview_date — Date — NOT NULL
- interview_hour — Varchar(6) — NOT NULL
- intv_location — smallint(1) — NOT NULL — 0 = OFFLINE 1 = ONLINE
- location_id — smallint
- interview_url_address — varchar(255) — NOT NULL
- active — smallint(1) — NOT NULL
- create_user — VARCHAR(20) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — VARCHAR(20) — NOT NULL
- update_date — DATETIME — NOT NULL
language_skill
- skill_id — smallint(6) — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- language — varchar(20) — NOT NULL
- speaking — smallint(1) — NOT NULL — 0 = Pemula 1 = Menengah 2 = Lanjutan
- writing — smallint(1) — NOT NULL — 0 =Pemula 1 = Menengah 2 = Lanjutan
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
location_mst
- location_id — smallint(6) — Primary key — NOT NULL
- location_name — varchar(100) — NOT NULL
- office_address — text
- map_coordinate — text
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20)
- update_date — datetime — NOT NULL
medical_history
- medical_history_id — int — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- category — varchar(20) — NOT NULL
- disease — varchar(50)
- illness_year — date
- option — smallint(1) — 0 = Tidak 1 = Ya
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
menu_master
- menu_id — smallint — Primary key — NOT NULL
- parent_id — smallint
- level_id — smallint
- menu_name — varchar(50) — NOT NULL
- order_no — smallint
- role_id — varchar(20) — NOT NULL
- path — varchar(255)
- icon — varchar(255)
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
mst_logservices
- ID — varchar(255) — Primary key — NOT NULL
- IEXECTIME — bigint(20) — NOT NULL
- VAGENT — varchar(255) — NOT NULL
- VIPADDRESS — varchar(30) — NOT NULL
- VMETHOD — varchar(10) — NOT NULL
- VORIGIN — varchar(150)
- VURL — varchar(100) — NOT NULL
- VUSERNAME — varchar(100) — NOT NULL
- VCREA — varchar(36) — NOT NULL
- DCREA — datetime — NOT NULL
- VMODI — varchar(36)
- DMODI — datetime
- PARAM — text — NOT NULL
personal_address
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- address — text — NOT NULL
- province — varchar(30) — NOT NULL
- city — varchar(50) — NOT NULL
- kecamatan — varchar(100) — NOT NULL
- kelurahan — varchar(100) — NOT NULL
- rt — varchar(3) — NOT NULL
- rw — varchar(3) — NOT NULL
- zipcode — varchar(10) — NOT NULL
- home_phone — varchar(20)
- address2 — text
- province2 — varchar(30)
- city2 — varchar(50)
- kecamatan2 — varchar(100)
- kelurahan2 — varchar(100)
- rt2 — varchar(3)
- rw2 — varchar(3)
- zipcode2 — varchar(10)
- urgent_name — varchar(100) — NOT NULL
- urgent_relation — varchar(50) — NOT NULL
- urgent_cellphone — varchar(20) — NOT NULL
- urgent_email — varchar(100)
- urgent_address — text — NOT NULL
- urgent_city — varchar(50) — NOT NULL
- urgent_kecamatan — varchar(100) — NOT NULL
- urgent_kelurahan — varchar(100) — NOT NULL
- urgent_rt — varchar(3) — NOT NULL
- urgent_rw — varchar(3) — NOT NULL
- urgent_zipcode — varchar(10) — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
personal_data
- applicant_id — varchar(36) — Primary key — NOT NULL
- fullname — varchar(50) — NOT NULL
- nickname — varchar(30) — NOT NULL
- birth_location — varchar(30)
- birth_date — date — NOT NULL
- citizenship — varchar(20) — NOT NULL
- race — varchar(20)
- religion — varchar(15) — NOT NULL
- blood_type — varchar(2) — NOT NULL
- mother_name — varchar(50) — NOT NULL
- married_type — smallint(1) — NOT NULL
- number_of_child — smallint(1)
- email — varchar(100) — NOT NULL
- cellphone — varchar(20)
- nik — varchar(20) — NOT NULL
- npwp — varchar(20)
- jamsostek_no — varchar(20)
- bpjs_no — varchar(20)
- linkedin_url — varchar(100)
- facebook_url — varchar(100)
- instagram_url — varchar(100)
- twitter_url — varchar(100)
- profile_pic_filename — varchar(50)
- profile_pic_folder — varchar(20)
- profile_pic_url — varchar(255)
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
project_task
- project_id — smallint(6) — Primary key — NOT NULL
- dept_id — smallint — Foreign key → departement_mst.dept_id — NOT NULL
- location_id — smallint(6) — Foreign key → location_mst.location_id — NOT NULL
- user_id — varchar(36) — Foreign key → users.user_id — NOT NULL — role manager
- title — varchar(100) — NOT NULL
- description — text
- status — varchar(50) — NOT NULL
- deleted — smallint(1)
- create_user — varchar(20)
- create_date — datetime
- update_user — varchar(20)
- update_date — datetime
rolemst
- role_id — VARCHAR(20) — Primary key — NOT NULL
- role_name — VARCHAR(15) — NOT NULL
- create_task — smallint(1) — NOT NULL
- view_dashboard — smallint(1) — NOT NULL
- create_registration — smallint(1) — NOT NULL
- view_registration — smallint(1) — NOT NULL
- input_available_schedule — smallint(1) — NOT NULL
- choose_schedule — smallint(1) — NOT NULL
- view_schedule — smallint(1)
- user_result — smallint(1) — NOT NULL
- final_result — smallint(1) — NOT NULL
- view_final_result — smallint(1)
- create_user — VARCHAR(20) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — VARCHAR(20) — NOT NULL
- update_date — DATETIME — NOT NULL
salary_benefit
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- basic_salary — double
- fixed_allowance — double
- irregular_allowance — double
- overtime_allowance — double
- other_allowance — double
- total_income — double
- expected_salary — double
- expected_allowance — varchar(255)
- vacancy_source — varchar(50)
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
users
- user_id — varchar(36) — Primary key — NOT NULL
- role_id — VARCHAR(20) — Foreign key → rolemst.role_id — NOT NULL
- dept_id — smallint — Foreign key → departement_mst.dept_id — NOT NULL
- parent_id — varchar(36)
- username — varchar(20) — NOT NULL
- fullname — varchar(100)
- email — varchar(100) — NOT NULL
- phone_no — varchar(20) — NOT NULL
- passwd — varchar(50) — NOT NULL
- active — smallint(1) — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
work_ref
- work_ref_id — smallint(6) — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- name — varchar(50)
- relationship — varchar(50)
- phone_no — varchar(20)
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL
working_history
- work_hist_id — smallint — Primary key — NOT NULL
- applicant_id — varchar(36) — Foreign key → personal_data.applicant_id — NOT NULL
- company_name — varchar(100) — NOT NULL
- position — varchar(30) — NOT NULL
- join_date — date — NOT NULL
- leave_date — date — NOT NULL
- leaving_reason — text
- order — tinyint — NOT NULL
- create_user — varchar(20) — NOT NULL
- create_date — datetime — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — datetime — NOT NULL