개인정보및메뉴

테이블 (13)

UBIREPORT 출력/다운로드 로그 (COMM.CMMN072)

  • Key (LOG_NO) — VARCHAR — 기본 키 — NOT NULL
  • Field (LOG_SEQ) — NUMBER
  • Field (PRN_FILE_PATH) — VARCHAR
  • Field (PRN_FILE_NM) — VARCHAR
  • Field (PRN_ARGUS) — VARCHAR
  • Field (WORK_EMP_ID) — VARCHAR
  • Field (WORK_NAME_KR) — VARCHAR
  • Field (WORK_JOJIK_CD) — VARCHAR

가상부서에 할당된 실제부서 (COMM.CMMN041)

  • Key (JOJIK_CD) — VARCHAR — 기본 키 — NOT NULL
  • Key (CYBER_DEPT_ID) — VARCHAR — 외래 키 → 부서리스트(가상부서).Key — NOT NULL
  • Field (USE_FG) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

가상부서에 할당된 역할 (COMM.CMMN042)

  • Key (CYBER_DEPT_ID) — VARCHAR — 외래 키 → 부서리스트(가상부서).Key — NOT NULL
  • Key (ROLE_CD) — VARCHAR — 외래 키 → 역할리스트.Key — NOT NULL
  • Field (DEPT_PERS_FG) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

가상신분에 할당된 실제신분 (COMM.CMMN061)

  • Key (JIKJONG_GBN) — VARCHAR — 기본 키 — NOT NULL
  • Key (JIKGB_GBN) — VARCHAR — 기본 키 — NOT NULL
  • Key (CYBER_SINBUN_ID) — VARCHAR — 외래 키 → 신분리스트(가상신분).Key — NOT NULL
  • Field (USE_FG) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP
  • Key (JOJIK_CD) — VARCHAR — NOT NULL

가상신분에 할당된 역할 (OfCOMM.CMMN062)

  • Key (CYBER_SINBUN_ID) — VARCHAR — 외래 키 → 신분리스트(가상신분).Key — NOT NULL
  • Key (ROLE_CD) — VARCHAR — 외래 키 → 역할리스트.Key — NOT NULL
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

개인정보 조회 로그 (COMM.CMMN073)

  • Key (LOG_NO) — VARCHAR — 기본 키 — NOT NULL
  • Field (LOG_SEQ) — NUMBER
  • Field (PGM_ID) — VARCHAR
  • Field (QUERY) — VARCHAR
  • Field (RESULT_XML) — VARCHAR
  • Field (WORK_EMP_ID) — VARCHAR
  • Field (WORK_NAME_KR) — VARCHAR
  • Field (WORK_JOJIK_CD) — VARCHAR

로그인 로그 (COMM.CMMN070)

  • Key (LOG_NO) — VARCHAR — 기본 키 — NOT NULL
  • Field (SYSTEM_ID) — VARCHAR
  • Field (LOGIN_DT) — VARCHAR
  • Field (INPUT_ID) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_DT) — TIMESTAMP

메뉴정보 (COMM.CMMN020)

  • Key (SYSTEM_GB) — VARCHAR — 기본 키 — NOT NULL
  • Key (MENU_ID) — VARCHAR — 기본 키 — NOT NULL
  • Field (PGM_ID) — VARCHAR
  • Field (MENU_GB) — VARCHAR
  • Field (MENU_KNM) — VARCHAR
  • Field (MENU_LEVEL) — VARCHAR
  • Field (MENU_PARENT) — VARCHAR
  • Field (ORDER_SEQ) — NUMBER
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP
  • Field (DEL_FG) — VARCHAR

부서리스트(가상부서) (COMM.CMMN040)

  • Key (CYBER_DEPT_ID) — VARCHAR — 기본 키 — NOT NULL
  • Field (CYBER_DEPT_NM) — VARCHAR
  • Field (CYBER_DEPT_DESC) — VARCHAR
  • Field (USE_FG) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

신분리스트(가상신분) (COMM.CMMN060)

  • Key (CYBER_SINBUN_ID) — VARCHAR — 기본 키 — NOT NULL
  • Field (CYBER_SINBUN_NM) — VARCHAR
  • Field (CYBER_DEPT_DESC) — VARCHAR
  • Field (USE_FG) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

역할리스트 (COMM.CMMN030)

  • Key (ROLE_CD) — VARCHAR — 기본 키 — NOT NULL
  • Field (ROLE_NM) — VARCHAR
  • Field (ROLE_FG) — VARCHAR
  • Field (USER_TYPE) — VARCHAR
  • Field (ROLE_DESC) — VARCHAR
  • Field (ORDER_SEQ) — NUMBER
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

역할에 등록된 메뉴 (COMM.CMMN031)

  • Key (SYSTEM_GB) — VARCHAR — 외래 키 → 메뉴정보.Key — NOT NULL
  • Key (MENU_ID) — VARCHAR — 외래 키 → 메뉴정보.Key — NOT NULL
  • Key (ROLE_CD) — VARCHAR — 외래 키 → 역할리스트.Key — NOT NULL
  • Field (GRANT_GB) — VARCHAR
  • Field (INPUT_IP) — VARCHAR
  • Field (INPUT_ID) — CHAR
  • Field (INPUT_DT) — TIMESTAMP
  • Field (UPDATE_IP) — NUMBER
  • Field (UPDATE_ID) — CHAR
  • Field (UPDATE_DT) — TIMESTAMP

프로세스빌더 중요쿼리실행 로그 (COMM.CMMN071)

  • Key (LOG_NO) — VARCHAR — 기본 키 — NOT NULL
  • Field (LOG_SEQ) — NUMBER
  • Field (PGM_ID) — VARCHAR
  • Field (PACKAGE) — VARCHAR
  • Field (CLASS) — VARCHAR
  • Field (METHOD) — VARCHAR
  • Field (QUERY) — VARCHAR
  • Field (WORK_EMP_ID) — VARCHAR
  • Field (WORK_NAME_KR) — VARCHAR
  • Field (WORK_JOJIK_CD) — VARCHAR