ATS New Design _ERD
Tables (18)
add_info_files
- files_id — smallint(6) — Primary key — NOT NULL
- app_id — smallint(6) — Foreign key → basicinfo.app_id — NOT NULL
- user_id (user_id2) — VARCHAR(36) — Foreign key → basicinfo.user_id — NOT NULL
- project_id — smallint(6) — Foreign key → basicinfo.project_id — NOT NULL
- file_name — varchar(100) — NOT NULL
- file_size — int(11)
- folder — varchar(100)
- file_path — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- deleted — tinyint(1)
- create_user — varchar(20) — NOT NULL
- create_date — timestamp — NOT NULL
- update_user — varchar(20) — NOT NULL
- update_date — timestamp — NOT NULL
api_meeting_config
- api_id — smallint(6) — Primary key — NOT NULL
- dept_cd — varchar(10) — Foreign key → departement_mst.dept_cd — 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 — smallint(6) — Primary key — NOT NULL
- project_id — smallint(6) — Foreign key → project_title.project_id — NOT NULL
- category_cd — varchar(20) — Foreign key → project_title.category_cd — NOT NULL
- dept_cd — varchar(10) — Foreign key → project_title.dept_cd — NOT NULL
- user_id — varchar(36)
- applicant_name — varchar(100) — NOT NULL
- email — varchar(100) — NOT NULL
- status — 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
assesst_criteria
- criteria_id — smallint(6) — Primary key — NOT NULL
- criteria_title — varchar(100) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- active — smallint(1)
- create_user — VARCHAR(20) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — VARCHAR(20) — NOT NULL
- update_date — DATETIME — NOT NULL
basicinfo
- app_id — smallint(6) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Primary key — NOT NULL
- project_id — smallint(6) — Primary key — NOT NULL
- full_name — varchar(50) — NOT NULL
- birthdate — Date — NOT NULL
- address — text — NOT NULL
- phone_number — varchar(15) — NOT NULL
- 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_cd — varchar(10) — 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
dept_category
- category_cd — varchar(20) — Primary key — NOT NULL
- dept_cd — varchar(10) — Foreign key → departement_mst.dept_cd — NOT NULL
- category_Name — 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
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
interviewer
- interviewer_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Primary key — NOT NULL — user id interviewer
- interviewer_name — 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
intvscore
- interview_score_id — smallint(6) — Primary key — NOT NULL
- project_id — smallint(6) — Foreign key → project_title.project_id — NOT NULL
- category_cd — varchar(20) — Foreign key → project_title.category_cd — NOT NULL
- dept_cd — varchar(10) — Foreign key → project_title.dept_cd — NOT NULL
- interviewer_id — VARCHAR(36) — Foreign key → interviewer.interviewer_id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → interviewer.user_id — NOT NULL — user id interviewer
- notes — TEXT — NOT NULL
- create_user — VARCHAR(20) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — VARCHAR(20) — NOT NULL
- update_date — DATETIME — NOT NULL
intvscoredtl
- interview_score_id — smallint(6) — Primary key — NOT NULL
- interviewer_id2 — VARCHAR(36) — Primary key — NOT NULL
- criteria_id — smallint(6) — NOT NULL
- criteria_score — smallint(6) — NOT NULL
- 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
office
- office_id — smallint(6) — Primary key — NOT NULL
- location — varchar(30)
- address — text — NOT NULL
project_title
- project_id — smallint(6) — Primary key — NOT NULL
- category_cd — varchar(20) — Foreign key → dept_category.category_cd — NOT NULL
- dept_cd — varchar(10) — Foreign key → dept_category.dept_cd — NOT NULL
- title — varchar(100) — NOT NULL
- description — text
- status — varchar(50) — NOT NULL
- active_days — smallint(6) — NOT NULL
- deleted — smallint(1)
- create_user — varchar(20)
- create_date — datetime
- update_user — varchar(20)
- update_date — datetime
rolemst
- role_id — VARCHAR(36) — Primary key — NOT NULL
- role_name — VARCHAR(15) — NOT NULL
- create_task — smallint(1) — NOT NULL
- view_dashboard — smallint(1) — NOT NULL
- create_basic_info — smallint(1) — NOT NULL
- view_basic_info — smallint(1) — NOT NULL
- choose_interviewer — smallint(1) — NOT NULL
- choose_schedule — smallint(1) — NOT NULL
- view_schedule — smallint(1)
- submit_score — smallint(1) — NOT NULL
- create_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
- user_id — varchar(36) — Primary key — 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)
- 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(36) — Foreign key → rolemst.role_id — NOT NULL
- category_cd — varchar(20) — Foreign key → dept_category.category_cd — NOT NULL
- dept_cd — varchar(10) — Foreign key → dept_category.dept_cd — NOT NULL
- username — varchar(20) — NOT NULL
- fullname — varchar(100)
- email — varchar(100) — NOT NULL
- phone_no — varchar(20)
- 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