ATS - ERD
Tables (15)
Master Holiday
- 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
add_info_files
- files_id — smallint(6) — Primary key — NOT NULL
- user_id — varchar(36) — 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
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) — Foreign key → users.user_id — NOT NULL
- project_id — smallint(6) — Foreign key → prjlist.project_id — NOT NULL
- full_name — varchar(50) — NOT NULL
- birthdate — Date — NOT NULL
- birth_location — varchar(50) — NOT NULL
- email — varchar(50) — NOT NULL
- phone_number — varchar(15) — NOT NULL
- attach_filename — VARCHAR(100) — NOT NULL
- attach_filepath — VARCHAR(100) — 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) — Foreign key → users.user_id — 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
intvresult
- project_id — smallint(6) — Foreign key → prjlist.project_id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- status_result — varchar(20) — 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
- project_id — smallint(6) — Foreign key → prjlist.project_id — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL — user_id applicant
- interview_date — Date — NOT NULL
- interview_hour — Varchar(6) — NOT NULL
- interview_url — varchar(200) — 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
intvscheddtl
- schedule_detail_id — smallint(6) — Primary key — NOT NULL
- interviewer_id — VARCHAR(36) — Foreign key → interviewer.interviewer_id — NOT NULL
- schedule_id — smallint(6) — Foreign key → intvsched.schedule_id — 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
intvscore
- interview_score_id — smallint(6) — Primary key — NOT NULL
- project_id (project_id2) — smallint(6) — Foreign key → prjlist.project_id — NOT NULL
- interviewer_id (interviewer_id2) — VARCHAR(36) — Foreign key → interviewer.interviewer_id — NOT NULL
- user_id (user_id2) — VARCHAR(36) — Foreign key → prjlist.user_id — NOT NULL
- 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) — Foreign key → intvscore.interview_score_id — NOT NULL
- interviewer_id (interviewer_id2) — VARCHAR(36) — Foreign key → intvscore.interviewer_id — 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
notif_setting
- notif_id — smallint(1) — Primary key — NOT NULL
prjlist
- project_id — smallint(6) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- description — Text — NOT NULL
- app_name — VARCHAR(30) — NOT NULL
- app_email — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — 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
- has_detail_info — smallint(1)
- has_schedule — smallint(1)
- has_result — smallint(1)
- has_final — smallint(1)
- Field
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
- create_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
users
- user_id — VARCHAR(36) — Primary key — NOT NULL
- role_id — VARCHAR(36) — Foreign key → rolemst.role_id — NOT NULL
- user_name — VARCHAR(20) — NOT NULL
- passwd — VARCHAR(50) — NOT NULL
- email — varchar(30) — NOT NULL
- create_user — VARCHAR(20) — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — VARCHAR(20) — NOT NULL
- update_date — DATETIME — NOT NULL
- active — smallint(1) — NOT NULL