주요업무관리

테이블 (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