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