Intranet
Tables (26)
APRV_HIST (결재 이력)
- APRV_ID — VARCHAR2(20) — Primary key — NOT NULL
- APRV_SNO — VARCHAR2(10) — Primary key — NOT NULL
- APRVTYPE_CD — VARCHAR2(20)
- APRV_IDX — VARCHAR2(10)
- RSLTTYPE_CD — VARCHAR2(10)
- RSLT_NOTE — VARCHAR2(1000)
- RSLT_DT — VARCHAR2(10)
- RSLT_TM — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_LINE_DETL (결재선 상세)
- APRVLINE_ID — VARCHAR2(20) — Primary key — NOT NULL
- APRVLINE_SNO — VARCHAR2(10) — Primary key — NOT NULL
- APRV_IDX — VARCHAR2(10)
- APRVTYPE_CD — VARCHAR2(20)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_LINE_MAST (결재선 마스터)
- APRVLINE_ID — VARCHAR2(20) — Primary key — NOT NULL
- APRVLINE_NM — VARCHAR2(100)
- REG_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_MAST (결재 마스터)
- APRV_ID — VARCHAR2(20) — Primary key — NOT NULL
- APRV_TITLE — VARCHAR2(100)
- APRV_CONT — CLOB
- PROJ_CD — VARCHAR2(20)
- TEMP_CD — VARCHAR2(20)
- APRVSTEP_CD — VARCHAR2(20)
- CURR_APRV_SNO — VARCHAR2(10)
- REG_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_REL_CORP (결재 법인카드정산서)
- APRV_ID — VARCHAR2(20) — Primary key — NOT NULL
- CORP_SNO — VARCHAR2(10) — Primary key — NOT NULL
- CARD_NM — VARCHAR2(20)
- CARD_NO — VARCHAR2(40)
- USE_LOC — VARCHAR2(100)
- USE_AMT — VARCHAR2(100)
- USE_RSN — VARCHAR2(100)
- USE_DT — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_REL_EXP (결재 가지급결의서)
- APRV_ID — VARCHAR2(20) — Primary key — NOT NULL
- METHOD_CD — VARCHAR2(10)
- PREPAY_IDX — VARCHAR2(10)
- PREPAY_DT — VARCHAR2(10)
- PREPAY_AMT — VARCHAR2(100)
- PREPAY_RSN — VARCHAR2(1000)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_REL_ITEM (결재 물품반출입신청서)
- APRV_ID — VARCHAR2(20) — Primary key — NOT NULL
- REQ_SNO — VARCHAR2(10) — Primary key — NOT NULL
- REQTYPE_CD — VARCHAR2(10)
- REQ_IDX — VARCHAR2(10)
- REQ_DT — VARCHAR2(10)
- REQ_RSN — VARCHAR2(1000)
- MGT_NO — VARCHAR2(40)
- ITEM_NM — VARCHAR2(100)
- ITEM_CNT — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
APRV_REL_LEAV (결재 휴가신청서)
- APRV_ID — VARCHAR2(20) — Primary key — NOT NULL
- LEAVTYPE_CD — VARCHAR2(10)
- LEAV_IDX — VARCHAR2(10)
- LEAV_SDT — VARCHAR2(10)
- LEAV_EDT — VARCHAR2(10)
- LEAV_DAYS — VARCHAR2(10)
- LEAV_RSN — VARCHAR2(1000)
- LEAV_SUBST — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
BANR (배너)
- BANR_CD — VARCHAR2(20) — Primary key — NOT NULL
- BANR_SDT — VARCHAR2(10)
- BANR_EDT — VARCHAR2(10)
- BANR_IDX — VARCHAR2(10)
- WIDTH — VARCHAR2(10)
- HEIGHT — VARCHAR2(10)
- BANR_URL — VARCHAR2(1000)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
BOARD (공지사항)
- BRD_ID — VARCHAR2(20) — Primary key — NOT NULL
- BRD_TITLE — VARCHAR2(100)
- BRD_CONT — VARCHAR2(2000)
- READ_HIT — VARCHAR2(10)
- EMP_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
COMMCODE (공통코드)
- COMMCODE_CD — VARCHAR2(20) — Primary key — NOT NULL
- COMMCODE_GCD — VARCHAR2(20) — Primary key — NOT NULL
- COMMCODE_NM — VARCHAR2(20)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
EMP_DUTY (담당 업무)
- DUTY_ID — VARCHAR2(10) — Primary key — NOT NULL
- DUTY_TITLE — VARCHAR2(100)
- DUTY_CONT — VARCHAR2(1000)
- EMP_IDX — VARCHAR2(10)
- TPIC_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
EMP_INFO (직원)
- EMP_IDX — VARCHAR2(10) — Primary key — NOT NULL
- ORG_CD — VARCHAR2(10)
- RANK_CD — VARCHAR2(20)
- EMP_NM — VARCHAR2(100)
- IS_MALE — VARCHAR2(1)
- MOB_NO — VARCHAR2(20)
- EMAIL — VARCHAR2(100)
- ADDR — VARCHAR2(100)
- ADDR_INFO — VARCHAR2(100)
- EMP_ID — VARCHAR2(100) — NOT NULL
- EMP_PWD — VARCHAR2(100)
- HIRE_DT — VARCHAR2(10)
- LEAV_DT — VARCHAR2(10)
EMP_ROLE (메뉴 직원)
- ROLE_CD — VARCHAR2(10) — Primary key — NOT NULL
- EMP_IDX — VARCHAR2(10) — Primary key — NOT NULL
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
FILE_INFO (파일 정보)
- FILE_ID — VARCHAR2(20) — Primary key — NOT NULL
- FILE_SNO — VARCHAR2(10) — Primary key — NOT NULL
- FILE_NM — VARCHAR2(100)
- SAVE_FILE_NM — VARCHAR2(100)
- FILETYPE_CD — VARCHAR2(20)
- FILE_PATH — VARCHAR2(100)
- FILE_EXT — VARCHAR2(20)
- FILE_SIZE — VARCHAR2(20)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
LOG (로그)
- LOG_ID — VARCHAR2(20) — Primary key — NOT NULL
- LOGTYPE_CD — VARCHAR2(100)
- EMP_IDX — VARCHAR2(10)
- MAPPING_ID — VARCHAR2(100)
- IP_ADDR — VARCHAR2(100)
- IS_SUCC — VARCHAR2(10)
- LOG_MSG — CLOB
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
MEETING (회의)
- MTG_CD — VARCHAR2(20) — Primary key — NOT NULL
- MTG_TITLE — VARCHAR2(100)
- MTG_CONT — VARCHAR2(2000)
- MTG_IDX — VARCHAR2(10)
- MTG_DT — VARCHAR2(10)
- MTG_STM — VARCHAR2(10)
- MTG_ETM — VARCHAR2(10)
- MTG_LOC — VARCHAR2(100)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
MENU (메뉴)
- MENU_CD — VARCHAR2(10) — Primary key — NOT NULL
- MENUTYPE_CD — VARCHAR2(10)
- MENU_NM — VARCHAR2(100)
- UPPR_MENU_CD — VARCHAR2(10)
- MAPPING_ID — VARCHAR2(100)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
MENU_ROLE (메뉴 권한)
- ROLE_CD — VARCHAR2(10) — Primary key — NOT NULL
- MENU_CD — VARCHAR2(10) — Primary key — NOT NULL
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
ORG (조직)
- ORG_CD — VARCHAR2(20) — Primary key — NOT NULL
- ORG_NM — VARCHAR2(100)
- UPPR_ORG_CD — VARCHAR2(20)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
PROJECT (프로젝트)
- PROJ_CD — VARCHAR2(20) — Primary key — NOT NULL
- PROJ_TITLE — VARCHAR2(100)
- PROJ_CONT — VARCHAR2(2000)
- PROJ_SDT — VARCHAR2(10)
- PROJ_EDT — VARCHAR2(10)
- STATUS — VARCHAR2(10)
- OWNER — VARCHAR2(10)
- DEPOSIT — VARCHAR2(100)
- TAG — VARCHAR2(2000)
- EMP_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
RANK (직급)
- RANK_CD — VARCHAR2(10) — Primary key — NOT NULL
- RANK_NM — VARCHAR2(100)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
ROLE (권한)
- ROLE_CD — VARCHAR2(10) — Primary key — NOT NULL
- ROLE_NM — VARCHAR2(100)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
TASK (업무일지)
- TASK_ID — VARCHAR2(20) — Primary key — NOT NULL
- TASK_SNO — VARCHAR2(10) — Primary key — NOT NULL
- TASK_TITLE — VARCHAR2(20)
- TASK_CONT — VARCHAR2(1000)
- TASK_HH — VARCHAR2(10)
- TASK_MM — VARCHAR2(10)
- TASK_DT — VARCHAR2(10)
- EMP_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
TASK_CALENDAR (업무 캘린더)
- TLDR_ID — VARCHAR2(20) — Primary key — NOT NULL
- TLDR_TITLE — VARCHAR2(20)
- TLDR_CONT — VARCHAR2(1000)
- TLDR_SDT — VARCHAR2(10)
- TLDR_EDT — VARCHAR2(10)
- EMP_IDX — VARCHAR2(10)
- REG_DT — VARCHAR2(10)
- REG_TM — VARCHAR2(10)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)
TEMPLATE (템플릿)
- TEMP_CD — VARCHAR2(20) — Primary key — NOT NULL
- TEMP_NM — VARCHAR2(100)
- TEMPTYPE_CD — VARCHAR2(10)
- TEMP_CONT — CLOB
- REG_MAPPING_ID — VARCHAR2(100)
- DET_MAPPING_ID — VARCHAR2(100)
- USE_YN — VARCHAR2(1)
- DISP_ORDER — VARCHAR(10)
- REMARK — VARCHAR2(2000)