리펙토링
테이블 (33)
EM_AGENCY
- AGENCY_SEQ — VARCHAR2(36)
- PARENT_SEQ — VARCHAR2(36)
- AGENCY_DIVISION — VARCHAR2(10) — 기관구분
- AGENCY_NAME — VARCHAR2(200) — 기관명칭
- AGENCY_SUB_NAME — VARCHAR2(200) — 하위기관명칭
- AGENCY_REG_NUM — VARCHAR2(15) — 사업자번호
- AGENCY_CORP_NUM — VARCHAR2(15) — 법인번호
- AGENCY_AUTH_CODE — CHAR(2) — 기관구분자
- AGENCY_TEL — VARCHAR2(15) — 기관
- AGENCY_FAX — VARCHAR2(100) — 기관
- AGENCY_EMAIL — VARCHAR2(50) — 기관
- AGENCY_ZIP — VARCHAR2(5) — 기관
- AGENCY_ADDR — VARCHAR2(500) — 기관
- AGENCY_ADDR_DTL — VARCHAR2(500) — 기관
- AGENCY_HOMEPAGE — VARCHAR2(300) — 기관
- AGENCY_LOGO — VARCHAR2(500) — 기관
- AGENCY_STATUS — CHAR(1) — 기관
- AGENCY_REG_DATE — TIMESTAMP — 기관
- AGENCY_UP_DATE — TIMESTAMP — 기관
EM_AG_DOCU
- DOCU_SEQ — VARCHAR2(100) — 전자문서
- AGENCY_SEQ — VARCHAR2(100) — 외래 키 → EM_AGENCY.AGENCY_SEQ — 기관
- DOCU_DIVISION — VARCHAR2(10)
- DOCU_TITLE — VARCHAR2(200)
- DOCU_PATH — VARCHAR2(500)
- DOCU_HASH — VARCHAR2(100)
- DOCU_URL — VARCHAR2(200)
- DOCU_PAYLOAD — VARCHAR2(200)
- DOCU_REG_DATE — TIMESTAMP
- DOCU_UP_DATE — TIMESTAMP
EM_AG_FMT_AUTH
- FMT_AUTH_SEQ — VARCHAR2(100)
- MEMBER_SEQ — VARCHAR2(100) — 외래 키 → EM_AG_MEMBER.MEMBER_SEQ
- FORMAT_SEQ — VARCHAR2(100) — 외래 키 → EM_AG_FORMAT.FORMAT_SEQ
- FMT_AUTH_STATUS — CHAR(1)
- FMR_AUTH_REG_DATE — TIMESTAMP
- FMR_AUTH_UP_DATE — TIMESTAMP
EM_AG_FMT_RELAY
- FMT_RELAY_SEQ — VARCHAR2(100)
- RELAY_SEQ — VARCHAR2(100) — 외래 키 → EM_AG_RELAY.RELAY_SEQ
- FORMAT_SEQ — VARCHAR2(100) — 외래 키 → EM_AG_FORMAT.FORMAT_SEQ
- FMT_RELAY_ORDER — NUMBER(38,0)
- FMT_RELAY_OPEN_TIME — VARCHAR2(5)
- FMT_RELAY_RESEND_TIME — VARCHAR2(5)
- FMT_RELAY_KEY — VARCHAR2(500)
- FMT_RELAY_MSG — VARCHAR2(1000)
- FMT_RELAY_STATUS — CHAR(1)
- FMT_RELAY_REG_DATE — TIMESTAMP
- FMT_RELAY_UP_DATE — TIMESTAMP
EM_AG_FORMAT
- FORMAT_SEQ — VARCHAR2(36) — 기관
- AGENCY_SEQ — VARCHAR2(36) — 외래 키 → EM_AGENCY.AGENCY_SEQ — 기관
- FORMAT_CODE — VARCHAR2(4) — 템플릿
- FORMAT_NAME — VARCHAR2(100) — 템플릿
- FORMAT_TYPE — CHAR(4) — 템플릿
- FORMAT_DATA — CLOB — 템플릿
- FORMAT_MATC_DATA — CLOB — 템플릿
- FORMAT_MATC_FILE_NAME — VARCHAR2(50) — 템플릿
- FORMAT_MATC_FILE_PATH — VARCHAR2(300) — 템플릿
- FORMAT_MATC_FILE_SIZE — NUMBER(38,0) — 템플릿
- FORMAT_DIVISION — VARCHAR2(10)
- FORMAT_SEND_TYPE — CHAR(1)
- FORMAT_STAT_TYPE — CHAR(1)
- FORMAT_RESEND_TYPE — VARCHAR2(5)
- FRMAT_STATUS — CHAR(1)
- FORMAT_REG_DATE — TIMESTAMP
- FORMAT_UP_DATE — TIMESTAMP
EM_AG_MEMBER
- MEMBER_SEQ — VARCHAR2(36) — 계정
- AGENCY_SEQ — VARCHAR2(36) — 외래 키 → EM_AGENCY.AGENCY_SEQ — 기관
- MEMBER_DIVISION — VARCHAR2(10) — 계정
- MEMBER_ID — VARCHAR2(50) — 계정
- MEMBER_PASS — VARCHAR2(128) — 계정
- MEMBER_NAME — VARCHAR2(50) — 사용자
- MEMBER_LEVEL — NUMBER(38,0) — 사용자
- MEMBER_TEL — VARCHAR2(128) — 사용자
- MEMBER_PHONE — VARCHAR2(128) — 사용자
- MEMBER_EMAIL — VARCHAR2(128) — 사용자
- MEMBER_IP_ADDR — VARCHAR2(30) — 사용자
- MEMBER_TEAM — VARCHAR2(500) — 사용자
- MEMBER_RANK — VARCHAR2(500) — 사용자
- MEMBER_LIST_CNT — NUMBER(38,0) — 사용자
- MEMBER_LOGIN_FAIL — NUMBER(38,0) — 사용자
- MEMBER_IP_AUTH_CK — CHAR(1) — 사용자
- MEMBER_PASSWORD_RESET_CK — CHAR(1) — 사용자
- MEMBER_SESSION_TIME — VARCHAR2(5) — 사용자
- MEMBER_EMAIL_AUTH_CK — CHAR(1) — 사용자
- MEMBER_STATUS — CHAR(1) — 사용자
- MEMBER_CONN_DATE — TIMESTAMP — 접속일자
- MEMBER_PASS_DATE — TIMESTAMP
- MEMBER_REG_DATE — TIMESTAMP — 등록일자
- MEMBER_UP_DATE — TIMESTAMP — 수정일자
EM_AG_MEM_AUTH
- MEM_AUTH_SEQ — VARCHAR2(36)
- MEMBER_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_MEMBER.MEMBER_SEQ — 계정
- MENU_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_MENU.MENU_SEQ — 메뉴
- AUTH_STATUS — CHAR(1) — 메뉴
- AUTH_C_STATUS — CHAR(1) — 메뉴
- AUTH_R_STATUS — CHAR(1) — 메뉴
- AUTH_U_STATUS — CHAR(1) — 메뉴
- AUTH_D_STATUS — CHAR(1) — 메뉴
- AUTH_REG_DATE — TIMESTAMP — 등록일자
- AUTH_UP_DATE — TIMESTAMP — 수정일자
EM_AG_MEM_LOG
- MEM_LOG_SEQ — VARCHAR2(36)
- MEMBER_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_MEMBER.MEMBER_SEQ
- LOG_API — VARCHAR2(100)
- LOG_CODE — VARCHAR2(100)
- LOG_CLIENT_IP — VARCHAR2(100)
- LOG_HEADER — CLOB
- LOG_REQUEST_PARAM — CLOB
- LOG_RESPONSE_PARAM — CLOB
- LOG_QUERY — CLOB
- LOG_REASON — VARCHAR2(100)
- LOG_EXCEL_ROW_CNT — VARCHAR2(100)
- LOG_TARGET_RCV_INFO — VARCHAR2(1000)
- LOG_TARGET_MEM_ID — VARCHAR2(100)
- LOG_STATUS — CHAR(1)
- LOG_REG_DATE — TIMESTAMP
EM_AG_MENU
- MENU_SEQ — VARCHAR2(36)
- AGENCY_SEQ — VARCHAR2(36) — 외래 키 → EM_AGENCY.AGENCY_SEQ — 기관
- MENU_BASE_SEQ — VARCHAR2(36) — 메뉴
- MENU_DIVISION — VARCHAR2(10) — 메뉴
- MENU_ORDER — NUMBER(38,0) — 메뉴
- MENU_STATUS — CHAR(1) — 메뉴
- MENU_REG_DATE — TIMESTAMP — 메뉴
- MENU_UP_DATE — TIMESTAMP — 메뉴
EM_AG_RCV_RECE
- RECE_SEQ — VARCHAR2(36)
- RECV_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_RECV.RECV_SEQ
- DOCU_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_DOCU.DOCU_SEQ
- FORMAT_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_FORMAT.FORMAT_SEQ
- RECV_RELAY_STATUS — CLOB
- RECE_STATUS — CHAR(2)
- RECE_REG_DATE — TIMESTAMP
- RECE_UP_DATE — TIMESTAMP
EM_AG_RCV_SEND
- SEND_SEQ — VARCHAR2(36)
- RECE_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_RCV_RECE.RECE_SEQ
- FMT_RELAY_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_FMT_RELAY.FMT_RELAY_SEQ
- DOCU_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_DOCU.DOCU_SEQ
- SEND_DOC_NO — VARCHAR2(100)
- RECV_DATE — TIMESTAMP
- SEND_DATE — TIMESTAMP
- AUTH_DATE — TIMESTAMP
- OPEN_DATE — TIMESTAMP
- EXPL_DATE — TIMESTAMP
- RESEND_DATE — TIMESTAMP
- SEND_CK — CHAR(1)
- OPEN_CK — CHAR(1)
- SEND_STATUS — CHAR(1)
- SEND_ERR_CODE — VARCHAR2(20)
- SEND_ERR_MSG — VARCHAR2(2000)
- SEND_REG_DATE — TIMESTAMP
- SEND_UP_DATE — TIMESTAMP
EM_AG_RECV
- RECV_SEQ — VARCHAR2(36)
- AGENCY_SEQ — VARCHAR2(36) — 외래 키 → EM_AGENCY.AGENCY_SEQ
- FORMAT_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_FORMAT.FORMAT_SEQ
- MEMBER_SEQ — VARCHAR2(36) — 외래 키 → EM_AG_MEMBER.MEMBER_SEQ
- RECV_NAME — VARCHAR2(200)
- RECV_BIRTH — VARCHAR2(200)
- RECV_TEL — VARCHAR2(200)
- RECV_CI — VARCHAR2(2000)
- RECV_RESDNTGER — VARCHAR2(1000)
- RECV_MAPPING_DATA — CLOB
- RECV_GROUP — VARCHAR2(36)
- RECV_GROUP_STATUS — VARCHAR2(36)
- RECV_GROUP_CONTENT — VARCHAR2(3000)
- RECV_STATUS — CHAR(1)
- RECV_RSVE_DE — TIMESTAMP
- RECV_REG_DATE — TIMESTAMP
- RECV_UP_DATE — TIMESTAMP
- RECV_ERR_CODE — CHAR(4)
- RECV_ERR_MSG — VARCHAR2(2000)
EM_AG_RELAY
- RELAY_SEQ — VARCHAR2(36)
- AGENCY_SEQ — VARCHAR2(36) — 외래 키 → EM_AGENCY.AGENCY_SEQ — 기관
- RELAY_BASE_SEQ — VARCHAR2(36) — 중계자
- RELAY_DIVISION — VARCHAR2(10) — 중계자
- RELAY_NAME — VARCHAR2(100) — 중계자
- RELAY_CODE — CHAR(3) — 중계자
- RELAY_CONN_TYPE — CHAR(2) — 중계자
- RELAY_MATC_DATA — CLOB — 중계자
- RELAY_SEND_FEE — NUMBER(38,0) — 중계자
- RELAY_OPEN_FEE — NUMBER(38,0) — 중계자
- RELAY_STATUS — CHAR(1) — 중계자
- RELAY_REG_DATE — TIMESTAMP — 중계자
- RELAY_UP_DATE — TIMESTAMP — 중계자
EM_AG_SCHEDULE
- SCHEDULE_SEQ — VARCHAR2(36) — 스캐줄
- AGENCY_SEQ — VARCHAR2(36) — 외래 키 → EM_AGENCY.AGENCY_SEQ — 기관
- SCHEDULE_NAME — VARCHAR2(100) — 스캐줄
- SCHEDULE_TYPE — VARCHAR2(10) — 스캐줄
- SCHEDULE_STATUS — CHAR(1) — 스캐줄
- SCHEDULE_CYCLE — CHAR(1)
- SCHEDULE_SS_TIME — NUMBER(38,0)
- SCHEDULE_SS_FLAG — CHAR(1)
- SCHEDULE_MI_TIME — NUMBER(38,0)
- SCHEDULE_MI_FLAG — CHAR(1)
- SCHEDULE_HH_TIME — NUMBER(38,0)
- SCHEDULE_HH_FLAG — CHAR(1)
- SCHEDULE_DD_TIME — NUMBER(38,0)
- SCHEDULE_DD_FLAG — CHAR(1)
- SCHEDULE_MM_TIME — NUMBER(38,0)
- SCHEDULE_MM_FLAG — CHAR(1)
- SCHEDULE_SIZE — NUMBER(38,0)
- SCHEDULE_WAIT_TIME — NUMBER(38,0)
- SCHEDULE_USE — CHAR(1)
- SCHEDULE_EXC_DATA — NUMBER(38,0)
- SCHEDULE_EXC_CNT — NUMBER(38,0)
- SCHEDULE_EXC_FLAG — CHAR(1)
- SCHEDULE_SEND_TYPE — VARCHAR2(10)
- SCHEDULE_REG_DATE — TIMESTAMP
- SCHEDULE_UP_DATE — TIMESTAMP
EM_MENU_BASE
- MENU_BASE_SEQ — VARCHAR2(36) — 메뉴
- MENU_NAME — VARCHAR2(100) — 메뉴
- MENU_ICON — VARCHAR2(100) — 메뉴
- MENU_URL — VARCHAR2(500) — 메뉴
- MENU_TYPE — CHAR(2) — 메뉴
- MENU_STEP — NUMBER(38,0) — 메뉴
- MENU_C_USE — CHAR(1) — 메뉴
- MENU_R_USE — CHAR(1) — 메뉴
- MENU_U_USE — CHAR(1) — 메뉴
- MENU_D_USE — CHAR(1) — 메뉴
- MENU_REG_DATE — TIMESTAMP — 메뉴
- MENU_UP_DATE — TIMESTAMP — 메뉴
EM_RELAY_BASE
- RELAY_BASE_SEQ — VARCHAR2(36) — 중계자
- RELAY_NAME — VARCHAR2(100) — 중계자
- RELAY_CODE — VARCHAR2(100) — 중계자
- RELAY_MATC — CLOB — 중계자
JOB_HISTORY
- HISTORY_ID — VARCHAR2(36) — 기본 키 — NOT NULL
- CREATE_DT — TIMESTAMP
- UPDATED_DT — TIMESTAMP
- JOB_GROUP — VARCHAR2(50) — NOT NULL
- JOB_NAME — VARCHAR2(50) — NOT NULL
- JOB_TYPE — VARCHAR2(50) — NOT NULL
JOB_STATUS
- STATUS_ID — VARCHAR2(36) — 기본 키 — NOT NULL
- CREATE_DT — TIMESTAMP
- UPDATED_DT — TIMESTAMP
- JOB_STATE — VARCHAR2(255) — NOT NULL
- HISTORY_ID — VARCHAR2(36) — NOT NULL
QRTZ_BLOB_TRIGGERS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- TRIGGER_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
- BLOB_DATA — BLOB
QRTZ_CALENDARS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- CALENDAR_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- CALENDAR — BLOB — NOT NULL
QRTZ_CRON_TRIGGERS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- TRIGGER_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
- CRON_EXPRESSION — VARCHAR2(120) — NOT NULL
- TIME_ZONE_ID — VARCHAR2(80)
QRTZ_FIRED_TRIGGERS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- ENTRY_ID — VARCHAR2(140) — 기본 키 — NOT NULL
- TRIGGER_NAME — VARCHAR2(200) — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — NOT NULL
- INSTANCE_NAME — VARCHAR2(200) — NOT NULL
- FIRED_TIME — NUMBER(19,0) — NOT NULL
- SCHED_TIME — NUMBER(19,0) — NOT NULL
- PRIORITY — NUMBER(13,0) — NOT NULL
- STATE — VARCHAR2(16) — NOT NULL
- JOB_NAME — VARCHAR2(200)
- JOB_GROUP — VARCHAR2(200)
- IS_NONCONCURRENT — VARCHAR2(1)
- REQUESTS_RECOVERY — VARCHAR2(1)
QRTZ_JOB_DETAILS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- JOB_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- JOB_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
- DESCRIPTION — VARCHAR2(250)
- JOB_CLASS_NAME — VARCHAR2(250) — NOT NULL
- IS_DURABLE — VARCHAR2(1) — NOT NULL
- IS_NONCONCURRENT — VARCHAR2(1) — NOT NULL
- IS_UPDATE_DATA — VARCHAR2(1) — NOT NULL
- REQUESTS_RECOVERY — VARCHAR2(1) — NOT NULL
- JOB_DATA — BLOB
QRTZ_LOCKS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- LOCK_NAME — VARCHAR2(40) — 기본 키 — NOT NULL
QRTZ_PAUSED_TRIGGER_GRPS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
QRTZ_SCHEDULER_STATE
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- INSTANCE_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- LAST_CHECKIN_TIME — NUMBER(19,0) — NOT NULL
- CHECKIN_INTERVAL — NUMBER(13,0) — NOT NULL
QRTZ_SIMPLE_TRIGGERS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- TRIGGER_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
- REPEAT_COUNT — NUMBER(7,0) — NOT NULL
- REPEAT_INTERVAL — NUMBER(12,0) — NOT NULL
- TIMES_TRIGGERED — NUMBER(10,0) — NOT NULL
QRTZ_SIMPROP_TRIGGERS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- TRIGGER_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
- STR_PROP_1 — VARCHAR2(512)
- STR_PROP_2 — VARCHAR2(512)
- STR_PROP_3 — VARCHAR2(512)
- INT_PROP_1 — NUMBER(10,0)
- INT_PROP_2 — NUMBER(10,0)
- LONG_PROP_1 — NUMBER(19,0)
- LONG_PROP_2 — NUMBER(19,0)
- DEC_PROP_1 — NUMBER(13,4)
- DEC_PROP_2 — NUMBER(13,4)
- BOOL_PROP_1 — VARCHAR2(1)
- BOOL_PROP_2 — VARCHAR2(1)
- TIME_ZONE_ID — VARCHAR2(80)
QRTZ_TRIGGERS
- SCHED_NAME — VARCHAR2(120) — 기본 키 — NOT NULL
- TRIGGER_NAME — VARCHAR2(200) — 기본 키 — NOT NULL
- TRIGGER_GROUP — VARCHAR2(200) — 기본 키 — NOT NULL
- JOB_NAME — VARCHAR2(200) — NOT NULL
- JOB_GROUP — VARCHAR2(200) — NOT NULL
- DESCRIPTION — VARCHAR2(250)
- NEXT_FIRE_TIME — NUMBER(19,0)
- PREV_FIRE_TIME — NUMBER(19,0)
- PRIORITY — NUMBER(13,0)
- TRIGGER_STATE — VARCHAR2(16) — NOT NULL
- TRIGGER_TYPE — VARCHAR2(8) — NOT NULL
- START_TIME — NUMBER(19,0) — NOT NULL
- END_TIME — NUMBER(19,0)
- CALENDAR_NAME — VARCHAR2(200)
- MISFIRE_INSTR — NUMBER(2,0)
- JOB_DATA — BLOB
SHARP_QUE
- S_IDX — CHAR(15) — 기본 키 — NOT NULL
- S_STATE — NUMBER(4,0) — NOT NULL
- S_SID — VARCHAR2(50)
- S_RMAIL — VARCHAR2(150) — NOT NULL
- S_SUBJECT — VARCHAR2(200) — NOT NULL
- S_CONTENTS — CLOB
- S_FILENAME — VARCHAR2(200)
- S_SDATE — TIMESTAMP — NOT NULL
- S_WDATE — TIMESTAMP — NOT NULL
- S_RMSG — VARCHAR2(1000)
- S_RETRY_CNT — NUMBER(11,0)
SHARP_QUE_LOG
- S_IDX — VARCHAR2(15) — 기본 키 — NOT NULL
- S_STATE — NUMBER(1,0) — NOT NULL
- S_SID — VARCHAR2(50)
- S_RMAIL — VARCHAR2(150) — NOT NULL
- S_SUBJECT — VARCHAR2(200) — NOT NULL
- S_CONTENTS — CLOB
- S_FILENAME — VARCHAR2(200)
- S_SDATE — TIMESTAMP — NOT NULL
- S_WDATE — TIMESTAMP — NOT NULL
- S_RMSG — VARCHAR2(1000)
- S_RETRY_CNT — NUMBER(11,0)
TRANSPORT_ATTACH
- TRANSPORT_ID — NUMBER(10,0) — 기본 키 — NOT NULL
- SEQ_NO — NUMBER(6,0) — 기본 키 — NOT NULL
- FILE_PATH — VARCHAR2(256)
- FILE_NAME — VARCHAR2(256)
- ORIGIN_NAME — VARCHAR2(256)
TRANSPORT_STAT
- TRANSPORT_ID — NUMBER(10,0) — 기본 키 — NOT NULL
- IDENTIFIER — VARCHAR2(36)
- TITLE — VARCHAR2(256) — NOT NULL
- CONTENT — CLOB
- CONTENT_TYPE — CHAR(1)
- CORP_NUM — CHAR(10)
- BIZ_TYPE — CHAR(4)
- GRP_ID — VARCHAR2(80)
- SND_CE_ADDR — VARCHAR2(151)
- SND_NM — VARCHAR2(80)
- RCV_CE_ADDR — VARCHAR2(151)
- RCV_NM — VARCHAR2(80)
- STATUS_CODE — VARCHAR2(50)
- ERR_CODE — VARCHAR2(11)
- ERR_DESC — VARCHAR2(100)
- REG_DATE — TIMESTAMP
- YYYY-MM-DD — HH24:MI:SS')
- RCV_DATE — TIMESTAMP
- YYYY-MM-DD — HH24:MI:SS')
- OPN_DATE — TIMESTAMP
- YYYY-MM-DD — HH24:MI:SS')
- ELAPSED_TIME — NUMBER(6,0)
- RETRY_CNT — NUMBER(6,0)
- RETRY_DATE — TIMESTAMP
- YYYY-MM-DD — HH24:MI:SS')
- ENCRYPT_ALG — CHAR(1)
- CEDA_YN — CHAR(1)
- STATUS_CODE_CEDA — CHAR(1)
- AIP_ID — VARCHAR2(36)