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