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