nexacro
Tables (14)
nexa_auth (권한)
- Key (auth_id) — String — Primary key — NOT NULL
- Field (auth_name) — String
- Field (auth_used) — String
- Field (auth_reg_date) — String
nexa_data_adapter
- Key (da_id) — String — Primary key — NOT NULL
- Field (da_ds_id) — String
- Field (da_name) — String
- Field (da_url) — String
- Field (da_port) — String
- Field (da_db_name) — String
- Field (da_db_id) — String
- Field (da_db_pw) — String
- Field (da_from_table) — String
- Field (da_from_col) — String
- Field (da_from_where) — String
- Field (da_to_table) — String
- Field (da_to_col) — String
- Field (da_pre_query) — String
nexa_dpt (부서)
- Key (dpt_id) — String — Primary key — NOT NULL
- Field (dpt_name) — String
- Field (dpt_reg_date) — String
nexa_emp (직원)
- Key (emp_id) — String — Primary key — NOT NULL
- Key (dpt_id) — String — Foreign key → nexa_dpt.Key — NOT NULL
- Key (grade_cd) — String — Foreign key → nexa_grade.Key — NOT NULL
- Field (emp_password) — String
- Field (emp_name) — String
- Field (emp_birth) — String
- Field (emp_phone) — String
- Field (emp_address) — String
- Field (emp_zipcode) — String
- Field (emp_profile) — String
- Field (emp_status) — String
- Field (emp_join_date) — String
- Field (emp_reg_date) — String
- Field (emp_mod_date) — String
- Field (emp_head_yn) — boolean
nexa_emp_auth (직원 권한)
- Key (auth_id) — String — Foreign key → nexa_auth.Key — NOT NULL
- Key (emp_id) — String — Foreign key → nexa_emp.Key — NOT NULL
nexa_grade (직급)
- Key (grade_cd) — String — Primary key — NOT NULL
- Field (grade_name) — String
nexa_menu (메뉴)
- Key (menu_id) — String — Primary key — NOT NULL
- Field (menu_name) — String
- Field (menu_used) — boolean
- Field (menu_url) — String
- Field (menu_pid) — String
nexa_menu_auth (메뉴 권한)
- Key (auth_id) — String — Foreign key → nexa_auth.Key — NOT NULL
- Key (menu_id) — String — Foreign key → nexa_menu.Key — NOT NULL
nexa_srm (업무)
- Key (srm_id) — String — Primary key — NOT NULL
- Key (work_id) — String — Foreign key → nexa_work.Key — NOT NULL
- Key (step_id) — String — Foreign key → nexa_step.Key — NOT NULL
- Field (srm_req_title) — String
- Field (srm_req_content) — String
- Field (srm_req_emp_id) — String
- Field (srm_req_dpt_id) — String
- Field (srm_req_date) — String
- Field (srm_acp_content) — String
- Field (srm_acp_emp_id) — String
- Field (srm_acp_dpt_id) — String
- Field (srm_acp_date) — String
- Field (srm_comp_date) — String
- Field (srm_act_content) — String
- Field (srm_act_emp_id) — String
- Field (srm_act_dpt_id) — String
- Field (srm_act_date) — String
- Field (srm_act_start_date) — String
- Field (srm_act_end_date) — String
- Field (srm_app_emp_id) — String
- Field (srm_app_dpt_id) — String
- Field (srm_app_order) — String
- Field (srm_app_date) — String
- Field (srm_end_date) — String
nexa_srm_app (업무결재이력)
- Key (srm_id) — String — Foreign key → nexa_srm.Key — NOT NULL
- Field (srm_app_emp_id) — String
- Field (srm_app_yn) — boolean
- Field (srm_app_date) — String
nexa_srm_cc (업무결재참조)
- Key (srm_id) — String — Foreign key → nexa_srm.Key — NOT NULL
- Field (step_id) — String
- Field (srm_cc_reg_date) — String
- Field (srm_cc_emp_id) — String
- Field (srm_cc_dpt_id) — String
nexa_srm_history (업무이력)
- Key (srm_id) — String — Foreign key → nexa_srm.Key — NOT NULL
- Key (step_id) — String — Foreign key → nexa_srm.Key — NOT NULL
- Field (his_emp_id) — String
- Field (his_dpt_id) — String
- Field (his_step_id) — String
- Field (his_date) — String
- Field (his_reject_reason) — String
nexa_step (업무단계)
- Key (step_id) — String — Primary key — NOT NULL
- Field (step_name) — String
- Field (auth_id) — String
- Field (step_next_id) — String
- Field (step_reject_id) — String
- Field (step_view_id) — String
- Field (step_form_id) — String
nexa_work (업무구분)
- Key (work_id) — String — Primary key — NOT NULL
- Key (dpt_id) — String — Foreign key → nexa_dpt.Key — NOT NULL
- Field (work_name) — String
- Field (work_reg_date) — String
- Field (work_used) — String
- Field (work_start_step) — String