ITSM ERD
Tables (24)
T_CM_SUMMERTIME
- COMPID — CHAR(4 BYTE) — Primary key
- ZONE — NVARCHAR2(18) — Primary key
- YEAR — NVARCHAR2(4) — Primary key
- STD_DAY — NVARCHAR2(4)
- END_DAY — NVARCHAR2(4)
- STD_TIME — NVARCHAR2(8)
- END_TIME — NVARCHAR2(8)
- STD_S_DAY — NVARCHAR2(4)
- END_S_DAY — NVARCHAR2(4)
- STD_S_TIME — NVARCHAR2(8)
- END_S_TIME — NVARCHAR2(8)
- DST — NVARCHAR2(4)
- ADDEMP — NVARCHAR2(25)
- ADDTIM — TIMESTAMP
- LOGEMP — NVARCHAR2(25)
- LOGTIM — TIMESTAMP
T_IF_GW_INFO
- COMPANYID — NVARCHAR2(4)
- COMBASE — NVARCHAR2(100)
- COMEN — NVARCHAR2(100)
- USERID — NVARCHAR2(100)
- NAMEBASE — NVARCHAR2(100)
- NAMEKO — NVARCHAR2(100)
- NAMEEN — NVARCHAR2(100)
- EMPLOYEENUMBER — NVARCHAR2(25)
- MAIL — NVARCHAR2(50)
- MAILID — NVARCHAR2(50)
- MAILDOMAIN — NVARCHAR2(50)
T_ITSM_ALARMS
- SEQ — NUMBER — Primary key
- SND_PSNID — NVARCHAR2(25)
- SND_PSNNM — NVARCHAR2(50)
- SND_COMPID — CHAR(25 BYTE)
- SND_ADDR — NVARCHAR2(50)
- RCV_PSNID — NVARCHAR2(15)
- RCV_PSNNM — NVARCHAR2(50)
- RCV_COMPID — CHAR(25 BYTE)
- RCV_ADDR — NVARCHAR2(50)
- MAI_TYPE — NVARCHAR2(20)
- MAI_TITLE — NVARCHAR2(500)
- MAI_CONT — CLOB
- REG_DATE — DATE
- MAI_YN — CHAR(1 BYTE)
- MAI_ERROR — CLOB
- UDT_DATE — DATE
- ERR_CNT — NUMBER
- SND_LANG — VARCHAR2(5 BYTE)
- RCV_LANG — VARCHAR2(5 BYTE)
T_ITSM_CATE (업무)
- 업무코드 (CATE_CD) — VARCHAR2(25 BYTE) — Primary key
- 사용여부 (CATE_USE_YN) — CHAR(1 BYTE)
- 등록일 (REG_DATE) — DATE
- 업무명(미국) (CATE_NM_USA) — VARCHAR2(200 BYTE)
- 업무명(중국) (CATE_NM_CHN) — VARCHAR2(200 BYTE)
- 업무명(한국) (CATE_NM_KOR) — VARCHAR2(200 BYTE)
- 등록자 (REG_ID) — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_CATE_PSN
- PSN_ID — VARCHAR2(25 BYTE) — Primary key
- 법인코드 (COMP_ID) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_COMP.법인코드
- 업무코드 (CATE_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE.업무코드
- 모듈코드 (MODL_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_MODULE.모듈코드
- DEPT_CD — VARCHAR2(25 BYTE)
- REG_DATE — DATE
- DEPT_NM — VARCHAR2(100 BYTE)
- 등록자 (REG_ID) — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_CATE_PSN_LOG
- TYPE — VARCHAR2(10 BYTE)
- DEPT_CD — VARCHAR2(100 BYTE)
- REG_ID — VARCHAR2(100 BYTE)
- REG_DATE — TIMESTAMP
- DEPT_NM — VARCHAR2(100 BYTE)
- PSN_ID — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE_PSN.PSN_ID
- 법인코드 (COMP_ID) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE_PSN.법인코드
- 업무코드 (CATE_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE_PSN.업무코드
- 모듈코드 (MODL_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE_PSN.모듈코드
T_ITSM_COMP (법인)
- 법인코드 (COMP_ID) — VARCHAR2(25 BYTE) — Primary key
- 사용여부 (COMP_USE_YN) — CHAR(1 BYTE)
- 등록일 (REG_DATE) — TIMESTAMP
- 국가코드 (COMP_CONT) — VARCHAR2(20 BYTE)
- 법인명(한국) (COMP_NM_KOR) — VARCHAR2(100 BYTE)
- 법인명(미국) (COMP_NM_USA) — VARCHAR2(100 BYTE)
- 법인명(중국) (COMP_NM_CHN) — VARCHAR2(100 BYTE)
- 등록자 (REG_ID) — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_FILE
- FIL_IDX — NUMBER(*,0) — Primary key
- FIL_GUBUN — VARCHAR2(20 BYTE)
- FIL_NAME — VARCHAR2(500 BYTE)
- FIL_NAME_DEST — VARCHAR2(1000 BYTE)
- FIL_SIZE — NUMBER(*,0)
- FIL_PATH — VARCHAR2(500 BYTE)
- REG_DATE — TIMESTAMP
- DEL_ID — VARCHAR2(50 BYTE)
- DEL_DATE — TIMESTAMP
- FIL_DEL_YN — CHAR(1 BYTE)
- 구분키 (FIL_GUBUN_KEY) — VARCHAR2(50 BYTE) — Foreign key → T_ITSM_REQ_MASTER.REQ_NUM
- 등록자 (REG_ID) — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_IP
- CLI_IP — VARCHAR2(50 BYTE) — Primary key
- ADMIN_TYPE — CHAR(1 BYTE)
T_ITSM_JSP_SHOW
- 업무코드 (CATE_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE.업무코드
- 모듈코드 (MODL_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_MODULE.모듈코드
- JSP_TYPE — VARCHAR2(20 BYTE)
- REG_DATE — DATE
T_ITSM_MODULE
- 모듈코드 (MODL_CD) — VARCHAR2(25 BYTE) — Primary key
- 사용여부 (MODL_USE_YN) — CHAR(1 BYTE)
- 등록일 (REG_DATE) — DATE
- 모듈명(미국) (MODL_NM_USA) — VARCHAR2(300 BYTE)
- 모듈명(중국) (MODL_NM_CHN) — VARCHAR2(300 BYTE)
- 모듈명(한국) (MODL_NM_KOR) — VARCHAR2(300 BYTE)
- 업무코드 (CATE_CD) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_CATE.업무코드
- 등록자 (REG_ID) — VARCHAR2(25 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_MSG_TMPL
- TMPL_SEQ — NUMBER(*,0) — Primary key
- TMPL_FLAG — CHAR(1 BYTE)
- TMPL_TITLE_KO — VARCHAR2(1000 BYTE)
- TMPL_USE_YN — CHAR(1 BYTE)
- REG_DATE — DATE
- TMPL_TITLE_EN — VARCHAR2(1000 BYTE)
- TMPL_TITLE_ZH — VARCHAR2(1000 BYTE)
- TMPL_CON_KO — CLOB
- TMPL_CON_EN — CLOB
- TMPL_CON_ZH — CLOB
- REG_ID — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_REQ_ALLOC
- 법인 (ALLOC_COMP_ID) — VARCHAR2(25 BYTE) — Primary key
- REQ_NUM (REQ_NUM2) — VARCHAR2(50 BYTE) — Foreign key → T_ITSM_REQ_MASTER.REQ_NUM
- 배분율 (ALLOC_RATE) — NUMBER(*,0)
- ALLOC_REG_DATE — TIMESTAMP
T_ITSM_REQ_ALLOC_LOG
- REQ_NUM — VARCHAR2(50 BYTE)
- ALLOC_COMP_ID — VARCHAR2(25 BYTE)
- ALLOC_RATE — NUMBER(*,0)
- ALLOC_REG_DATE — TIMESTAMP
- LOG_DATE — TIMESTAMP
T_ITSM_REQ_CMT
- CMT_NUM — NUMBER(*,0) — Primary key
- CMT_CON — VARCHAR2(4000 BYTE)
- CMT_REG_DATE — DATE
- CMT_REF — NUMBER(*,0)
- 댓글 층위 (CMT_LEVEL) — NUMBER(*,0)
- CMT_DEL_YN — CHAR(1 BYTE)
- CMT_REPLY — NUMBER(*,0)
- REQ_NUM — VARCHAR2(50 BYTE) — Foreign key → T_ITSM_REQ_MASTER.REQ_NUM
- CMT_REG_ID — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_REQ_MASTER
- REQ_NUM — VARCHAR2(50 BYTE) — Primary key
- 요청법인 (REQ_COMPID) — VARCHAR2(25 BYTE)
- 요청부서 (REQ_DEPT) — NVARCHAR2(50)
- REQ_TITLE — NVARCHAR2(1000)
- REQ_CONTENT — CLOB
- REQ_DATE — TIMESTAMP
- 완료요청일 (REQ_FIN_DATE) — TIMESTAMP
- REQ_BIGO — NVARCHAR2(2000)
- 리비전 최초 등록 시 1 (REQ_REV) — NUMBER
- REQ_USER_EMAIL — VARCHAR2(100 BYTE)
- REQ_USER_PHONE — VARCHAR2(30 BYTE)
- REQ_USER_NM — VARCHAR2(50 BYTE)
- REQ_CATE_CD — VARCHAR2(25 BYTE)
- REQ_TYPE — VARCHAR2(20 BYTE)
- REQ_GRP_KEY — VARCHAR2(50 BYTE)
- IS_MASTER — NUMBER(*,0)
- REQ_MODL_CD — VARCHAR2(25 BYTE)
- 처리결과 (REQ_RESULT_CMT) — VARCHAR2(2000 BYTE)
- SR_NO — VARCHAR2(20 BYTE)
- REQ_CONTENT_NOTAG1 — VARCHAR2(4000 BYTE)
- REQ_CONTENT_NOTAG2 — VARCHAR2(4000 BYTE)
- REQ_CONTENT_NOTAG3 — VARCHAR2(4000 BYTE)
- REQ_USER_ID — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
T_ITSM_REQ_REV
- REQ_NUM — VARCHAR2(50 BYTE) — Foreign key → T_ITSM_REQ_MASTER.REQ_NUM
- REQ_REV — NUMBER
- 진행상태 (REQ_STATUS) — NUMBER
- 착수일 (REQ_START_DATE) — TIMESTAMP
- 완료예정일 (REQ_WILL_FIN_DATE) — TIMESTAMP
- 완료일 (REQ_WORK_FIN_DATE) — TIMESTAMP
- REQ_MGR_COMP_ID — VARCHAR2(25 BYTE)
- REQ_MGR_DEPT — NVARCHAR2(100)
- REQ_MGR_USER_ID — VARCHAR2(25 BYTE)
- 처리시간 (REQ_WORK_HOUR) — NUMBER
- REV_REG_DATE — TIMESTAMP
- REQ_MGR_USER_NM — NVARCHAR2(50)
- REQ_MGR_DEPT_ID — VARCHAR2(20 BYTE)
- REQ_PENDING_REASON — NUMBER
- REV_ACT_USER_ID — VARCHAR2(25 BYTE)
- 중요도 (REQ_PRIORITY) — NUMBER
- REQ_INIT_DATE — TIMESTAMP
- 보류사유 (REQ_PENDING_CMT) — VARCHAR2(3000 BYTE)
- 개발 건 (REQ_DEV_YN) — CHAR(1 BYTE)
- 설계 건 (REQ_DESIGN_YN) — CHAR(1 BYTE)
- 회의 건 (REQ_CONFE_YN) — CHAR(1 BYTE)
- 업무시간 외 (REQ_AFTER_HOURS_YN) — CHAR(1 BYTE)
- 담당업무 외 (REQ_OTHERS_YN) — CHAR(1 BYTE)
- sr유형 (REQ_SR_TYPE) — NUMBER(*,0)
- 처리유형 (REQ_TREAT_TYPE) — NUMBER(*,0)
- RICEF (REQ_RICEF) — NUMBER(*,0)
- 영향도 (REQ_INFLUENCE) — NUMBER(*,0)
T_ITSM_REQ_REV_DEL_LOG
- REQ_NUM — VARCHAR2(50 BYTE)
- REQ_REV — NUMBER
- REQ_STATUS — NUMBER
- REQ_START_DATE — TIMESTAMP
- REQ_WILL_FIN_DATE — TIMESTAMP
- REQ_WORK_FIN_DATE — TIMESTAMP
- REQ_MGR_COMP_ID — VARCHAR2(25 BYTE)
- REQ_MGR_DEPT — NVARCHAR2(100)
- REQ_MGR_USER_ID — VARCHAR2(25 BYTE)
- REQ_WORK_HOUR — NUMBER
- REV_REG_DATE — TIMESTAMP
- REQ_MGR_USER_NM — NVARCHAR2(50)
- REQ_MGR_DEPT_ID — VARCHAR2(20 BYTE)
- REQ_PENDING_REASON — NUMBER
- REV_ACT_USER_ID — VARCHAR2(25 BYTE)
- REQ_PRIORITY — NUMBER
- LOG_DATE — TIMESTAMP
- REQ_INIT_DATE — TIMESTAMP
- REQ_PENDING_CMT — VARCHAR2(3000 BYTE)
- REQ_DEV_YN — CHAR(1 BYTE)
- REQ_DESIGN_YN — CHAR(1 BYTE)
- REQ_CONFE_YN — CHAR(1 BYTE)
- REQ_AFTER_HOURS_YN — CHAR(1 BYTE)
- REQ_OTHERS_YN — CHAR(1 BYTE)
- REQ_SR_TYPE — NUMBER(*,0)
- REQ_TREAT_TYPE — NUMBER(*,0)
- REQ_RICEF — NUMBER(*,0)
- REQ_INFLUENCE — NUMBER(*,0)
T_ITSM_REQ_REV_LOG
- REQ_NUM — VARCHAR2(50 BYTE)
- REQ_REV — NUMBER
- REQ_STATUS — NUMBER
- REQ_START_DATE — TIMESTAMP
- REQ_WILL_FIN_DATE — TIMESTAMP
- REQ_WORK_FIN_DATE — TIMESTAMP
- REQ_MGR_COMP_ID — VARCHAR2(25 BYTE)
- REQ_MGR_DEPT — NVARCHAR2(100)
- REQ_MGR_USER_ID — VARCHAR2(25 BYTE)
- REQ_WORK_HOUR — NUMBER
- REV_REG_DATE — TIMESTAMP
- REQ_MGR_USER_NM — NVARCHAR2(50)
- REQ_MGR_DEPT_ID — VARCHAR2(20 BYTE)
- REQ_PENDING_REASON — NUMBER
- REV_ACT_USER_ID — VARCHAR2(25 BYTE)
- REQ_PRIORITY — NUMBER
- LOG_DATE — TIMESTAMP
- REQ_INIT_DATE — TIMESTAMP
- REQ_PENDING_CMT — VARCHAR2(3000 BYTE)
- REQ_DEV_YN — CHAR(1 BYTE)
- REQ_DESIGN_YN — CHAR(1 BYTE)
- REQ_CONFE_YN — CHAR(1 BYTE)
- REQ_AFTER_HOURS_YN — CHAR(1 BYTE)
- REQ_OTHERS_YN — CHAR(1 BYTE)
- REQ_SR_TYPE — NUMBER(*,0)
- REQ_TREAT_TYPE — NUMBER(*,0)
- REQ_RICEF — NUMBER(*,0)
- REQ_INFLUENCE — NUMBER(*,0)
T_ITSM_REQ_TOKEN
- REQ_TOKEN — VARCHAR2(100 BYTE) — Primary key
- REG_DATE — TIMESTAMP
- EXPIRE_DATE — TIMESTAMP
- DEL_YN — CHAR(1 BYTE)
- REQ_GRP_KEY — VARCHAR2(100 BYTE)
- REQ_NUM — VARCHAR2(50 BYTE) — Foreign key → T_ITSM_REQ_MASTER.REQ_NUM
T_ITSM_REQ_TOKEN_LOG
- REQ_TOKEN — VARCHAR2(100 BYTE)
- REQ_NUM — VARCHAR2(100 BYTE)
- REG_DATE — TIMESTAMP
- EXPIRE_DATE — TIMESTAMP
- DEL_YN — CHAR(1 BYTE)
- REQ_GRP_KEY — VARCHAR2(100 BYTE)
- LOG_DATE — TIMESTAMP
T_ITSM_STSF (만족도평가)
- REQ_NUM — VARCHAR2(50 BYTE) — Foreign key → T_ITSM_REQ_MASTER.REQ_NUM
- 만족도 (STSF_DEG) — NUMBER(*,0)
- 의견 (STSF_OPN) — NVARCHAR2(2000)
- 등록일 (STSF_REG_DATE) — DATE
- STSF_IP — VARCHAR2(20 BYTE)
T_ITSM_USER
- 사번 (USER_ID) — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- 소속법인코드 (COMP_ID) — VARCHAR2(25 BYTE)
- USER_TYPE — VARCHAR2(10 BYTE)
- ADMIN_TYPE - N/A /P (ADMIN_TYPE) — VARCHAR2(20 BYTE)
- USER_PW — VARCHAR2(200 BYTE)
- USER_EMAIL — VARCHAR2(100 BYTE)
- USER_BIRTH — VARCHAR2(6 BYTE)
- 업무담당자여부 (CATE_PSN_YN) — CHAR(1 BYTE)
- USER_NM — VARCHAR2(100 BYTE)
- USER_PHONE — VARCHAR2(30 BYTE)
- 부서명 (DEPT_NM) — VARCHAR2(100 BYTE)
- REG_ID — VARCHAR2(25 BYTE)
- REG_DATE — DATE
- 사용여부 (USER_USE_YN) — CHAR(1 BYTE)
- 부서코드 — VARCHAR2(25 BYTE)
- MAIL_YN — CHAR(1 BYTE)
- MSN_YN — CHAR(1 BYTE)
- USER_LANG — VARCHAR2(20 BYTE)
- 접수관리/ RDATE(완료요청일), WDATE(완료예정일), PRIO(중요도) (ORD_INIT) — VARCHAR2(20 BYTE)
- 진행건 (ODR_PROCESS) — VARCHAR2(20 BYTE)
- 보류건 — VARCHAR2(20 BYTE)
- 완료예정일 디폴트값(일) (WILL_FIN_DAY) — NUMBER(*,0)
- 영문명 (USER_NM_USA) — VARCHAR2(100 BYTE)
- 알람설정 (메일)- 등록 (MAIL_REG_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 접수 (MAIL_INIT_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 진행 (MAIL_PROC_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 보류 (MAIL_PEND_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 댓글등록 (MAIL_ADD_CMT_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 완료예정일 (MAIL_WILL_FIN_DATE_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 완료요청 (MAIL_WAIT_FIN_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 등록 (MSN_REG_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 접수 (MSN_INIT_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 진행 (MSN_PROC_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 보류 (MSN_PEND_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 댓글등록 (MSN_ADD_CMT_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 완료예정일 (MSN_WILL_FIN_DATE_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 완료요청 (MSN_WAIT_FIN_YN) — CHAR(1 BYTE)
- 알람설정 (메일) - 반려 (MAIL_REJECT_YN) — CHAR(1 BYTE)
- 알람설정 (문자) - 반려 (MSN_REJECT_YN) — CHAR(1 BYTE)
- 코스맥스계정 여부 (COSMAX_USER_YN) — CHAR(1 BYTE)
- KEY_USER_YN — CHAR(1 BYTE)
- 비밀번호 틀린 횟수 (PW_INVALID_CNT) — NUMBER(*,0)
T_ITSM_USER_FAV
- 팀원사번 (FAV_USER_ID) — VARCHAR2(20 BYTE) — Primary key — NOT NULL
- 사번 (USER_ID) — VARCHAR2(20 BYTE) — Foreign key → T_ITSM_USER.사번 — NOT NULL
- 등록일 (FAV_REG_DATE) — TIMESTAMP