개인정보및메뉴
테이블 (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