주요업무관리
테이블 (30)
Untitled3
alram (알람)
- alram_id (Key) — 기본 키 — NOT NULL
- user_id (Field)
- endpoint (Field2)
- title (Field3)
- content (Field4)
- create_dt (Field5)
- is_read (Field6)
- delete_yn (Field7)
atch_files (첨부파일)
- atch_file_id (첨부파일번호) — 기본 키 — NOT NULL
- atch_file_dt (생성일자)
- atch_file_yn (사용여부)
connection_dept (새올행정부서연계)
- org_no (Key) — 기본 키 — NOT NULL
- sprm_dept_code (Field2)
- upr_dept_code (Field3)
- dep_code (Field4)
- dep_code_nm (Field)
- dep_full_nm (Field5)
- dept_se (Field6)
- dept_seq (Field7)
- dept_rank (Field8)
- rep_tel_no (Field9)
- rep_fax_no (Field10)
- del_yn (Field11)
connection_users (새올행정사용자연계)
- Key — 기본 키 — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
departments (부서)
- department_id (Key) — 기본 키 — NOT NULL
- org_no (Field)
- sprm_dept_code (Field2)
- upr_dept_code (Field3)
- dep_code (Field4)
- dep_code_nm (Field5)
- dep_full_nm (Field6)
- dept_se (Field7)
- dept_seq (Field8)
- dept_rank (Field9)
- connection_yn (Field10)
- role_id (Field11)
file_detail (파일상세)
- file_id (Key) — 기본 키 — NOT NULL
- file_location (Field)
- file_save_nm (Field2)
- file_origin_nm (Field3)
- file_extension (Field4)
- file_size (Field5)
- file_mime (Field6)
- file_cnt (Field7)
- file_fancy_size (Field8)
- use_yn (Field9)
- delete_dt (Field10)
- deleted_by (Field11)
- atch_file_id (첨부파일번호) — 외래 키 → atch_files.atch_file_id — NOT NULL
job_history (작업이력)
- id (Key) — 기본 키 — NOT NULL
- ip_address (Field)
- request_url (Field2)
- http_method (Field3)
- user_id (Field4)
- create_dt (Field5)
kpi_group (지표그룹화)
- kpi_group_id (Key) — 기본 키 — NOT NULL
- name (Field)
- index (Field2)
- use_yn (Field3)
- delete_yn (Field4)
- create_dt (Field5)
- update_dt (Field6)
- work_id (Field7)
kpi_qualitative_details (하위지표정성)
- kpi_qualitative_id (Key) — 기본 키 — NOT NULL
- kpi_summary_id (Field)
- scoring_method (Field2)
- eval_criteria (Field3)
- eval_details (Field4)
- weight_value (Field5)
- eval_score (Field6)
- use_yn (Field7)
- delete_yn (Field8)
- create_at (Field9)
- update_at (Field10)
- user_id (Field11)
kpi_quantitative_details (하위지표정량정보)
- kpi_quantitative_id (Key) — 기본 키 — NOT NULL
- kpi_summary_id (Field)
- eval_criteria (Field2)
- eval_item (Field3)
- eval_score (Field4)
- use_yn (Field5)
- delete_yn (Field6)
- create_at (Field7)
- update_at (Field8)
- user_id (Field9)
kpi_summary (평가정보)
- Key — 기본 키 — NOT NULL
- Field
- Field2
- Field3
kpi_summary_details (하위지표정보)
- kpi_summary_details_id (Key) — 기본 키 — NOT NULL
- eval_point (Field)
- eval_attribute (Field2)
- eval_year (Field3)
- create_dt (Field4)
- delete_yn (Field5)
- kpi_summary_id (Field6)
- compl_yn (Field7)
- comment (Field8)
- progress (Field9)
- details_name (Field10)
- index (Field11)
kpi_summary_details_after (Untitled)
- Key — 기본 키 — NOT NULL
- Field
- Field2
- Field3
- Field4
kpi_summary_details_before (Untitled2)
- Key — 기본 키 — NOT NULL
- Field
- Field2
- Field3
- Field4
kpigroup_workpersonal (개인업무지표)
- kgp_wpn_id (Key) — 기본 키 — NOT NULL
- kpi_group_id (Field)
- work_personal_id (Field2)
- create_dt (Field3)
- update_dt (Field4)
- delete_yn (Field5)
menu (메뉴)
- menu_id (Key) — 기본 키 — NOT NULL
- name (Field)
- icon (Field2)
- to (Field3)
- depth_yn (Field4)
- parent_id (Field5)
- index (Field6)
- use_yn (Field7)
- delete_yn (Field8)
- create_dt (Field9)
- update_dt (Field10)
page_permissions (페이지권한)
- page_permissions_id (Key) — 기본 키 — NOT NULL
- menu_id (Field)
- can_view (Field2)
- can_add (Field3)
- can_edit (Field4)
- can_delete (Field5)
- create_dt (Field6)
- update_dt (Field7)
- use_yn (Field8)
- delete_yn (Field9)
- role_id (Field10)
- user_id (Field11)
roles (권한)
- id (Key) — 기본 키 — NOT NULL
- name (Field)
- role (Field2)
- create_dt (Field3)
- update_dt (Field4)
- delete_yn (Field5)
- use_yn (Field6)
sms_history (알람내역)
- id (Key) — 기본 키 — NOT NULL
sms_template (문자양식정보)
- id (Key) — 기본 키 — NOT NULL
- code (Field)
- content (Field2)
- use_yn (Field3)
- delete_yn (Field4)
- create_dt (Field5)
- update_dt (Field6)
users (사용자)
- user_id (Key) — 기본 키 — NOT NULL
- password (Field)
- name (Field2)
- email (Field3)
- tel_no (Field4)
- hp_no (Field5)
- posit_nm (Field6)
- work_st (Field7)
- approval_dt (Field8)
- login_dt (Field9)
- logout_dt (Field10)
- create_dt (Field11)
- update_dt (Field12)
- use_yn (Field13)
- delete_yn (Field14)
- menu_directly_yn (Field15)
- connection_yn (Field16)
- posit_rank (Field17)
- dep_code (Field18)
- eval_person_yn (Field19)
users_roles (유저권한)
- user_id (Key) — 기본 키 — NOT NULL
- dep_code (Field)
- role_id (Field2)
work (부서업무)
- work_id (Key) — 기본 키 — NOT NULL
- name (Field)
- dep_code (Field2)
- user_id (Field3)
- person_id (Field4)
- importance_yn (Field5)
- wk_value (Field6)
- progress (Field7)
- comment (Field8)
- use_yn (Field9)
- delete_yn (Field10)
- create_dt (Field11)
- update_dt (Field12)
- start_date (Field13)
- end_date (Field14)
- progress_yn (Field15)
work_eval (업무평가)
- work_eval_id (Key) — 기본 키 — NOT NULL
- work_id (Field)
- comment (Field2)
- start_date (Field3)
- end_date (Field4)
- end_yn (Field5)
- create_dt (Field6)
- user_id (Field7)
- kpi_group_id (Field8)
work_eval_detail (업무평가상세정보)
- work_eval_detail_id (Key) — 기본 키 — NOT NULL
- work_personal_id (Field)
- kpi_summary_id (Field2)
- kpi_detail_id (Field3)
- comment (Field4)
- point (Field5)
- create_dt (Field6)
- rejected_yn (Field7)
- user_id (Field8)
- work_eval_id (Field9)
work_files (업무파일)
- id (Key) — 기본 키 — NOT NULL
- file_name (Field2)
- file_org_name (Field3)
- file_size (Field4)
- file_path (Field5)
- delete_yn (Field6)
- create_dt (Field)
- work_id (Key2) — 외래 키 → work.work_id — NOT NULL
work_personal (개인업무)
- work_personal_id (Key) — 기본 키 — NOT NULL
- name (Field)
- progress (Field2)
- comment (Field3)
- use_yn (Field4)
- delete_yn (Field5)
- create_dt (Field6)
- update_dt (Field7)
- user_id (Field8)
- start_date (Field9)
- end_date (Field10)
- comple_yn (Field11)
- compl_date (Field12)
- work_id (Key2) — 외래 키 → work.work_id — NOT NULL
work_personal_details (상세업무)
- work_personal_details_id (Key) — 기본 키 — NOT NULL
- comment (Field)
- progress (Field2)
- compl_yn (Field3)
- delete_yn (Field4)
- create_dt (Field5)
- update_dt (Field6)
- start_date2 (Field7)
- end_date2 (Field8)
- atch_file_id (첨부파일번호) — 외래 키 → atch_files.atch_file_id — NOT NULL
work_sub_file (하위업무파일)
- work_sub_id (Key) — 기본 키 — NOT NULL
- file_name (Field)
- file_org_name (Field2)
- file_size (Field3)
- file_path (Field4)
- delete_yn (Field5)
- create_dt (Field6)
- id (Key2) — 외래 키 → work_files.id — NOT NULL