리펙토링

테이블 (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)