name
Tables (36)
ai_perfo_summary
- ai_summary_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- perfo_type — VARCHAR(30) — NOT NULL
- ai_summary — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
announcement
- ann_id — BIGINT — NOT NULL
- dept_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — LONGTEXT — NOT NULL
- create_datetime — DATETIME — NOT NULL — JPA Auditing
- update_datetime — DATETIME — JPA Auditing
annual
- annual_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- approve_sbj_id — BIGINT — NOT NULL
- enroll_annual — DATETIME — NOT NULL
- annual_start — DATETIME — NOT NULL
- annual_end — DATETIME — NOT NULL
- annual_status — VARCHAR(30) — NOT NULL — 대기 승인 반려
- annual_reject_reason — VARCHAR(255)
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL — ACTIVE,DELETED
- is_annual_retroactive — TINYINT — NOT NULL — 소급 되면 1
- annual_retroactive_reason — VARCHAR(255)
- annual_retroactive_status — VARCHAR(30)
appoint
- appointId — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- type — VARCHAR(30) — NOT NULL — 승진, 부서이동
- before — VARCHAR(30) — NOT NULL
- after — VARCHAR(30) — NOT NULL
- appoint_datetime — DATETIME — NOT NULL
approve_line
- approve_line_id — BIGINT — NOT NULL
- doc_id — BIGINT — NOT NULL — NULL 이면 나의결재선템플릿 사용한다는 뜻
- create_user_id — VARCHAR(30) — NOT NULL
- name — VARCHAR(30) — 나의결재선이름 or NULL(문서 결재선인 경우)
- approve_line_order — INT — NOT NULL — 결재선 안에서 처리되는 순서
- pll_group_id — BIGINT
- approve_type — VARCHAR(30) — NOT NULL — 동의, 병렬, 합의 등
- status — VARCHAR(30) — NOT NULL — 결재선의 각 단계의 대기/진행/완료
- create_datetime — DATETIME — NOT NULL
- complete_datetime — DATETIME
- update_datetime — DATETIME
- delete_datetime — DATETIME
approve_sbj
- approve_sbj_id — BIGINT — NOT NULL
- approve_line_id — BIGINT — NOT NULL
- sbj_user_id — VARCHAR(30)
- dept_id — BIGINT
- sbj_department_pic — VARCHAR(30) — NOT NULL — 결재주체가 부서인 경우, 해당 부서에서 결재를 처리하는 담당자(문서를 접수한 사람)
- sbj_type — VARCHAR(30) — NOT NULL — USER, DEPARTMENT
- seq_approve_order — BIGINT — 병렬 그룹 내 순차 결재 순서
- is_pll — TINYINT — NOT NULL
- is_auto — TINYINT — NOT NULL — 자동 동의(참조)되어 결재가 필요하지 않은 경우
- status — VARCHAR(30) — NOT NULL
- complete_datetime — DATETIME
attendance
- attendance_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- get_work_datetime — DATETIME — NOT NULL — 출근 기록 생성 시간과 같음
- get_off_datetime — DATETIME — NOT NULL — 퇴근 시간
authority
- authority_id — BIGINT — NOT NULL
- menu_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- type — VARCHAR(30) — NOT NULL — READ,WRITE
company
- company_id — BIGINT — NOT NULL
- name — VARCHAR(30) — NOT NULL
- chairman — VARCHAR(30) — NOT NULL
- establish — DATETIME — NOT NULL
- address — VARCHAR(255) — NOT NULL
- contact — VARCHAR(30) — NOT NULL
- email — VARCHAR(30) — NOT NULL
- annual_count — BIGINT — NOT NULL
- payment_datetime — DATETIME — NOT NULL
department
- dept_id — BIGINT — NOT NULL
- manage_dept_id — BIGINT — NOT NULL
- name — VARCHAR(30) — NOT NULL
- responsibility — VARCHAR(255) — NOT NULL
- pic — VARCHAR(30) — NOT NULL
- contact — VARCHAR(30) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME — NOT NULL
doc
- doc_id — BIGINT — NOT NULL
- create_user_id — VARCHAR(30) — NOT NULL
- template_id — BIGINT — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — LONGTEXT — NOT NULL — JSON 사용 예정
- status — VARCHAR(30) — NOT NULL — 임시저장, 삭제, 회수,.
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- delete_datetime — DATETIME
- collect_datetime — DATETIME
- draft_datetime — DATETIME
doc_share_obj
- doc_share_obj — BIGINT — NOT NULL
- doc_id — BIGINT — NOT NULL
- share_obj_user_id — VARCHAR(30) — NOT NULL
- share_obj_department_id — BIGINT — NOT NULL
- share_add_user_id — VARCHAR(30) — NOT NULL — 공유 대상을 추가한 사람(작성자 or 결재자)
- share_obj_type — VARCHAR(30) — NOT NULL — USER, DEPARTMENT
- share_datetime — DATETIME — NOT NULL
- delete_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL — SHARED, DELETED
employee
- emp_id — VARCHAR(30) — NOT NULL
- position_id — BIGINT — NOT NULL
- job_id — BIGINT — NOT NULL
- dept_id — BIGINT — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(30) — NOT NULL
- gender — VARCHAR(30) — NOT NULL
- rrn — VARCHAR(30) — NOT NULL
- pay — BIGINT — NOT NULL
- address — VARCHAR(30) — NOT NULL
- contact — VARCHAR(30) — NOT NULL
- email — VARCHAR(30) — NOT NULL
- join_date — DATE — NOT NULL
- status — VARCHAR(30) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
fav_template
- fav_template_id — BIGINT — NOT NULL
- template_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- fav_datetime — DATETIME — NOT NULL
file
- file_id — BIGINT — NOT NULL
- doc_id — BIGINT
- ann_id — BIGINT
- origin_name — VARCHAR(255) — NOT NULL
- file_name — VARCHAR(255) — UUID 붙인 이름
- url — VARCHAR(255) — S3 파일 url
- type — VARCHAR(10) — NOT NULL — PNG, CSV, XLSX, HWP, PDF, JPEG
- size — INT — NOT NULL — byte
- upload_datetime — DATETIME — NOT NULL — S3에 파일이 저장된 시간
- attach_datetime — DATETIME — NOT NULL — 문서에 파일이 첨부된 시간
- delete_datetime — DATETIME — 문서에서 파일을 삭제한 시간
- status — VARCHAR(30) — NOT NULL — SAVED, DELETED
grade_ratio
- grade_ratio_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- s_ratio — BIGINT — NOT NULL
- a_ratio — BIGINT — NOT NULL
- b_ratio — BIGINT — NOT NULL
- c_ratio — BIGINT — NOT NULL
- d_ratio — BIGINT — NOT NULL
- update_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
hr_perfo
- hr_perfo_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- grade — VARCHAR(30) — NOT NULL
- score — BIGINT — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
hr_perfo_history
- hr_perfo_history_id — BIGINT — NOT NULL
- hr_perfo_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- adjustment_degree — BIGINT — NOT NULL
- adjustment_score — BIGINT — NOT NULL
- adjustment_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
hr_perfo_inquiry
- hr_perfo_inquiry_id — BIGINT — NOT NULL
- hr_perfo_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- reason — VARCHAR(255) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- pass_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
job
- job_id — BIGINT — NOT NULL
- dept_id — BIGINT — NOT NULL — 해당 직책이 담당하는 부서
- name — VARCHAR(30) — NOT NULL
- responsibility — VARCHAR(255) — NOT NULL — 해당 직책 담당 업무
- is_active — TINYINT — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
kpi
- kpi_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- goal — VARCHAR(255) — NOT NULL
- goal_value — BIGINT — NOT NULL
- goal_value_unit — VARCHAR(30) — NOT NULL
- current_value — DOUBLE — NOT NULL
- status — VARCHAR(30) — NOT NULL
- personal_type — VARCHAR(30) — NOT NULL
- goal_detail — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
kpi_progress_status
- kpi_pass_id — BIGINT — NOT NULL
- kpi_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- progress_status — DOUBLE — NOT NULL
- update_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
kpi_status
- kpi_pass_id — BIGINT — NOT NULL
- kpi_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- pass_status — VARCHAR(30) — NOT NULL
- pass_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
menu
- menu_id — BIGINT — NOT NULL
- parent_id — BIGINT
- name — VARCHAR(30) — NOT NULL
- url — VARCHAR(255) — NOT NULL
notification
- noti_id — BIGINT — NOT NULL
- approve_sbj_id — BIGINT
- hr_perfo_id — BIGINT
- appointId — BIGINT
- overtime_id — BIGINT
- annual_id — BIGINT
- leave_id — BIGINT
- travel_id — BIGINT
- payroll_id — BIGINT
- content — VARCHAR(50) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- status — TINYINT — NOT NULL — 읽음/안읽음
- create_datetime — DATETIME — NOT NULL — JPA Auditing
overtime
- overtime_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- approve_sbj_id — BIGINT — NOT NULL
- overtime_type — VARCHAR(30) — NOT NULL — 연장, 야간, 휴일
- enroll_overtime — DATETIME — NOT NULL
- overtime_start — DATETIME — NOT NULL
- overtime_end — DATETIME — NOT NULL
- overtime_status — VARCHAR(30) — NOT NULL — 대기 승인 반려
- travel_reject_time — VARCHAR(255)
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL
- is_overtime_retroactive — TINYINT — NOT NULL — 소급 되면 1
- overtime_retroactive_reason — VARCHAR(255)
- overtime_retroactive_status — VARCHAR(30)
payroll
- payroll_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- extend_labor_allowance — BIGINT
- night_labor_allowance — BIGINT
- holiday_labor_allowance — BIGINT
- annual_allowance — BIGINT
- incentive — BIGINT
- national_pension — BIGINT — NOT NULL
- health_insurance — BIGINT — NOT NULL
- hire_insurance — BIGINT — NOT NULL
- long_term_care_insurance — BIGINT — NOT NULL
- income_tax — BIGINT — NOT NULL
- local_income_tax — BIGINT — NOT NULL
- total_amount — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL — 대기, 승인, 반려, 완료
- total_start_date — DATE — NOT NULL
- total_end_date — DATE — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
perfo
- perfo_id — BIGINT — NOT NULL
- perfo_question_id — BIGINT — NOT NULL
- perfo_emp_id — BIGINT — NOT NULL
- perfoed_emp_id — BIGINT — NOT NULL
- answer — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
perfoquestion
- perfo_question_id — BIGINT — NOT NULL
- dept_id — BIGINT — NOT NULL
- question_type — VARCHAR(30) — NOT NULL
- question_content — VARCHAR(255) — NOT NULL
- perfo_type — VARCHAR(30) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
position
- position_id — BIGINT — NOT NULL
- name — VARCHAR(30) — NOT NULL
- level — INT — NOT NULL — 직위의 계층 구조를 표현
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
severance_pay
- severance_pay_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- severance_pay — BIGINT — NOT NULL
- extend_labor_allowance — BIGINT
- night_labor_allowance — BIGINT
- holiday_labor_allowance — BIGINT
- annual_allowance — BIGINT
- severance_day — DATE — NOT NULL
- status — VARCHAR(30) — NOT NULL — 대기, 승인, 반려, 완료
- payment_datetime — DATETIME — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
template
- template_id — BIGINT — NOT NULL
- create_user_id — VARCHAR(30) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- description — LONGTEXT
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- delete_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL
template_field
- template_field_id — BIGINT — NOT NULL
- template_id — BIGINT — NOT NULL
- name — VARCHAR(30) — NOT NULL
- type — VARCHAR(30) — NOT NULL — TEXT, NUMBER, DATE, FILE
- is_req — TINYINT — NOT NULL
- default_value — VARCHAR(30)
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- delete_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL — ACTIVATED, DELETED,
travel
- travel_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- approve_sbj_id — BIGINT — NOT NULL
- enroll_travel — DATETIME — NOT NULL
- travel_reason — VARCHAR(255) — NOT NULL
- travel_start — DATETIME — NOT NULL
- travel_end — DATETIME — NOT NULL
- travel_status — VARCHAR(30) — NOT NULL — 대기, 승인, 반려
- travel_reject_reason — VARCHAR(255)
- travel_division — VARCHAR(30) — NOT NULL — 해외, 국내
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL
vacation
- vacation_id — BIGINT — NOT NULL
- emp_id — VARCHAR(30) — NOT NULL
- approve_sbj_id — BIGINT — NOT NULL
- enroll_vacation — DATETIME — NOT NULL
- vacation_type — VARCHAR(30) — NOT NULL — 경조사, 병가,하계 휴가
- vacation_start — DATETIME — NOT NULL
- vacation_end — DATETIME — NOT NULL
- vacation_status — VARCHAR(30) — NOT NULL — 대기, 승인, 반려
- vacation_reject_reason — VARCHAR(255)
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME
- status — VARCHAR(30) — NOT NULL
weight
- weight_id — BIGINT — NOT NULL
- dept_id — BIGINT — NOT NULL
- emp_id — BIGINT — NOT NULL
- personal_weight — BIGINT — NOT NULL
- team_weight — BIGINT — NOT NULL
- col_weight — BIGINT — NOT NULL
- downward_weight — BIGINT — NOT NULL
- attendance_weight — BIGINT — NOT NULL
- update_reason — VARCHAR(255) — NOT NULL
- create_datetime — DATETIME — NOT NULL
- update_datetime — DATETIME