admin

Tables (245)

BANK_USER

  • USPS_ID — VARCHAR2(14) — NOT NULL
  • IBNK_USPS_STC — VARCHAR2(1) — NOT NULL
  • PSWD — VARCHAR2(64) — NOT NULL
  • USER_NM — VARCHAR2(50) — NOT NULL
  • RSG_DT — VARCHAR2(8)
  • RSG_TM — VARCHAR2(6)
  • PSWD_INPUT_ERR_TMS — NUMBER(3)

BANK_USER_AUTH

  • USPS_ID — VARCHAR2(14) — NOT NULL
  • AUTH_MENU — VARCHAR2(3) — NOT NULL
  • AUTH — VARCHAR2(1) — NOT NULL

BATCH_JOB_EXECUTION

  • JOB_EXECUTION_ID — NUMBER(19) — NOT NULL
  • VERSION — NUMBER(19)
  • JOB_INSTANCE_ID — NUMBER(19) — NOT NULL
  • CREATE_TIME — TIMESTAMP(6) — NOT NULL
  • START_TIME — TIMESTAMP(6)
  • END_TIME — TIMESTAMP(6)
  • STATUS — VARCHAR2(40)
  • EXIT_CODE — VARCHAR2(4000)
  • EXIT_MESSAGE — VARCHAR2(4000)
  • LAST_UPDATED — TIMESTAMP(6)
  • JOB_CONFIGURATION_LOCATION — VARCHAR2(4000)

BATCH_JOB_EXECUTION_CONTEXT

  • JOB_EXECUTION_ID — NUMBER(19) — NOT NULL
  • SHORT_CONTEXT — VARCHAR2(2500) — NOT NULL
  • SERIALIZED_CONTEXT — CLOB

BATCH_JOB_EXECUTION_PARAMS

  • JOB_EXECUTION_ID — NUMBER(19) — NOT NULL
  • TYPE_CD — VARCHAR2(6) — NOT NULL
  • KEY_NAME — VARCHAR2(100) — NOT NULL
  • STRING_VAL — VARCHAR2(250)
  • DATE_VAL — TIMESTAMP(6)
  • LONG_VAL — NUMBER(19)
  • DOUBLE_VAL — NUMBER
  • IDENTIFYING — CHAR(1) — NOT NULL

BATCH_JOB_INSTANCE

  • JOB_INSTANCE_ID — NUMBER(19) — NOT NULL
  • VERSION — NUMBER(19)
  • JOB_NAME — VARCHAR2(100) — NOT NULL
  • JOB_KEY — VARCHAR2(32) — NOT NULL

BATCH_STEP_EXECUTION

  • STEP_EXECUTION_ID — NUMBER(19) — NOT NULL
  • VERSION — NUMBER(19) — NOT NULL
  • STEP_NAME — VARCHAR2(100) — NOT NULL
  • JOB_EXECUTION_ID — NUMBER(19) — NOT NULL
  • START_TIME — TIMESTAMP(6) — NOT NULL
  • END_TIME — TIMESTAMP(6)
  • STATUS — VARCHAR2(10)
  • COMMIT_COUNT — NUMBER(19)
  • READ_COUNT — NUMBER(19)
  • FILTER_COUNT — NUMBER(19)
  • WRITE_COUNT — NUMBER(19)
  • READ_SKIP_COUNT — NUMBER(19)
  • WRITE_SKIP_COUNT — NUMBER(19)
  • PROCESS_SKIP_COUNT — NUMBER(19)
  • ROLLBACK_COUNT — NUMBER(19)
  • EXIT_CODE — VARCHAR2(2500)
  • EXIT_MESSAGE — VARCHAR2(2500)
  • LAST_UPDATED — TIMESTAMP(6)

BATCH_STEP_EXECUTION_CONTEXT

  • STEP_EXECUTION_ID — NUMBER(19) — NOT NULL
  • SHORT_CONTEXT — VARCHAR2(2500) — NOT NULL
  • SERIALIZED_CONTEXT — CLOB

DEPT

  • DEPTNO — NUMBER(2)
  • DNAME — VARCHAR2(14)
  • LOC — VARCHAR2(13)

EMP

  • EMPNO — NUMBER(4)
  • ENAME — VARCHAR2(10)
  • JOB — VARCHAR2(9)
  • MGR — NUMBER(4)
  • HIREDATE — DATE
  • SAL — NUMBER(7,2)
  • COMM — NUMBER(7,2)
  • DEPTNO — NUMBER(2)

FWK_ACCESS_USER

  • TRX_ID — VARCHAR2(50) — NOT NULL
  • CUST_USER_ID — VARCHAR2(50) — NOT NULL
  • USE_YN — VARCHAR2(1)
  • GUBUN_TYPE — VARCHAR2(1) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL

FWK_API

  • API_ID — VARCHAR2(40) — NOT NULL
  • API_NAME — VARCHAR2(40)
  • API_URL — VARCHAR2(100) — NOT NULL
  • API_MENU_INFO — VARCHAR2(200)
  • JSON_DATA — VARCHAR2(4000)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • FIRST_INSERT_USER_ID — VARCHAR2(20)
  • FIRST_INSERT_DTIME — VARCHAR2(14)
  • USE_YN — VARCHAR2(1)
  • DELETE_YN — VARCHAR2(1)
  • API_DESC — VARCHAR2(500)

FWK_API_APP

  • APP_ID — VARCHAR2(20) — NOT NULL
  • APP_NAME — VARCHAR2(200)
  • APP_CATEGORY — VARCHAR2(20)
  • APP_STATE — VARCHAR2(20)
  • APP_REGIDATE — VARCHAR2(14)
  • APP_SECRET_KEY — VARCHAR2(20)
  • LOGIN_API_USE_YN — VARCHAR2(100)
  • DEVELOPER_ID — VARCHAR2(50)
  • SCOPE — VARCHAR2(300)
  • APPROVAL_YN — VARCHAR2(1)

FWK_API_APP_AUTH_CODE

  • APP_ID — VARCHAR2(20) — NOT NULL
  • APP_USER_ID — VARCHAR2(30) — NOT NULL
  • CODE_CD — VARCHAR2(200) — NOT NULL
  • APP_OS_TYPE — VARCHAR2(20)
  • GRANT_TYPE — VARCHAR2(20)
  • EXPIRE_TIME — VARCHAR2(8)
  • CREATED_DATE — VARCHAR2(14)
  • UPDATED_DATE — VARCHAR2(14)

FWK_API_APP_DETAIL

  • APP_ID — VARCHAR2(20) — NOT NULL
  • APP_OS_TYPE — VARCHAR2(20) — NOT NULL
  • GRANT_TYPE — VARCHAR2(20)
  • APP_SERVICE_URL — VARCHAR2(200)
  • APP_CALLBACK_URL — VARCHAR2(200)
  • APP_ERROR_URL — VARCHAR2(200)
  • APP_PACKAGE_NAME — VARCHAR2(200)
  • APP_DOWNLOAD_URL — VARCHAR2(200)

FWK_API_APP_USER_TOKEN

  • APP_ID — VARCHAR2(20) — NOT NULL
  • APP_USER_ID — VARCHAR2(30) — NOT NULL
  • ACCESS_TOKEN — VARCHAR2(2000)
  • REFRESH_TOKEN — VARCHAR2(2000)
  • TOKEN_TYPE — VARCHAR2(20)
  • SCOPE — VARCHAR2(200)
  • AUTH_CODE — VARCHAR2(200)
  • STATE — VARCHAR2(100)
  • GRANT_TYPE — VARCHAR2(20)
  • APP_OS_TYPE — VARCHAR2(20)
  • EXPIRE_TIME — VARCHAR2(8)
  • LAST_USE_DATE — VARCHAR2(14)
  • CREATED_DATE — VARCHAR2(14)
  • UPDATED_DATE — VARCHAR2(14)

FWK_API_DEVELOPER

  • DEVELOPER_NO — NUMBER — NOT NULL
  • DEVELOPER_ID — VARCHAR2(20) — NOT NULL
  • DEVELOPER_NM — VARCHAR2(100)
  • DEVELOPER_PWD — VARCHAR2(300) — NOT NULL
  • DEVELOPER_TYPE — VARCHAR2(1)
  • DEVELOPER_EMAIL — VARCHAR2(100)
  • DEVELOPER_TEL — VARCHAR2(20)
  • REG_DATE — VARCHAR2(14)
  • DEVELOPER_STATE — VARCHAR2(1)
  • PARTNER_NM — VARCHAR2(100)
  • PARTNER_REGNO — VARCHAR2(30)
  • PARTNER_ADR — VARCHAR2(200)
  • APP_CNT — NUMBER
  • STOP_REASON — VARCHAR2(500)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • TEMP1 — VARCHAR2(50)
  • TEMP2 — VARCHAR2(50)

FWK_API_MONITOR

  • TRX_TRACKING_NO — VARCHAR2(30) — NOT NULL
  • API_URL — VARCHAR2(40) — NOT NULL
  • API_METHOD — VARCHAR2(10) — NOT NULL
  • APP_ID — VARCHAR2(20) — NOT NULL
  • REQ_DTIME — VARCHAR2(17) — NOT NULL
  • RES_DTIME — VARCHAR2(17) — NOT NULL
  • EXE_TIME — NUMBER
  • SUCCESS_YN — VARCHAR2(1)

FWK_ARTICLE

  • ARTICLE_SEQ — NUMBER — NOT NULL
  • BOARD_ID — VARCHAR2(20) — NOT NULL
  • CATEGORY_SEQ — VARCHAR2(20)
  • TOP_YN — VARCHAR2(1) — NOT NULL
  • REF_ARTICLE_SEQ — NUMBER
  • POSITION — NUMBER — NOT NULL
  • STEP — NUMBER — NOT NULL
  • TITLE — VARCHAR2(500) — NOT NULL
  • WRITER_ID — VARCHAR2(20) — NOT NULL
  • WRITER_NAME — VARCHAR2(50) — NOT NULL
  • READ_CNT — NUMBER — NOT NULL
  • ATTATCH_FILE_PATH_1 — VARCHAR2(500)
  • DOWNLOAD_CNT_1 — NUMBER
  • ATTATCH_FILE_PATH_2 — VARCHAR2(500)
  • DOWNLOAD_CNT_2 — NUMBER
  • ATTATCH_FILE_PATH_3 — VARCHAR2(500)
  • DOWNLOAD_CNT_3 — NUMBER
  • REGIST_DTIME — VARCHAR2(14) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14) — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • CONTENT — CLOB

FWK_ARTICLE_USER

  • USER_ID — VARCHAR2(20) — NOT NULL
  • BOARD_ID — VARCHAR2(20) — NOT NULL
  • ARTICLE_SEQ — NUMBER — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL

FWK_BANK_STATUS

  • BANK_CODE — VARCHAR2(3) — NOT NULL
  • BANK_NAME — VARCHAR2(50) — NOT NULL
  • STABLE_YN — VARCHAR2(1) — NOT NULL
  • TIMEOUT — NUMBER(3) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL

FWK_BATCH_APP

  • BATCH_APP_ID — VARCHAR2(50) — NOT NULL
  • BATCH_APP_NAME — VARCHAR2(50)
  • BATCH_APP_FILE_NAME — VARCHAR2(200) — NOT NULL
  • BATCH_APP_DESC — VARCHAR2(200)
  • PRE_BATCH_APP_ID — VARCHAR2(50)
  • BATCH_CYCLE — VARCHAR2(1) — NOT NULL
  • CRON_TEXT — VARCHAR2(20)
  • RETRYABLE_YN — VARCHAR2(1) — NOT NULL
  • PER_WAS_YN — VARCHAR2(1) — NOT NULL
  • IMPORTANT_TYPE — VARCHAR2(1) — NOT NULL
  • PROPERTIES — VARCHAR2(500)
  • TRX_ID — VARCHAR2(20)
  • ORG_ID — VARCHAR2(10)
  • IO_TYPE — VARCHAR2(1)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL

FWK_BATCH_HIS

  • BATCH_APP_ID — VARCHAR2(50) — NOT NULL
  • INSTANCE_ID — VARCHAR2(4) — NOT NULL
  • BATCH_DATE — VARCHAR2(8) — NOT NULL
  • BATCH_EXECUTE_SEQ — NUMBER(3) — NOT NULL
  • LOG_DTIME — VARCHAR2(17)
  • YYYYMMDDHH24MISSFF3) — NOT — NOT NULL
  • BATCH_END_DTIME — VARCHAR2(17)
  • RES_RT_CODE — VARCHAR2(40)
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • ERROR_CODE — VARCHAR2(40)
  • ERROR_REASON — VARCHAR2(4000)
  • RECORD_COUNT — NUMBER(10)
  • EXECUTE_COUNT — NUMBER(10)
  • SUCCESS_COUNT — NUMBER(10)
  • FAIL_COUNT — NUMBER(10)

FWK_BIZ_APP

  • BIZ_APP_ID — VARCHAR2(50) — NOT NULL
  • BIZ_APP_NAME — VARCHAR2(50)
  • BIZ_APP_DESC — VARCHAR2(300) — NOT NULL
  • BIZ_GROUP_ID — VARCHAR2(20)
  • DUP_CHECK_YN — VARCHAR2(1) — NOT NULL
  • DUP_CHECK_APP_ID — VARCHAR2(50)
  • ACCESS_CHECK_YN — VARCHAR2(1) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • TESTCASE_APP_ID — VARCHAR2(50)
  • TESTCASE_ALL_EXEC_YN — VARCHAR2(1)
  • PRE_TRX_ID — VARCHAR2(50)
  • QUE_NAME — VARCHAR2(20)
  • LOG_YN — VARCHAR2(1)
  • BIZ_DAY_CHECK_YN — VARCHAR2(1)

FWK_BIZ_GROUP

  • BIZ_GROUP_ID — VARCHAR2(20) — NOT NULL
  • BIZ_GROUP_NAME — VARCHAR2(50)
  • BIZ_GROUP_DESC — VARCHAR2(200)
  • BIZ_L_GROUP_ID — VARCHAR2(20) — NOT NULL
  • BIZ_L_GROUP_NAME — VARCHAR2(50)
  • BIZ_SUB_GROUP_ID — VARCHAR2(20)
  • BIZ_SUB_GROUP_NAME — VARCHAR2(50)
  • DEFAULT_WORK_SPACE_ID — VARCHAR2(20)
  • DEPTH — VARCHAR2(1)
  • BIZ_DOMAIN — VARCHAR2(10)
  • KOR_PATH_TEXT — VARCHAR2(100)
  • ENG_PKG_TEXT — VARCHAR2(50)

FWK_BIZ_GROUP_TEMP

  • BIZ_GROUP_ID — VARCHAR2(20) — NOT NULL
  • BIZ_GROUP_NAME — VARCHAR2(50)
  • BIZ_GROUP_DESC — VARCHAR2(200)

FWK_BIZ_PART_STATUS

  • BIZ_GROUP_ID — VARCHAR2(20) — NOT NULL
  • BIZ_SEQ — NUMBER(3) — NOT NULL
  • BIZ_GROUP_NAME — VARCHAR2(50)
  • BIZ_ITEM — VARCHAR2(30)
  • BIZ_PRIORITY — VARCHAR2(1)
  • RESULT_STATUS — VARCHAR2(1)
  • ISSUE_REASON — VARCHAR2(1000)
  • ETC_MEMO — VARCHAR2(1000)

FWK_BOARD

  • BOARD_ID — VARCHAR2(20) — NOT NULL
  • BOARD_NAME — VARCHAR2(50) — NOT NULL
  • BOARD_TYPE — VARCHAR2(1) — NOT NULL
  • ADMIN_ID — VARCHAR2(20)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL

FWK_BOARD_AUTH

  • USER_ID — VARCHAR2(20) — NOT NULL
  • BOARD_ID — VARCHAR2(20) — NOT NULL
  • AUTH_CODE — VARCHAR2(1) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL

FWK_BOARD_CATEGORY

  • BOARD_ID — VARCHAR2(20) — NOT NULL
  • CATEGORY_SEQ — VARCHAR2(10) — NOT NULL
  • CATEGORY_NAME — VARCHAR2(50) — NOT NULL

FWK_BUSINESS_DAY

  • BUSINESS_DAY — VARCHAR2(8) — NOT NULL
  • BUSINESS_DAY_TYPE — VARCHAR2(1)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20)

FWK_CLIENT_MENU

  • MENU_ID — VARCHAR2(40) — NOT NULL
  • PRIOR_MENU_ID — VARCHAR2(40) — NOT NULL
  • SORT_ORDER — NUMBER(3) — NOT NULL
  • MENU_URL — VARCHAR2(200) — NOT NULL
  • KOR_MENU_NAME — VARCHAR2(70) — NOT NULL
  • ENG_MENU_NAME — VARCHAR2(70)
  • LEFT_HIGHLIGHT_MENU_ID — VARCHAR2(40)
  • LOGIN_YN — VARCHAR2(1)
  • DISPLAY_YN — VARCHAR2(1) — NOT NULL
  • MENU_AUTH — VARCHAR2(50)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)

FWK_CMS_ASSET

  • ASSET_ID — VARCHAR2(50) — NOT NULL
  • ASSET_NAME — VARCHAR2(50)
  • BUSINESS_CATEGORY — VARCHAR2(10)
  • CREATE_USER_ID — VARCHAR2(10)
  • CREATE_USER_NAME — VARCHAR2(10)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIER_NAME — VARCHAR2(10)
  • CREATE_DATE — VARCHAR2(8)
  • BEGINNING_DATE — VARCHAR2(8)
  • EXPIRED_DATE — VARCHAR2(8)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • ASSET_DESC — VARCHAR2(300)
  • ASSET_DESC_DETAIL — VARCHAR2(2000)
  • ASSET_STATE — VARCHAR2(10)
  • USE_YN — VARCHAR2(1)
  • ASSET_THUMBNAIL — VARCHAR2(200)

FWK_CMS_ASSET_COMPONENT

  • ASSET_ID — VARCHAR2(20)
  • COMPONENT_ID — VARCHAR2(20) — NOT NULL
  • RESOURCE_ID — VARCHAR2(20) — NOT NULL
  • RESOURCE_TYPE — VARCHAR2(10)
  • RESOURCE_PATH — VARCHAR2(300)
  • RESOURCE_URL — VARCHAR2(300)
  • APPROVE_NO — VARCHAR2(30)
  • APPROVE_DATE — VARCHAR2(8)
  • EXPIRED_DATE — VARCHAR2(8) — NOT NULL
  • BEGINNING_DATE — VARCHAR2(8) — NOT NULL
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • USE_YN — VARCHAR2(1)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • FILE_CRC_VALUE — VARCHAR2(20)

FWK_CMS_ASSET_PAGE_MAP

  • PAGE_ID — VARCHAR2(50) — NOT NULL
  • ASSET_ID — VARCHAR2(50)
  • COMPONENT_ID — VARCHAR2(50) — NOT NULL
  • EXPIRED_DATE — VARCHAR2(8) — NOT NULL
  • RESOURCE_ID — VARCHAR2(20) — NOT NULL
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • LAST_MODIFIER_ID — VARCHAR2(10)

FWK_CMS_COMPONENT

  • COMPONENT_ID — VARCHAR2(20) — NOT NULL
  • COMPONENT_NAME — VARCHAR2(300)
  • COMPONENT_CATEGORY_CODE — VARCHAR2(3) — NOT NULL
  • COMPONENT_PRIORITY_VALUE — VARCHAR2(20)
  • COMPONENT_THUMBNAIL — VARCHAR2(200)
  • USER_GUIDE — VARCHAR2(4000)
  • BUILDER_DESC — VARCHAR2(1000)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • COMPONENT_HTML — CLOB
  • COMPONENT_IMG_COUNT — VARCHAR2(2)
  • GLIDE_YN — VARCHAR2(1)
  • TARGET_SETTING_USE_YN — VARCHAR2(1)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • PRODUCT_USE_YN — VARCHAR2(1)

FWK_CMS_FILE_SEND_HIS

  • INSTANCE_ID — VARCHAR2(80) — NOT NULL
  • FILE_ID — VARCHAR2(50) — NOT NULL
  • FILE_SIZE — VARCHAR2(10) — NOT NULL
  • FILE_CRC_VALUE — VARCHAR2(20) — NOT NULL
  • LAST_MODIFIED_DTIME — VARCHAR2(14) — NOT NULL
  • LAST_MODIFIER_ID — VARCHAR2(10)

FWK_CMS_PAGE

  • PAGE_ID — VARCHAR2(50) — NOT NULL
  • PAGE_NAME — VARCHAR2(50)
  • OWNER_DEPT_CODE — VARCHAR2(10)
  • FILE_PATH — VARCHAR2(300)
  • CREATE_USER_ID — VARCHAR2(10)
  • CREATE_USER_NAME — VARCHAR2(10)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIER_NAME — VARCHAR2(10)
  • APPROVER_ID — VARCHAR2(10)
  • APPROVER_NAME — VARCHAR2(10)
  • CREATE_DATE — VARCHAR2(8)
  • CONFIRM_DTIME — VARCHAR2(8)
  • BEGINNING_DATE — VARCHAR2(8)
  • EXPIRED_DATE — VARCHAR2(8)
  • APPROVE_STATE — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • PAGE_DESC — VARCHAR2(300)
  • PAGE_DESC_DETAIL — VARCHAR2(2000)
  • TEMPLATE_ID — VARCHAR2(50)
  • THUMBNAIL — VARCHAR2(300)
  • TARGET_CD — VARCHAR2(2)
  • USER_GUIDE — VARCHAR2(2000)
  • FILE_PATH_BACK — VARCHAR2(300)
  • REJECTED_REASON — VARCHAR2(500)
  • USE_YN — VARCHAR2(1)
  • APPROVE_DATE — VARCHAR2(8)
  • FILE_CRC_VALUE — VARCHAR2(20)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)

FWK_CMS_SERVER_INSTANCE

  • INSTANCE_ID — VARCHAR2(20) — NOT NULL
  • INSTANCE_NAME — VARCHAR2(100) — NOT NULL
  • INSTANCE_DESC — VARCHAR2(100) — NOT NULL
  • INSTANCE_IP — VARCHAR2(15) — NOT NULL
  • INSTANCE_PORT — NUMBER(5) — NOT NULL
  • CREATE_DTIME — VARCHAR2(14) — NOT NULL
  • ALIVE_YN — VARCHAR2(1)
  • LAST_ALIVE_CHECK_DTIME — VARCHAR2(14)
  • SERVER_TYPE — VARCHAR2(3)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)

FWK_CMS_TARGET_ASSET_MAP

  • TARGET_CD — VARCHAR2(5) — NOT NULL
  • ASSET_ID — VARCHAR2(20) — NOT NULL
  • RANK_CD — VARCHAR2(2)
  • BASKET_SEQ — NUMBER
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • DEFAULT_SET1_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET2_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET3_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET4_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET5_YN — VARCHAR2(1) — NOT NULL
  • COMPONENT_ID — VARCHAR2(20)
  • DEFAULT_SET6_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET7_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET8_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET9_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET10_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET11_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET12_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET13_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET14_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET15_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET16_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET17_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET18_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET19_YN — VARCHAR2(1) — NOT NULL
  • DEFAULT_SET20_YN — VARCHAR2(1) — NOT NULL

FWK_CMS_TARGET_SETTINGS

  • TARGET_CD — VARCHAR2(5) — NOT NULL
  • TARGET_NAME — VARCHAR2(50)
  • CREATE_DATE — VARCHAR2(8)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • USE_YN — VARCHAR2(1)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • TARGET_ICON1 — VARCHAR2(200)
  • TARGET_ICON2 — VARCHAR2(200)

FWK_CMS_TARGET_THEME_MAP

  • TARGET_CD — VARCHAR2(5) — NOT NULL
  • THEME_ID — VARCHAR2(20) — NOT NULL
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)

FWK_CMS_THEME

  • THEME_ID — VARCHAR2(20) — NOT NULL
  • THEME_NAME — VARCHAR2(300)
  • THEME_THUMBNAIL — VARCHAR2(200)
  • CREATE_USER_ID — VARCHAR2(10)
  • CREATE_USER_NAME — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • USE_YN — VARCHAR2(1)
  • CREATE_DATE — VARCHAR2(8)
  • BEGINNING_DATE — VARCHAR2(8)
  • EXPIRED_DATE — VARCHAR2(8)

FWK_CMS_THEME_COMPO_MAP

  • THEME_ID — VARCHAR2(20) — NOT NULL
  • BASKET_SEQ — NUMBER — NOT NULL
  • COMPONENT_ID — VARCHAR2(20)
  • RANK_CD — VARCHAR2(2)
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)

FWK_CODE

  • CODE_GROUP_ID — VARCHAR2(8) — NOT NULL
  • CODE — VARCHAR2(50) — NOT NULL
  • CODE_NAME — VARCHAR2(100) — NOT NULL
  • CODE_DESC — VARCHAR2(200)
  • SORT_ORDER — NUMBER(4) — NOT NULL
  • USE_YN — VARCHAR2(1) — NOT NULL
  • CODE_ENGNAME — VARCHAR2(300)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)

FWK_CODE_GROUP

  • CODE_GROUP_ID — VARCHAR2(8) — NOT NULL
  • CODE_GROUP_NAME — VARCHAR2(100) — NOT NULL
  • CODE_GROUP_DESC — VARCHAR2(200)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • BIZ_GROUP_ID — VARCHAR2(20)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)

FWK_CODE_GROUP_HISTORY

  • CODE_GROUP_ID — VARCHAR2(8) — NOT NULL
  • CODE_GROUP_NAME — VARCHAR2(50) — NOT NULL
  • CODE_GROUP_DESC — VARCHAR2(200)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • VERSION — NUMBER(3) — NOT NULL
  • HISTORY_REASON — VARCHAR2(100)

FWK_CODE_HISTORY

  • CODE_GROUP_ID — VARCHAR2(8) — NOT NULL
  • CODE — VARCHAR2(30) — NOT NULL
  • CODE_NAME — VARCHAR2(50) — NOT NULL
  • CODE_DESC — VARCHAR2(200)
  • SORT_ORDER — NUMBER(4) — NOT NULL
  • USE_YN — VARCHAR2(1) — NOT NULL
  • CODE_ENGNAME — VARCHAR2(100)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • VERSION — NUMBER(3) — NOT NULL

FWK_COMMON_MESSAGE_FIELD

  • DEVICE_ID — VARCHAR2(50) — NOT NULL
  • LOCALE_CODE — VARCHAR2(10) — NOT NULL
  • COM_MESSAGE_ID — VARCHAR2(50) — NOT NULL
  • COM_MESSAGE_VALUE — VARCHAR2(500)
  • COM_MESSAGE_DESC — VARCHAR2(200)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • COM_MESSAGE_ETC1 — VARCHAR2(50)
  • COM_MESSAGE_ETC2 — VARCHAR2(50)

FWK_COMPONENT

  • COMPONENT_ID — VARCHAR2(50) — NOT NULL
  • COMPONENT_NAME — VARCHAR2(100) — NOT NULL
  • COMPONENT_DESC — VARCHAR2(300)
  • COMPONENT_TYPE — VARCHAR2(1) — NOT NULL
  • COMPONENT_CLASS_NAME — VARCHAR2(100) — NOT NULL
  • COMPONENT_METHOD_NAME — VARCHAR2(50) — NOT NULL
  • COMPONENT_CREATE_TYPE — VARCHAR2(1)
  • BIZ_GROUP_ID — VARCHAR2(20)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS — )
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • USE_YN — VARCHAR2(1)

FWK_COMPONENT_HISTORY

  • COMPONENT_ID — VARCHAR2(50) — NOT NULL
  • COMPONENT_NAME — VARCHAR2(50) — NOT NULL
  • COMPONENT_DESC — VARCHAR2(200)
  • COMPONENT_TYPE — VARCHAR2(1) — NOT NULL
  • COMPONENT_CLASS_NAME — VARCHAR2(100) — NOT NULL
  • COMPONENT_METHOD_NAME — VARCHAR2(50) — NOT NULL
  • COMPONENT_CREATE_TYPE — VARCHAR2(1)
  • BIZ_GROUP_ID — VARCHAR2(20)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS — )
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • USE_YN — VARCHAR2(1)
  • VERSION — NUMBER(3) — NOT NULL
  • HISTORY_REASON — VARCHAR2(100)

FWK_COMPONENT_PARAM

  • COMPONENT_ID — VARCHAR2(50) — NOT NULL
  • PARAM_SEQ_NO — NUMBER(8) — NOT NULL
  • PARAM_KEY — VARCHAR2(100) — NOT NULL
  • PARAM_DESC — VARCHAR2(300)
  • DEFAULT_PARAM_VALUE — VARCHAR2(500)

FWK_COMPONENT_PARAM_HISTORY

  • COMPONENT_ID — VARCHAR2(50) — NOT NULL
  • PARAM_SEQ_NO — NUMBER(8) — NOT NULL
  • PARAM_KEY — VARCHAR2(50) — NOT NULL
  • PARAM_DESC — VARCHAR2(200)
  • DEFAULT_PARAM_VALUE — VARCHAR2(500)
  • VERSION — NUMBER(3) — NOT NULL

FWK_CONTEXT_MONITOR

  • BASE_DATE — VARCHAR2(8)
  • YYYYMMDD) — NOT — NOT NULL
  • BASE_TIME — VARCHAR2(4)
  • HH24MI) — NOT — NOT NULL
  • CONTEXT_ID — VARCHAR2(100) — NOT NULL
  • ACTION_TOT_TIME — NUMBER(10) — NOT NULL
  • ACTION_DBIO_TIME — NUMBER(10) — NOT NULL
  • ACTION_DBIO_COUNT — NUMBER(5) — NOT NULL
  • LOOKUP_TIME — NUMBER(10) — NOT NULL
  • LOOKUP_COUNT — NUMBER(5) — NOT NULL
  • BIZ_TOT_TIME — NUMBER(10) — NOT NULL
  • BIZ_DB_R_TIME — NUMBER(10) — NOT NULL
  • BIZ_DB_R_COUNT — NUMBER(5) — NOT NULL
  • BIZ_DB_W_TIME — NUMBER(10) — NOT NULL
  • BIZ_DB_W_COUNT — NUMBER(5) — NOT NULL
  • BIZ_MSG_TIME — NUMBER(10) — NOT NULL
  • BIZ_MSG_COUNT — NUMBER(5) — NOT NULL
  • RES_TOT_TIME — NUMBER(10) — NOT NULL
  • TOT_TIME — NUMBER(10) — NOT NULL
  • EXE_COUNT — NUMBER(10) — NOT NULL
  • MIN_TIME — NUMBER(10) — NOT NULL
  • MAX_TIME — NUMBER(10) — NOT NULL
  • MAX_TRACE_ID — VARCHAR2(500)
  • WAS_ID — VARCHAR2(4) — NOT NULL

FWK_CUST_MENU

  • MENU_ID — VARCHAR2(40) — NOT NULL
  • PRIOR_MENU_ID — VARCHAR2(40) — NOT NULL
  • SORT_ORDER — NUMBER(3) — NOT NULL
  • KOR_MENU_NAME — VARCHAR2(70) — NOT NULL
  • MENU_URL — VARCHAR2(200) — NOT NULL
  • DISPLAY_YN — VARCHAR2(1) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • NAVI_TXT — VARCHAR2(1500)
  • MENU_LEVEL — NUMBER(3) — NOT NULL
  • SUB_CH_ID — VARCHAR2(10)
  • ENG_MENU_NAME — VARCHAR2(100)
  • DYNAMIC_DISPLAY_VAR_NAME — VARCHAR2(20)
  • LANGUAGE — VARCHAR2(3)
  • CUST_TYPE — VARCHAR2(1)
  • HTTP_MENU_URL — VARCHAR2(200)
  • LEFT_HIGHLIGHT_MENU_ID — VARCHAR2(40)
  • ENCRYPTION_YN — VARCHAR2(1)
  • ENG_NAVI_TXT — VARCHAR2(1500)
  • LOGIN_STATUS — VARCHAR2(1)
  • DELETE_YN — VARCHAR2(1)
  • MENU_AUTH — VARCHAR2(50)
  • LINK_MENU — VARCHAR2(200)

FWK_CUST_MENU_APP

  • MENU_URL — VARCHAR2(200) — NOT NULL
  • WEB_APP_ID — VARCHAR2(100) — NOT NULL
  • MENU_NAME — VARCHAR2(50)
  • MENU_ID — VARCHAR2(40) — NOT NULL
  • ASYNC_YN — VARCHAR2(1) — NOT NULL
  • START_TIME — VARCHAR2(4) — NOT NULL
  • END_TIME — VARCHAR2(4) — NOT NULL
  • TIME_CHECK_YN — VARCHAR2(1) — NOT NULL
  • BIZ_DAY_CHECK_YN — VARCHAR2(1) — NOT NULL
  • LOG_YN — VARCHAR2(1) — NOT NULL
  • VALIDATION_MESSAGE_ID — VARCHAR2(50)
  • LOGIN_ONLY_YN — VARCHAR2(1)
  • SECURE_SIGN_YN — VARCHAR2(1)
  • BANK_STATUS_CHECK_YN — VARCHAR2(1)
  • BANK_CODE_FIELD — VARCHAR2(30)
  • USE_YN — VARCHAR2(1)
  • ENCRIPTION_YN — VARCHAR2(1)
  • E_CHANNEL_CODE — VARCHAR2(1)
  • BIZ_DOMAIN — VARCHAR2(10)
  • BIZ_GROUP_ID — VARCHAR2(20)
  • APP_TYPE — VARCHAR2(10)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • STOP_REASON_KO — VARCHAR2(4000)
  • STOP_REASON_EN — VARCHAR2(4000)
  • URL_PATTERN — VARCHAR2(10)
  • INPUT_TYPE — VARCHAR2(1)
  • WARNING_KO — VARCHAR2(4000)
  • WARNING_EN — VARCHAR2(4000)
  • CRM_LOG_TYPE1 — VARCHAR2(2)
  • CRM_LOG_TYPE2 — VARCHAR2(2)
  • CRM_LOG_TYPE3 — VARCHAR2(2)
  • HDAY_START_TIME — VARCHAR2(4)
  • HDAY_END_TIME — VARCHAR2(4)
  • ECRM_DESC — VARCHAR2(400)
  • VIEW_YN — VARCHAR2(1)
  • IN_OUT_USE_YN — VARCHAR2(1)
  • IN_OUT_MESSAGE_ID — VARCHAR2(50)
  • WARNING_START_DTIME — VARCHAR2(14)
  • WARNING_END_DTIME — VARCHAR2(14)
  • STOP_REASON_START_DTIME — VARCHAR2(14)
  • STOP_REASON_END_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)
  • PRIOR_MENU_ID — VARCHAR2(40)
  • SORT_ORDER — NUMBER
  • PAGE_YN — VARCHAR2(1)
  • TYPE_CHECK_YN — VARCHAR2(1)
  • NOTIFY_NAME — VARCHAR2(500)
  • ALTER_RESPONSE — CLOB
  • DISPLAY_YN — VARCHAR2(1)

FWK_CUST_MENU_APP2

  • MENU_URL — VARCHAR2(200) — NOT NULL
  • MENU_NAME — VARCHAR2(50)
  • PRIOR_MENU_ID — VARCHAR2(40)
  • MENU_ID — VARCHAR2(40) — NOT NULL
  • START_TIME — VARCHAR2(4)
  • END_TIME — VARCHAR2(4)
  • TIME_CHECK_YN — VARCHAR2(1)
  • BIZ_DAY_CHECK_YN — VARCHAR2(1)
  • VALIDATION_MESSAGE_ID — VARCHAR2(50)
  • LOGIN_ONLY_YN — VARCHAR2(1)
  • SECURE_SIGN_YN — VARCHAR2(1)
  • USE_YN — VARCHAR2(1)
  • ENCRIPTION_YN — VARCHAR2(1)
  • BIZ_DOMAIN — VARCHAR2(10)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • STOP_REASON_KO — VARCHAR2(4000)
  • STOP_REASON_EN — VARCHAR2(4000)
  • URL_PATTERN — VARCHAR2(10)
  • INPUT_TYPE — VARCHAR2(1)
  • WARNING_KO — VARCHAR2(4000)
  • WARNING_EN — VARCHAR2(4000)
  • HDAY_START_TIME — VARCHAR2(4)
  • HDAY_END_TIME — VARCHAR2(4)
  • DISPLAY_YN — VARCHAR2(1)
  • WARNING_START_DTIME — VARCHAR2(14)
  • WARNING_END_DTIME — VARCHAR2(14)
  • STOP_REASON_START_DTIME — VARCHAR2(14)
  • STOP_REASON_END_DTIME — VARCHAR2(14)

FWK_CUST_MENU_APP_HISTORY

  • MENU_URL — VARCHAR2(200) — NOT NULL
  • WEB_APP_ID — VARCHAR2(100) — NOT NULL
  • MENU_NAME — VARCHAR2(50)
  • MENU_ID — VARCHAR2(40) — NOT NULL
  • ASYNC_YN — VARCHAR2(1) — NOT NULL
  • START_TIME — VARCHAR2(4) — NOT NULL
  • END_TIME — VARCHAR2(4) — NOT NULL
  • TIME_CHECK_YN — VARCHAR2(1) — NOT NULL
  • BIZ_DAY_CHECK_YN — VARCHAR2(1) — NOT NULL
  • LOG_YN — VARCHAR2(1) — NOT NULL
  • VALIDATION_MESSAGE_ID — VARCHAR2(50)
  • LOGIN_ONLY_YN — VARCHAR2(1)
  • SECURE_SIGN_YN — VARCHAR2(1)
  • BANK_STATUS_CHECK_YN — VARCHAR2(1)
  • BANK_CODE_FIELD — VARCHAR2(30)
  • USE_YN — VARCHAR2(1)
  • ENCRIPTION_YN — VARCHAR2(1)
  • E_CHANNEL_CODE — VARCHAR2(1)
  • BIZ_DOMAIN — VARCHAR2(10)
  • BIZ_GROUP_ID — VARCHAR2(20)
  • APP_TYPE — VARCHAR2(10)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • STOP_REASON_KO — VARCHAR2(300)
  • STOP_REASON_EN — VARCHAR2(300)
  • URL_PATTERN — VARCHAR2(10)
  • INPUT_TYPE — VARCHAR2(1)
  • WARNING_KO — VARCHAR2(300)
  • WARNING_EN — VARCHAR2(300)
  • CRM_LOG_TYPE1 — VARCHAR2(2)
  • CRM_LOG_TYPE2 — VARCHAR2(2)
  • CRM_LOG_TYPE3 — VARCHAR2(2)
  • HDAY_START_TIME — VARCHAR2(4) — NOT NULL
  • HDAY_END_TIME — VARCHAR2(4) — NOT NULL
  • ECRM_DESC — VARCHAR2(400)
  • IN_OUT_USE_YN — VARCHAR2(1)
  • IN_OUT_MESSAGE_ID — VARCHAR2(50)
  • VERSION — NUMBER(3) — NOT NULL
  • HISTORY_REASON — VARCHAR2(100)
  • WARNING_START_DTIME — VARCHAR2(14)
  • WARNING_END_DTIME — VARCHAR2(14)
  • STOP_REASON_START_DTIME — VARCHAR2(14)
  • STOP_REASON_END_DTIME — VARCHAR2(14)

FWK_CUST_MENU_HISTORY

  • MENU_ID — VARCHAR2(40) — NOT NULL
  • PRIOR_MENU_ID — VARCHAR2(40) — NOT NULL
  • SORT_ORDER — NUMBER(3) — NOT NULL
  • KOR_MENU_NAME — VARCHAR2(70) — NOT NULL
  • MENU_URL — VARCHAR2(200) — NOT NULL
  • DISPLAY_YN — VARCHAR2(1) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • NAVI_TXT — VARCHAR2(1500)
  • MENU_LEVEL — NUMBER(3) — NOT NULL
  • SUB_CH_ID — VARCHAR2(10) — NOT NULL
  • ENG_MENU_NAME — VARCHAR2(100)
  • DYNAMIC_DISPLAY_VAR_NAME — VARCHAR2(20)
  • LANGUAGE — VARCHAR2(3)
  • CUST_TYPE — VARCHAR2(1)
  • HTTP_MENU_URL — VARCHAR2(200)
  • LEFT_HIGHLIGHT_MENU_ID — VARCHAR2(40)
  • ENCRYPTION_YN — VARCHAR2(1)
  • ENG_NAVI_TXT — VARCHAR2(1500)
  • LOGIN_STATUS — VARCHAR2(1) — NOT NULL
  • VERSION — NUMBER(3) — NOT NULL
  • HISTORY_REASON — VARCHAR2(100)

FWK_DEMO_ASSET_OWNER_MAP

  • ASSET_ID — VARCHAR2(50) — NOT NULL
  • OWNER_DEPT_CODE — VARCHAR2(15) — NOT NULL
  • LAST_MODIFIER_ID — VARCHAR2(10)
  • LAST_MODIFIED_DTIME — VARCHAR2(14)
  • OWNER_HEAD_BRANCH_CODE — VARCHAR2(4)

FWK_DIGITAL_ASSET

  • ASSET_ID — VARCHAR2(50) — NOT NULL
  • ASSET_NAME — VARCHAR2(50)
  • ASSET_TYPE — VARCHAR2(10)
  • ASSET_CATEGORY — VARCHAR2(10)
  • ASSET_PATH_URL — VARCHAR2(300)
  • ASSET_DESC — VARCHAR2(2000)
  • ASSET_ETC — VARCHAR2(2000)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL

FWK_ERROR

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • TRX_ID — VARCHAR2(40)
  • ERROR_TITLE — VARCHAR2(200) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • ORG_ID — VARCHAR2(10)
  • ORG_ERROR_CODE — VARCHAR2(20)
  • ERROR_LEVEL — VARCHAR2(1) — NOT NULL
  • ERROR_HTTPCODE — VARCHAR2(20)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)

FWK_ERROR_DESC

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • LOCALE_CODE — VARCHAR2(5) — NOT NULL
  • ERROR_TITLE — VARCHAR2(200)
  • PB_ERROR_TITLE — VARCHAR2(400)
  • ETC_ERROR_TITLE — VARCHAR2(400)
  • ERROR_CAUSE_DESC — VARCHAR2(1600)
  • ERROR_GUIDE_DESC — VARCHAR2(1600)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • HELP_PAGE_URL — VARCHAR2(200)
  • IBS_ERROR_GUIDE_DESC — VARCHAR2(1600)
  • CMS_ERROR_GUIDE_DESC — VARCHAR2(1600)
  • ETC_ERROR_GUIDE_DESC — VARCHAR2(1600)
  • FINAL_APPROVAL_STATE — VARCHAR2(1)
  • FINAL_APPROVAL_DTIME — VARCHAR2(14)
  • FINAL_APPROVAL_USER_ID — VARCHAR2(20)
  • FINAL_APPROVAL_USER_NAME — VARCHAR2(50)

FWK_ERROR_DESC_HISTORY

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • LOCALE_CODE — VARCHAR2(5) — NOT NULL
  • ERROR_TITLE — NVARCHAR2(400)
  • PB_ERROR_TITLE — VARCHAR2(400)
  • ETC_ERROR_TITLE — VARCHAR2(400)
  • ERROR_CAUSE_DESC — NVARCHAR2(3200)
  • ERROR_GUIDE_DESC — NVARCHAR2(3200)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • HELP_PAGE_URL — VARCHAR2(200)
  • IBS_ERROR_GUIDE_DESC — NVARCHAR2(3200)
  • CMS_ERROR_GUIDE_DESC — NVARCHAR2(3200)
  • ETC_ERROR_GUIDE_DESC — NVARCHAR2(3200)
  • VERSION — NUMBER(3) — NOT NULL

FWK_ERROR_HANDLE_APP

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • HANDLE_APP_ID — VARCHAR2(50) — NOT NULL
  • USER_PARAM_VALUE — VARCHAR2(1000)

FWK_ERROR_HANDLE_HIS

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • HANDLE_APP_ID — VARCHAR2(50) — NOT NULL
  • ERROR_SER_NO — VARCHAR2(28) — NOT NULL
  • ERROR_HANDLE_DTIME — VARCHAR2(14) — NOT NULL
  • ERROR_HANDLE_RT_CODE — VARCHAR2(8) — NOT NULL
  • ERROR_HANDLE_TEXT — VARCHAR2(2000)

FWK_ERROR_HIS

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • ERROR_SER_NO — VARCHAR2(28) — NOT NULL
  • CUST_USER_ID — VARCHAR2(20) — NOT NULL
  • ERROR_MESSAGE — VARCHAR2(500)
  • ERROR_OCCUR_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • ERROR_URL — VARCHAR2(300)
  • ERROR_TRACE — VARCHAR2(4000)
  • ERROR_INSTANCE_ID — VARCHAR2(10)

FWK_ERROR_HISTORY

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • TRX_ID — VARCHAR2(40)
  • ERROR_TITLE — VARCHAR2(200) — NOT NULL
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • YYYYMMDDHH24MISS) — NOT — NOT NULL
  • LAST_UPDATE_USER_ID — VARCHAR2(20) — NOT NULL
  • ORG_ID — VARCHAR2(10)
  • ORG_ERROR_CODE — VARCHAR2(20)
  • ERROR_LEVEL — VARCHAR2(1) — NOT NULL
  • VERSION — NUMBER(3) — NOT NULL
  • HISTORY_REASON — VARCHAR2(100)

FWK_ERROR_HIS_STATS

  • ERROR_CODE — VARCHAR2(40) — NOT NULL
  • ERROR_OCCUR_DAY — VARCHAR2(8) — NOT NULL
  • ERROR_URL — VARCHAR2(300) — NOT NULL
  • ERROR_MESSAGE — VARCHAR2(500) — NOT NULL
  • ERROR_TRACE — VARCHAR2(4000)
  • BIZ_DOMAIN — VARCHAR2(10)
  • ERROR_CNT — NUMBER
  • ERROR_MENU_NAME — VARCHAR2(100)
  • ERROR_ETC — VARCHAR2(50)

FWK_FDS_ACCIDENT_CASE_INSTANCE

  • MESSAGE_SNO — VARCHAR2(50) — NOT NULL
  • TRX_ID — VARCHAR2(40) — NOT NULL
  • ORG_ID — VARCHAR2(10) — NOT NULL
  • IO_TYPE — VARCHAR2(1) — NOT NULL
  • REQ_RES_TYPE — VARCHAR2(1) — NOT NULL
  • MESSAGE_ID — VARCHAR2(50) — NOT NULL
  • TRX_TRACKING_NO — VARCHAR2(30) — NOT NULL
  • USER_ID — VARCHAR2(20) — NOT NULL
  • LOG_DTIME — VARCHAR2(17) — NOT NULL
  • LAST_LOG_DTIME — VARCHAR2(17) — NOT NULL
  • LAST_RT_CODE — VARCHAR2(40) — NOT NULL
  • INSTANCE_ID — VARCHAR2(4) — NOT NULL
  • RETRY_TRX_YN — VARCHAR2(1) — NOT NULL
  • MESSAGE_DATA — VARCHAR2(4000) — NOT NULL
  • TRX_DTIME — VARCHAR2(14)
  • CHANNEL_TYPE — VARCHAR2(10) — NOT NULL
  • URI — VARCHAR2(200)
  • LOG_DATA — CLOB
  • FDS_TRX_SNO — VARCHAR2(50)
  • FDS_TRX_TRACKING_NO — VARCHAR2(50)
  • DETECT_RULE_GROUP_ID — VARCHAR2(50)
  • DETECT_RULE_GROUP_GRADE — VARCHAR2(50)
  • DETECT_SCORE — NUMBER(3)
  • DETECT_IP — VARCHAR2(50)
  • DETECT_MAC — VARCHAR2(50)
  • DETECT_HDD — VARCHAR2(50)
  • DETECT_ACCOUNT — VARCHAR2(24)
  • DETECT_ACCOUNT_SNO — VARCHAR2(50)
  • DETECT_DEPOSIT_ACCOUNT — VARCHAR2(24)
  • DETECT_DEPOSIT_ACCOUNT_SNO — VARCHAR2(50)
  • DETECT_DEPOSIT_ACCOUNT_NAME — VARCHAR2(20)
  • DETECT_TRX_AMOUNT — NUMBER(20,3)
  • DETECT_BALANCE — NUMBER(20,3)
  • FDS_RES_CODE — VARCHAR2(40)
  • FDS_ERR_CODE — VARCHAR2(40)
  • FDS_TYPE_CODE — VARCHAR2(40)
  • FDS_REASON — VARCHAR2(4000)
  • FDS_DEVICE_TYPE — VARCHAR2(10)
  • USER_NAME — VARCHAR2(20)
  • ACCIDENT_CASE_INSTANCE_YEAR — VARCHAR2(10)

FWK_FDS_ACCOUNT_PROFILE

  • ACCOUNT_ID — VARCHAR2(30) — NOT NULL
  • ACCOUNT_NO — VARCHAR2(30)
  • CUST_ID — VARCHAR2(30)
  • REG_DATETIME — DATE
  • UPD_DATETIME — DATE
  • ACCOUNT_OPEN_DATETIME — DATE
  • FIRST_TRN_DATETIME — DATE
  • LAST_TRN_AMNT — NUMBER
  • SAME_TRN_AMNT_CNT — NUMBER
  • TDAY_TRN_CNT — NUMBER

FWK_FDS_ACCT_DELAY_TRX_MONITOR

  • DETECT_ACCOUNT — VARCHAR2(30) — NOT NULL
  • DETECT_ACCOUNT_SNO — VARCHAR2(10) — NOT NULL
  • TRX_RES_CODE — VARCHAR2(2)
  • FDS_TYPE_CODE — VARCHAR2(2)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • FIRST_UPDATE_USER_ID — VARCHAR2(20)
  • FIRST_UPDATE_DTIME — VARCHAR2(14)
  • ACCOUNT_STATE — VARCHAR2(2)
  • TRX_DAY — VARCHAR2(8)
  • TRX_DTIME — VARCHAR2(6)
  • TRX_AMOUNT — NUMBER(20,3)
  • FWK_FDS_ACCT_DELAY_TRX_MONITOR — VARCHAR2(10)
  • ACCOUNT_OWNER_ID — VARCHAR2(20)
  • ACCOUNT_OWNER_NAME — VARCHAR2(20)
  • DETECT_MAC — VARCHAR2(50)

FWK_FDS_ACCT_DELAY_TRX_MON_HIS

  • DETECT_ACCOUNT — VARCHAR2(30) — NOT NULL
  • DETECT_ACCOUNT_SNO — VARCHAR2(10) — NOT NULL
  • HIS_SEQ — NUMBER — NOT NULL
  • TRX_RES_CODE — VARCHAR2(2)
  • FDS_TYPE_CODE — VARCHAR2(2)
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • FIRST_UPDATE_USER_ID — VARCHAR2(20)
  • FIRST_UPDATE_DTIME — VARCHAR2(14)
  • ACCOUNT_STATE — VARCHAR2(2)
  • TRX_DAY — VARCHAR2(8)
  • TRX_DTIME — VARCHAR2(6)
  • FDS_TRX_TRACKING_NO — VARCHAR2(50)
  • TRX_TRACKING_NO — VARCHAR2(30)
  • FDS_DEVICE_TYPE — VARCHAR2(10)
  • TRX_AMOUNT — NUMBER(20,3)
  • FWK_FDS_ACCT_DELAY_TRX_MONITOR — VARCHAR2(10)
  • ACCOUNT_OWNER_ID — VARCHAR2(20)
  • ACCOUNT_OWNER_NAME — VARCHAR2(20)
  • DETECT_MAC — VARCHAR2(50)

FWK_FDS_ACCT_STOP_PAYMENT_HIS

  • DETECT_TYPE — VARCHAR2(10) — NOT NULL
  • ACCOUNT_NUMBER — VARCHAR2(30) — NOT NULL
  • CALLBACK_SEQ — NUMBER — NOT NULL
  • MONITOR_PROCESS_PATH — VARCHAR2(3)
  • STOP_REASON — VARCHAR2(3)
  • ACCOUNT_REPORT_CONTENTS — VARCHAR2(300)
  • MONITOR_BUSINESS_STATE_TYPE — VARCHAR2(3)
  • LAST_UPDATE_USER_ID — VARCHAR2(30)
  • LAST_UPDATE_DTIME — VARCHAR2(14)

FWK_FDS_ACCT_TRX_MONITOR

  • TRX_SEQ — NUMBER(10) — NOT NULL
  • ACCOUNT_NUMBER — VARCHAR2(30) — NOT NULL
  • ACCOUNT_OWNER_NAME — VARCHAR2(20)
  • MONITOR_TYPE — VARCHAR2(2)
  • TRX_DAY — VARCHAR2(8)
  • TRX_TIME — VARCHAR2(6)
  • ACCOUNT_LOCK_STATE — VARCHAR2(5)
  • LAST_UPDATE_USER_ID — VARCHAR2(30)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • ACCOUNT_TRX_MONITOR_YEAR — VARCHAR2(10)
  • DETECT_TYPE — VARCHAR2(10) — NOT NULL
  • FDS_TYPE_CODE — VARCHAR2(40)
  • TRX_AMOUNT — NUMBER(20, 3)
  • FDS_REASON — VARCHAR2(4000)
  • CONFIRM_FLAG — VARCHAR2(1)
  • CONFIRM_UPDATE_USER_ID — VARCHAR2(30)
  • CONFIRM_UPDATE_DTIME — VARCHAR2(14)
  • AUDIT_BUSINESS_TYPE — VARCHAR2(5)
  • AUDIT_ACCIDENT_TYPE — VARCHAR2(5)
  • AUDIT_BUSINESS_STATE_TYPE — VARCHAR2(3)
  • AUDIT_RETURN_YN — VARCHAR2(2)
  • AUDIT_OTHER_BANK_NOTICE — VARCHAR2(2)
  • AUDIT_FRAUD_AMOUNT — NUMBER(20, 3)
  • AUDIT_PREVENT_AMOUNT — NUMBER(20, 3)
  • AUDIT_IN_ACC_BANK_CODE — VARCHAR2(3)
  • AUDIT_IN_ACC_NUM — VARCHAR2(30)
  • AUDIT_COMMENT — VARCHAR2(500) — ARCHAR2(500
  • ACCOUNT_OWNER_NUMBER — VARCHAR2(30)
  • AUDIT_TRX_AMOUNT — NUMBER(20, 3)
  • AUDIT_REPORT_CONTENTS — VARCHAR2(300)
  • AUDIT_REPORT_TITLE — VARCHAR2(50)
  • ACCOUNT_OWNER_ID — VARCHAR2(20)
  • DETECT_MAC — VARCHAR2(50)
  • DETECT_IP — VARCHAR2(50)
  • IN_BANK_CODE — VARCHAR2(5)
  • IN_ACCT_NUMBER — VARCHAR2(30)
  • IN_CUSTOMER — VARCHAR2(20)
  • CALLBACK_MANAGEMENT_ID — VARCHAR2(30)
  • CALLBACK_ALERT_TIME — VARCHAR2(14)
  • MONITOR_BUSINESS_STATE_TYPE — VARCHAR2(3)

FWK_FDS_ACCT_TRX_MONITOR_HIS

  • TRX_SEQ — NUMBER(10) — NOT NULL
  • ACCOUNT_NUMBER — VARCHAR2(30) — NOT NULL
  • HIS_SEQ — NUMBER — NOT NULL
  • ACCOUNT_LOCK_STATE — VARCHAR2(5)
  • LAST_UPDATE_USER_ID — VARCHAR2(30)
  • LAST_UPDATE_DTIME — VARCHAR2(14)
  • TRX_TRACKING_NO — VARCHAR2(30)
  • ACCOUNT_TRX_MONITOR_HIS_YEAR — VARCHAR2(10)
  • DETECT_TYPE — VARCHAR2(10) — NOT NULL
  • FDS_TRX_TRACKING_NO — VARCHAR2(50)
  • FDS_TYPE_CODE — VARCHAR2(40)
  • FDS_DEVICE_TYPE — VARCHAR2(10)
  • FDS_REASON — VARCHAR2(4000)
  • AUDIT_BUSINESS_TYPE — VARCHAR2(5)
  • AUDIT_ACCIDENT_TYPE — VARCHAR2(5)
  • AUDIT_BUSINESS_STATE_TYPE — VARCHAR2(3)
  • AUDIT_RETURN_YN — VARCHAR2(2)
  • AUDIT_OTHER_BANK_NOTICE — VARCHAR2(2)
  • AUDIT_FRAUD_AMOUNT — NUMBER(20, 3)
  • AUDIT_PREVENT_AMOUNT — NUMBER(20, 3)
  • AUDIT_IN_ACC_BANK_CODE — VARCHAR2(3)
  • AUDIT_IN_ACC_NUM — VARCHAR2(30)
  • AUDIT_COMMENT — VARCHAR2(500) — ARCHAR2(500
  • ACCOUNT_OWNER_NUMBER — VARCHAR2(30)
  • AUDIT_TRX_AMOUNT — NUMBER(20, 3)
  • AUDIT_REPORT_CONTENTS — VARCHAR2(300)
  • AUDIT_REPORT_TITLE — VARCHAR2(50)
  • ACCOUNT_OWNER_ID — VARCHAR2(20)
  • DETECT_MAC — VARCHAR2(50)
  • DETECT_IP — VARCHAR2(50)
  • IN_BANK_CODE — VARCHAR2(5)
  • IN_ACCT_NUMBER — VARCHAR2(30)
  • IN_CUSTOMER — VARCHAR2(20)

FWK_FDS_ARGS_INFO

  • SEQ — NUMBER — NOT NULL
  • ARG_ID — VARCHAR2(50) — NOT NULL
  • ARG_GB — VARCHAR2(1) — NOT NULL
  • ARG_NAME — VARCHAR2(50)
  • ARG_TYPE — VARCHAR2(10)
  • REFID — VARCHAR2(50)
  • ARG_VALUE — NUMBER
  • TABLE_ID — VARCHAR2(30) — NOT NULL
  • TYPE — VARCHAR2(20)

FWK_FDS_BLOCK

  • BLOCK_UNUM — NUMBER — NOT NULL
  • REG_CHANNEL — VARCHAR2(10)
  • REG_DATE — DATE
  • REG_ID — VARCHAR2(20)
  • BLOCK_TARGET — VARCHAR2(20)
  • BLOCK_ID — VARCHAR2(30)
  • BLOCK_IP — VARCHAR2(30)
  • BLOCK_MAC_NUM — VARCHAR2(30)
  • BLOCK_HDD_NUM — VARCHAR2(30)
  • BLOCK_ACC1 — NUMBER
  • BLOCK_ACC2 — NUMBER
  • BLOCK_STATE — VARCHAR2(10)

FWK_FDS_BLOCK_ACCOUNT

  • BLOCK_ACC_ID — VARCHAR2(20) — NOT NULL
  • ACC_NUMBER — VARCHAR2(30)
  • BLOCK_ACC_GROUP_ID — VARCHAR2(10)
  • LAST_UPDATE_DTIME — DATE
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • USE_YN — VARCHAR2(2)
  • START_DTIME — VARCHAR2(14)
  • END_DTIME — VARCHAR2(14)

FWK_FDS_BLOCK_DEVICE

  • BLOCK_DEVICE_ID — VARCHAR2(20) — NOT NULL
  • DEVICE_TYPE_ID — VARCHAR2(20)
  • DEVICE_VALUE — VARCHAR2(200)
  • BLOCK_DEVICE_GROUP_ID — VARCHAR2(10)
  • LAST_UPDATE_DTIME — DATE
  • LAST_UPDATE_USER_ID — VARCHAR2(20)
  • USE_YN — VARCHAR2(2)
  • START_DTIME — VARCHAR2(14)
  • END_DTIME — VARCHAR2(14)

and 165 more tables