마이그레이션
테이블 (145)
ADMIN_AUTH
- ADMIN_NO — NUMBER(20,0) — NOT NULL
- MENU_CODE — VARCHAR2(20) — NOT NULL
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- MENU_CODE) — PCTFREE
ADMIN_MANAGER
- ADMIN_NO — NUMBER(*,0)
- ADMINTYPE — VARCHAR2(10)
- ADMIN_ID — VARCHAR2(50)
- PWD — VARCHAR2(50)
- ADMIN_NAME — VARCHAR2(50)
- EMAIL — VARCHAR2(100)
- TEAMCODE — VARCHAR2(10)
- COMPANYCODE — VARCHAR2(10)
- STATUS — CHAR(1)
- MENU_AUTH — VARCHAR2(50)
- REGIST_DT — DATE
ADMIN_MENU
- MENU_CODE — VARCHAR2(20) — NOT NULL
- PARNTS_MENU_CODE — VARCHAR2(20)
- MENU_LEVEL — VARCHAR2(1)
- MENU_NM — VARCHAR2(200)
- MENU_URL — VARCHAR2(500)
- SORT_ORDR — NUMBER
- USE_AT — CHAR(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
ADMIN_USER
- ADMIN_NO — NUMBER — NOT NULL
- ADMIN_ID — VARCHAR2(50)
- ADMIN_PWD — VARCHAR2(200)
- ADMIN_NM — VARCHAR2(20)
- ADMIN_EMAIL — VARCHAR2(100)
- ADMIN_TEAMCODE — VARCHAR2(200)
- COMPANY_CODE — VARCHAR2(20)
- USE_YN — CHAR(1)
- PWD_UPDT_DT — VARCHAR2(8)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
ALTRTV_INVT
- ALTRTV_NO — NUMBER — NOT NULL
- GUBUN — VARCHAR2(10)
- FUNDNAME — VARCHAR2(200)
- FUND_LOCAL — VARCHAR2(200)
- FUND_SCALE — VARCHAR2(200)
- FUND_TYPE — VARCHAR2(200)
- FUND_MANAGEMENT — VARCHAR2(200)
- RETRIEVAL_YN — VARCHAR2(200)
- VIEW_YN — VARCHAR2(200)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
APPLYINFO
- APPLY_NO — NUMBER(*,0) — NOT NULL
- RECRUIT_NO — NUMBER(*,0)
- CAREER_GUBUN — VARCHAR2(50)
- APPLY_GUBUN — VARCHAR2(50)
- APPLY_DEPT — VARCHAR2(50)
- CAREER_YEARS — VARCHAR2(50)
- HOPE_SALARY — VARCHAR2(20)
- APPLY_NAME — VARCHAR2(20)
- PROFILE_FILE_PATH — VARCHAR2(250)
- PROFILE_P_FILE_NM — VARCHAR2(250)
- JUMIN1 — VARCHAR2(6)
- JUMIN2 — VARCHAR2(7)
- ZIPCODE — VARCHAR2(7)
- ADDR1 — VARCHAR2(500)
- ADDR2 — VARCHAR2(500)
- MOBILE1 — VARCHAR2(4)
- MOBILE2 — VARCHAR2(4)
- MOBILE3 — VARCHAR2(4)
- HOME_TELL1 — VARCHAR2(4)
- HOME_TELL2 — VARCHAR2(4)
- HOME_TELL3 — VARCHAR2(4)
- EMAIL1 — VARCHAR2(200)
- EMAIL2 — VARCHAR2(200)
- BIRTH — VARCHAR2(10)
- RELIGION — VARCHAR2(100)
- HOBBY — VARCHAR2(500)
- ABILITY — VARCHAR2(500)
- APPLY_PWD — VARCHAR2(40)
- HEIGHT — VARCHAR2(100)
- WEIGHT — VARCHAR2(100)
- BLOOD — VARCHAR2(50)
- MARRY_YN — VARCHAR2(20)
- HANDICAP_YN — CHAR(1)
- HANDICAP_DETAIL — VARCHAR2(500)
- CHRONIC — VARCHAR2(500)
- MLT_CLR — VARCHAR2(20)
- HOUSING_TYPE — VARCHAR2(20)
- FAMILYINCOME — VARCHAR2(100)
- POSSESSION — VARCHAR2(250)
- ESTATE — VARCHAR2(250)
- REL_BROTHER1 — VARCHAR2(10)
- REL_BROTHER2 — VARCHAR2(10)
- REL_BROTHER3 — VARCHAR2(10)
- REGIST_DT — DATE
- MODIFY_DT — DATE
- REWARD_YN — CHAR(1)
- REWARD_DETAIL — VARCHAR2(500)
- SUCCESS — CHAR(1)
- PASS_YN — CHAR(1)
APPLY_ADD_FILE
- ADD_FILE_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0) — NOT NULL
- FILE_NAME — VARCHAR2(250)
- SAVE_FOLDER — VARCHAR2(250)
ASSET_BOND
- FUNDCODE — VARCHAR2(10)
- COMPANYNAME — VARCHAR2(50)
- PERCENTAGE — FLOAT(126)
- COMPANYNAME) — PCTFREE
ASSET_INFO
- FUNDCODE — VARCHAR2(5)
- TYP — VARCHAR2(12)
- SECID — VARCHAR2(12)
- SECNM — VARCHAR2(100)
- WG — NUMBER(10,7)
- RNK — NUMBER(5,0)
- BASEDT — VARCHAR2(8)
ASSET_STOCK
- FUNDCODE — VARCHAR2(10)
- COMPANYNAME — VARCHAR2(50)
- PERCENTAGE — FLOAT(126)
- COMPANYNAME) — PCTFREE
AWARDINFO
- AWARD_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0) — NOT NULL
- AWARD_NAME — VARCHAR2(200)
- AWARD_ORG — VARCHAR2(200)
- AWARD_START_YEAR — VARCHAR2(10)
- AWARD_START_MONTH — VARCHAR2(10)
- AWARD_END_YEAR — VARCHAR2(10)
- AWARD_END_MONTH — VARCHAR2(10)
- AWARD_DETAIL — VARCHAR2(500)
BBS
- BBS_NO — NUMBER(*,0)
- BBS_ID — VARCHAR2(10)
- REGISTER_NM — VARCHAR2(20)
- BBS_TITLE — VARCHAR2(200)
- BBS_CONTENTS — CLOB
- BBS_CONTENTS_TEXT — CLOB
- VIEW_YN — CHAR(1)
- DELETE_YN — CHAR(1)
- REGIST_DT — DATE
- MODIFY_DT — DATE
- DELETE_DT — DATE
- FILE_NAME — VARCHAR2(1000)
- SAVE_FOLDER — VARCHAR2(1000)
- BBS_CNT — NUMBER(*,0)
- BBS_RDATE — DATE
BBS_ADD_FILE
- FILE_NO — NUMBER(*,0)
- BBS_NO — NUMBER(*,0)
- FILE_PATH — VARCHAR2(250)
- L_FILE_NM — VARCHAR2(1000)
- P_FILE_NM — VARCHAR2(1000)
- FILE_SIZE — VARCHAR2(100)
BBS_ADD_FILE_20230503
- FILE_NO — NUMBER(*,0)
- BBS_NO — NUMBER(*,0)
- FILE_PATH — VARCHAR2(250)
- L_FILE_NM — VARCHAR2(1000)
- P_FILE_NM — VARCHAR2(1000)
- FILE_SIZE — VARCHAR2(100)
BBS_BACKUP
- BBS_NO — NUMBER(*,0)
- BBS_ID — VARCHAR2(10)
- REGISTER_NM — VARCHAR2(20)
- BBS_TITLE — VARCHAR2(200)
- BBS_CONTENTS — CLOB
- BBS_CONTENTS_TEXT — CLOB
- VIEW_YN — CHAR(1)
- DELETE_YN — CHAR(1)
- REGIST_DT — DATE
- MODIFY_DT — DATE
- DELETE_DT — DATE
- FILE_NAME — VARCHAR2(1000)
- SAVE_FOLDER — VARCHAR2(1000)
- BBS_CNT — NUMBER(*,0)
- BBS_RDATE — DATE
BBS_CONTRIBUTION
- CONTRIBUTION_NO — NUMBER(*,0)
- CONTRIBUTION_ID — VARCHAR2(10)
- REGISTER_NM — VARCHAR2(20)
- TITLE — VARCHAR2(200)
- VIEW_YN — CHAR(1)
- VIEW_COUNT — NUMBER(*,0)
- CONTENTS — CLOB
- CONTENTS_TEXT — CLOB
- USER_SET_DATE — VARCHAR2(10)
- REGIST_DT — DATE
- MODIFY_DT — DATE
BBS_CONTRIBUTION_ADD_FILE
- FILE_NO — NUMBER(*,0)
- CONTRIBUTION_NO — NUMBER(*,0)
- FILE_PATH — VARCHAR2(250)
- L_FILE_NM — VARCHAR2(250)
- P_FILE_NM — VARCHAR2(250)
- FILE_SIZE — VARCHAR2(100)
BBS_SKETCH
- SKETCH_NO — NUMBER(*,0)
- SKETCH_ID — VARCHAR2(10)
- REGISTER_NM — VARCHAR2(20)
- TITLE — VARCHAR2(200)
- SCHEDULE — VARCHAR2(100)
- VIEW_YN — CHAR(1)
- VIEW_COUNT — NUMBER(*,0)
- CONTENTS — CLOB
- CONTENTS_TEXT — CLOB
- USER_SET_DATE — VARCHAR2(10)
- REGIST_DT — DATE
- MODIFY_DT — DATE
BBS_SKETCH_ADD_FILE
- FILE_NO — NUMBER(*,0)
- SKETCH_NO — NUMBER(*,0)
- FILE_PATH — VARCHAR2(250)
- L_FILE_NM — VARCHAR2(250)
- P_FILE_NM — VARCHAR2(250)
- FILE_SIZE — VARCHAR2(100)
CAREERINFO
- CAREER_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0) — NOT NULL
- COMPANY_NAME — VARCHAR2(200)
- WORKPLACE — VARCHAR2(200)
- POSITION — VARCHAR2(100)
- FINAL_SALARY — VARCHAR2(50)
- OPERATION — VARCHAR2(100)
- CAREER_START_YEAR — VARCHAR2(10)
- CAREER_START_MONTH — VARCHAR2(10)
- CAREER_END_YEAR — VARCHAR2(10)
- CAREER_END_MONTH — VARCHAR2(10)
- NOW_WORK_YN — CHAR(1)
- REASON_RETIRE — VARCHAR2(100)
- WORKING_DETAIL — CLOB
CDIT_ETFFUND
- GCODE — VARCHAR2(6) — NOT NULL
- SORT_ORDR — NUMBER
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
CDIT_ETFFUND_BACKUP
- GCODE — VARCHAR2(6) — NOT NULL
- SORT_ORDR — NUMBER
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
CD_INRST
- INRST_DT — VARCHAR2(8) — NOT NULL
- INRST_CD — VARCHAR2(3) — NOT NULL
- INRST_NM — VARCHAR2(100)
- INRST_VAL — NUMBER
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- INRST_CD) — PCTFREE
CHANGE_ASSET_PLAN
- PLAN_DATE — DATE
- FUNDCODE — VARCHAR2(10)
- KOSPI_INDEX — FLOAT(126)
- KOSPI200_INDEX — FLOAT(126)
- FUND_STDPRICE — FLOAT(126)
- EWMA — FLOAT(126)
- TARGET_INVEST_PERCENT — FLOAT(126)
- REAL_INVEST_PERCENT — FLOAT(126)
- GAP — FLOAT(126)
- KOSPI_RATE — FLOAT(126)
- KOSPI200_RATE — FLOAT(126)
- STDPRICE_RATE — FLOAT(126)
- FUNDCODE) — PCTFREE
COMMON_CODE
- GROUPCODE — VARCHAR2(3)
- CODE — VARCHAR2(5)
- CODENAME — VARCHAR2(255)
- SORTNO — VARCHAR2(10)
- EXPLAIN — VARCHAR2(255)
- CODE) — PCTFREE
COMPANY_BOARD
- COM_NO — NUMBER(*,0)
- TITLE — VARCHAR2(500)
- REGIST_ID — VARCHAR2(50)
- CONTENTS — CLOB
- FILE_PATH — VARCHAR2(250)
- L_FILE_NM — VARCHAR2(250)
- P_FILE_NM — VARCHAR2(250)
- REGIST_DT — DATE
- MODIFY_DT — DATE
COMPANY_BOARD_SALES
- COM_NO — NUMBER(*,0)
- COMPANYCODE — VARCHAR2(10)
COMPOSITION_ITEM
- FUNDCODE — VARCHAR2(4) — NOT NULL
- ITEM_GUBUN — VARCHAR2(10) — NOT NULL
- ITEM_CODE — VARCHAR2(12) — NOT NULL
- ITEM_NM — VARCHAR2(100) — NOT NULL
- ITEM_SHRTEN_CODE — VARCHAR2(6)
- RELIMP — NUMBER
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- ITEM_NM) — PCTFREE
COM_ABILITY
- COM_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0) — NOT NULL
- COM_GOODS — VARCHAR2(500)
- USED_GRADE — VARCHAR2(10)
- USE_YEAR — VARCHAR2(10)
CUSTOMER_VOICE
- VOICE_NO — NUMBER — NOT NULL
- NAME — VARCHAR2(30)
- PHONE — VARCHAR2(20)
- EMAIL — VARCHAR2(100)
- TITLE — VARCHAR2(200)
- CONTENTS — CLOB
- REGIST_DT — DATE
- ANSWER_YN — VARCHAR2(1)
DEPT_MANAGER
- DEPT_NO — NUMBER(*,0)
- DEPT_UP_DOWN_CD — VARCHAR2(10)
- DEPT_NAME — VARCHAR2(100)
- SORT — NUMBER(*,0)
- UP_DEPT_NO — NUMBER(*,0)
DEPT_MANAGER_BACK_20110504
- DEPT_NO — NUMBER(*,0)
- DEPT_UP_DOWN_CD — VARCHAR2(10)
- DEPT_NAME — VARCHAR2(100)
- SORT — NUMBER(*,0)
- UP_DEPT_NO — NUMBER(*,0)
DEPT_STAFF
- DEPT_STAFF_NO — NUMBER(*,0)
- STAFF_NAME — VARCHAR2(50)
- STAFF_POSITION — VARCHAR2(20)
- STAFF_MAJOR — CLOB
- STAFF_CAREER — CLOB
- FILE_PATH — VARCHAR2(500)
- L_FILE_NM — VARCHAR2(250)
- P_FILE_NM — VARCHAR2(250)
- REGIST_DT — DATE
- DEPT_CODE — NUMBER(*,0)
- TEAM_CODE — NUMBER(*,0)
- SORT_NO — NUMBER(*,0)
DEPT_STAFF_BACK_20110504
- DEPT_STAFF_NO — NUMBER(*,0)
- STAFF_NAME — VARCHAR2(50)
- STAFF_POSITION — VARCHAR2(20)
- STAFF_MAJOR — CLOB
- STAFF_CAREER — CLOB
- FILE_PATH — VARCHAR2(500)
- L_FILE_NM — VARCHAR2(250)
- P_FILE_NM — VARCHAR2(250)
- REGIST_DT — DATE
- DEPT_CODE — NUMBER(*,0)
- TEAM_CODE — NUMBER(*,0)
- SORT_NO — NUMBER(*,0)
DETAIL_CLASS
- SEQ_NO — VARCHAR2(20) — NOT NULL
- STANDARD_CODE — VARCHAR2(200)
- DEPOSITORY_CODE — VARCHAR2(200)
- FUNDCODE — VARCHAR2(200)
- FUNDNAME — VARCHAR2(200)
- CLASS — VARCHAR2(20)
- PRIMARY — VARCHAR2(200)
- SECONDARY — VARCHAR2(200)
- TERTIARY — VARCHAR2(200)
DETAIL_COMPANY_INFO
- COMPANYCODE — VARCHAR2(10)
- PHONE — VARCHAR2(50)
- HOMEPAGE — VARCHAR2(100)
- COMPANY_GUBUN — VARCHAR2(5)
DISTRIBUTION_PAYMENT
- GCODE — VARCHAR2(6) — NOT NULL
- STD_DT — VARCHAR2(8) — NOT NULL
- PAY_DT — VARCHAR2(8)
- PAY_ROCK_DT — VARCHAR2(8)
- CASH_PAY_DT — VARCHAR2(8)
- DIVIDEND_AMT — NUMBER(10,2)
- DIVIDEND_RATE — NUMBER(5,2)
- REGIST_ID — VARCHAR2(50)
- REGIST_DT — DATE
- UPDT_ID — VARCHAR2(50)
- UPDT_DT — DATE
- STD_DT) — PCTFREE
DURATION
- FUNDCODE — VARCHAR2(4) — NOT NULL
- DURATION_DT — VARCHAR2(20) — NOT NULL
- FUND_DURATION — NUMBER
- AVG_DURATION — NUMBER
- YTM — NUMBER
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- DURATION_DT) — PCTFREE
EDUINFO
- EDU_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0)
- EDU_NAME — VARCHAR2(200)
- EDU_ORG — VARCHAR2(200)
- EDU_START_YEAR — VARCHAR2(10)
- EDU_START_MONTH — VARCHAR2(10)
- EDU_END_YEAR — VARCHAR2(10)
- EDU_END_MONTH — VARCHAR2(10)
- EDU_DETAIL — VARCHAR2(500)
EKWEBLOG
- LOG_SEQ — NUMBER(*,0)
- EKACK — CHAR(1)
- EKADID — VARCHAR2(50)
- EKCUSTOMERID — VARCHAR2(50)
- EKLOGINID — VARCHAR2(50)
- EKADTYPE — VARCHAR2(30)
- EKWEBIEID — VARCHAR2(50)
- EKVISITORSTYPE — VARCHAR2(50)
- EKPV — VARCHAR2(50)
- EKUV — VARCHAR2(50)
- EKWHERE — VARCHAR2(4000)
- EKWHEREPARAM — VARCHAR2(4000)
- EKPAGEURL — VARCHAR2(4000)
- IP — VARCHAR2(50)
- EKWEBLOGID — VARCHAR2(50)
- BRVERSION — VARCHAR2(50)
- OSVERSION — VARCHAR2(50)
- FUNDTYPE — VARCHAR2(20)
- FUNDCODE — VARCHAR2(20)
- DEPTH — VARCHAR2(50)
- COUNTRYCODE — VARCHAR2(5)
- IN_DT — DATE
- OUT_DT — DATE
- PC_FUNDTYPE — VARCHAR2(20)
- PC_FUNDCODE — VARCHAR2(20)
- PC_NO — NUMBER(*,0)
EK_OS
- SEQ — NUMBER(*,0)
- NAME — VARCHAR2(200)
- GUBUN — CHAR(1)
- HIT — NUMBER(*,0)
EK_SUM
- SEQ — NUMBER(*,0)
- YYYY — VARCHAR2(20)
- MM — VARCHAR2(20)
- DD — VARCHAR2(20)
- HH — VARCHAR2(20)
- WEEK — VARCHAR2(20)
- PV — NUMBER(*,0)
- NV — NUMBER(*,0)
- RV — NUMBER(*,0)
- UV — NUMBER(*,0)
- TOTAL_VISIT — NUMBER(*,0)
- BEST_PAGE_URL — VARCHAR2(4000)
- BEST_FROM_URL — VARCHAR2(4000)
- IN_DT — DATE
EMPMN_PBLANC
- EMPMN_NO — NUMBER — NOT NULL
- EMPMN_TITLE — VARCHAR2(200)
- EMPMN_CONTENTS — CLOB
- STATUS — VARCHAR2(1)
- EMPLOY_COUNT — VARCHAR2(10)
- EMPLOY_STR_DT — VARCHAR2(8)
- EMPLOY_END_DT — VARCHAR2(8)
- EMPLOY_TYPE — VARCHAR2(200)
- EMPLOY_GUBUN — VARCHAR2(1)
- EMPLOY_CHARGE — VARCHAR2(100)
- TELL — VARCHAR2(100)
- VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
ETF_BUSINESS_TREND
- BUSINESS_DATE — DATE
- SC_FUNDCODE — VARCHAR2(12)
- FUNDNAME — VARCHAR2(100)
- UNDERLYING_ASSET — VARCHAR2(10)
- NET_PROPERTY — FLOAT(126)
- ETF_STDPRICE — FLOAT(126)
- ETF_MARKET_PRICE — FLOAT(126)
- STDPRICE_MARKET_GAP — FLOAT(126)
- EARNING_RATE_WEEK1 — FLOAT(126)
- EARNING_RATE_MONTH1 — FLOAT(126)
- EARNING_RATE_MONTH3 — FLOAT(126)
- EARNING_RATE_MONTH6 — FLOAT(126)
- EARNING_RATE_YEAR1 — FLOAT(126)
- EARNING_RATE_YEAR2 — FLOAT(126)
- SC_FUNDCODE) — PCTFREE
ETF_CNTNTS_MANAGE
- GCODE — VARCHAR2(6) — NOT NULL
- KIJA_GUBUN — VARCHAR2(2) — NOT NULL
- KIJA_NO — NUMBER — NOT NULL
- SORT_ORDR — NUMBER
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- KIJA_NO) — PCTFREE
ETF_PRODUCT_MANAGER
- GCODE — VARCHAR2(6) — NOT NULL
- GOODS_TYPE — VARCHAR2(6)
- FUNDCODE — VARCHAR2(4)
- GOODS_NM — VARCHAR2(200)
- GOODS_ENG_NM — VARCHAR2(200)
- GOODS_SEF_YN — VARCHAR2(20)
- SEF_TITLE1 — VARCHAR2(200)
- SEF_CONTENT1 — VARCHAR2(4000)
- SEF_TITLE2 — VARCHAR2(200)
- SEF_CONTENT2 — VARCHAR2(4000)
- SEF_TITLE3 — VARCHAR2(200)
- SEF_CONTENT3 — VARCHAR2(4000)
- SEF_TITLE4 — VARCHAR2(200)
- SEF_CONTENT4 — VARCHAR2(4000)
- SEF_TITLE5 — VARCHAR2(200)
- SEF_CONTENT5 — VARCHAR2(4000)
- GOODS_SUMRY_YN — VARCHAR2(1)
- GOODS_FULL_NM — VARCHAR2(200)
- TYPE — VARCHAR2(200)
- MAIN_INVT_TRGET — VARCHAR2(200)
- BSIS_IDEX — VARCHAR2(200)
- BENCHMARK_TICKER — VARCHAR2(100)
- REPRODC_MTH — VARCHAR2(100)
- TRADING_TARGET — VARCHAR2(100)
- BSIS_ASSETS — VARCHAR2(100)
- TRADING_HOURS — VARCHAR2(100)
- TRADING_UNIT — VARCHAR2(20)
- CP_UNIT — VARCHAR2(20)
- ESTBS_UNIT — VARCHAR2(20)
- INCEPTION_DT — VARCHAR2(200)
- MENDNG — VARCHAR2(4000)
- DIVIDEND_STDDE — VARCHAR2(4000)
- IDEX_SUMRY_YN — VARCHAR2(1)
- IDEX_NM — VARCHAR2(200)
- COMPUT_PD — VARCHAR2(200)
- COMPUT_INSTT — VARCHAR2(200)
- IDEX_SUMRY — VARCHAR2(4000)
- IDEX_GOAL — VARCHAR2(4000)
- CHANGE_CYCLE — VARCHAR2(4000)
- FDRM_CHANGE — VARCHAR2(4000)
- ANYTM_CHANGE — VARCHAR2(4000)
- IDEX_UNIVERSE — VARCHAR2(4000)
- ITEM_COMPOSITION — VARCHAR2(4000)
- AGRVTN_MTHD — VARCHAR2(4000)
- IDEX_MTHDLGY — VARCHAR2(4000)
- REBALANCING — VARCHAR2(200)
- SECTOR_SE — VARCHAR2(200)
- BASKET_COMPOSITION — VARCHAR2(200)
- BASKET_EXCHNG — VARCHAR2(4000)
- IDEX_SFE — VARCHAR2(4000)
- IDEX_COMPOSITION_YN — VARCHAR2(1)
- URL — VARCHAR2(200)
- THEMA_RELIMP_YN — VARCHAR2(1)
- THEMA_STDDE — VARCHAR2(10)
- TRADING_TARGET_YN — VARCHAR2(1)
- FLAG — VARCHAR2(100)
- VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- … +3
ETF_PRODUCT_MANAGER_BACKUP
- GCODE — VARCHAR2(6) — NOT NULL
- GOODS_TYPE — VARCHAR2(6)
- FUNDCODE — VARCHAR2(4)
- GOODS_NM — VARCHAR2(200)
- GOODS_ENG_NM — VARCHAR2(200)
- GOODS_SEF_YN — VARCHAR2(20)
- SEF_TITLE1 — VARCHAR2(200)
- SEF_CONTENT1 — VARCHAR2(4000)
- SEF_TITLE2 — VARCHAR2(200)
- SEF_CONTENT2 — VARCHAR2(4000)
- SEF_TITLE3 — VARCHAR2(200)
- SEF_CONTENT3 — VARCHAR2(4000)
- SEF_TITLE4 — VARCHAR2(200)
- SEF_CONTENT4 — VARCHAR2(4000)
- SEF_TITLE5 — VARCHAR2(200)
- SEF_CONTENT5 — VARCHAR2(4000)
- GOODS_SUMRY_YN — VARCHAR2(1)
- GOODS_FULL_NM — VARCHAR2(200)
- TYPE — VARCHAR2(200)
- MAIN_INVT_TRGET — VARCHAR2(200)
- BSIS_IDEX — VARCHAR2(200)
- BENCHMARK_TICKER — VARCHAR2(100)
- REPRODC_MTH — VARCHAR2(100)
- TRADING_TARGET — VARCHAR2(100)
- BSIS_ASSETS — VARCHAR2(100)
- TRADING_HOURS — VARCHAR2(100)
- TRADING_UNIT — VARCHAR2(20)
- CP_UNIT — VARCHAR2(20)
- ESTBS_UNIT — VARCHAR2(20)
- INCEPTION_DT — VARCHAR2(200)
- MENDNG — VARCHAR2(4000)
- DIVIDEND_STDDE — VARCHAR2(4000)
- IDEX_SUMRY_YN — VARCHAR2(1)
- IDEX_NM — VARCHAR2(200)
- COMPUT_PD — VARCHAR2(200)
- COMPUT_INSTT — VARCHAR2(200)
- IDEX_SUMRY — VARCHAR2(4000)
- IDEX_GOAL — VARCHAR2(4000)
- CHANGE_CYCLE — VARCHAR2(4000)
- FDRM_CHANGE — VARCHAR2(4000)
- ANYTM_CHANGE — VARCHAR2(4000)
- IDEX_UNIVERSE — VARCHAR2(4000)
- ITEM_COMPOSITION — VARCHAR2(4000)
- AGRVTN_MTHD — VARCHAR2(4000)
- IDEX_MTHDLGY — VARCHAR2(4000)
- REBALANCING — VARCHAR2(200)
- SECTOR_SE — VARCHAR2(200)
- BASKET_COMPOSITION — VARCHAR2(200)
- BASKET_EXCHNG — VARCHAR2(4000)
- IDEX_SFE — VARCHAR2(4000)
- IDEX_COMPOSITION_YN — VARCHAR2(1)
- URL — VARCHAR2(200)
- THEMA_RELIMP_YN — VARCHAR2(1)
- THEMA_STDDE — VARCHAR2(10)
- TRADING_TARGET_YN — VARCHAR2(1)
- FLAG — VARCHAR2(100)
- VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- … +3
EXAMINFO
- EXAM_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0) — NOT NULL
- EXAM_NAME — VARCHAR2(500)
- EXAM_GRADE — VARCHAR2(100)
- EXAM_YEAR — VARCHAR2(20)
- EXAM_MONTH — VARCHAR2(10)
FAMILYINFO
- APPLY_NO — NUMBER(*,0) — NOT NULL
- FAMILY_NO — NUMBER(*,0) — NOT NULL
- FAM_NAME — VARCHAR2(20)
- RELATION — VARCHAR2(20)
- FAM_AGE — VARCHAR2(20)
- OFFICE_NAME — VARCHAR2(100)
- OFFICE_POSITION — VARCHAR2(50)
- SCHOLARSHIP — VARCHAR2(50)
- LIVING_TOGETHER — VARCHAR2(20)
- FAMILY_NO) — PCTFREE
FAQ
- FAQ_NO — NUMBER(*,0)
- FAQ_GUBUN — VARCHAR2(20)
- FAQ_TITLE — VARCHAR2(200)
- FAQ_CONTENTS — CLOB
- REGISTER_ID — VARCHAR2(20)
- DELETE_YN — CHAR(1)
- REGIST_DT — DATE
- BEST_CH — CHAR(1)
- MODIFY_DT — DATE
- PERSONALLY — CHAR(1)
FORE_ABILITY
- FORE_NO — NUMBER(*,0) — NOT NULL
- APPLY_NO — NUMBER(*,0) — NOT NULL
- FORE_NAME — VARCHAR2(30)
- CONVERSATION — VARCHAR2(10)
- COMPOSTION — VARCHAR2(10)
- TRANSLATION — VARCHAR2(10)
- APPLY_NO) — PCTFREE
FUNDINFO
- FUNDCODE — VARCHAR2(10)
- FUNDNAME — VARCHAR2(200)
- PRODUCTTYPE — VARCHAR2(10)
- SETDATE — DATE
- STANDARDPRICE — FLOAT(126)
- FUNDTOTALAMOUNT — FLOAT(126)
- FUNDACCOUNTCNT — FLOAT(126)
- MANAGER — VARCHAR2(50)
- REWARDTOTAL — FLOAT(126)
- SALECOMPANY — VARCHAR2(50)
- TRUSTCOMPANY — VARCHAR2(50)
- TRUSTTERM — VARCHAR2(100)
- FINANTERM — VARCHAR2(100)
- REPCHCOMMI — VARCHAR2(100)
- SALEYN — CHAR(1)
- STDPRICEUPDN — FLOAT(126)
- TAXABLEAMOUNT — FLOAT(126)
- SUIK_WK — FLOAT(126)
- SUIK_01 — FLOAT(126)
- SUIK_03 — FLOAT(126)
- SUIK_06 — FLOAT(126)
- SUIK_12 — FLOAT(126)
- SUIK_SUL — FLOAT(126)
- STDPRICE2 — FLOAT(126)
- STDPRICE3 — FLOAT(126)
- STOCKRATE — FLOAT(126)
- BONDRATE — FLOAT(126)
- FLOATASSETSRATE — FLOAT(126)
- BIZDATE — DATE
- BMSUIK_WEEK — FLOAT(126)
- BMSUIK_MONTH1 — FLOAT(126)
- BMSUIK_MONTH3 — FLOAT(126)
- BMSUIK_MONTH6 — FLOAT(126)
- BMSUIK_MONTH12 — FLOAT(126)
- BMSUIK_STDPRICE — FLOAT(126)
- PARENTFUNDCODE — VARCHAR2(50)
- N_SALE — FLOAT(126)
- N_WORKING — FLOAT(126)
- N_CONSIGN — FLOAT(126)
- N_BCONSIGN — FLOAT(126)
- N_SVFEE — VARCHAR2(200)
- BM — VARCHAR2(200)
- FUND_KINDCODE — VARCHAR2(13)
- GONG_SAMO_GUBUN — VARCHAR2(1)
- LAW_GUBUN — VARCHAR2(1)
- GATHER_INVEST_CODE — VARCHAR2(20)
- SUIK_3Y — FLOAT(126)
- SUIK_5Y — FLOAT(126)
- BMSUIK_YEAR3 — FLOAT(126)
- BMSUIK_YEAR5 — FLOAT(126)
FUND_ADD_FILES
- PARENTFUNDCODE — VARCHAR2(10)
- IMG_FILE_PATH — VARCHAR2(250)
- IMG_L_FILE_NM — VARCHAR2(500)
- IMG_P_FILE_NM — VARCHAR2(500)
- RULE_FILE_PATH — VARCHAR2(250)
- L_RULE_FILE_NM — VARCHAR2(500)
- P_RULE_FILE_NM — VARCHAR2(500)
- INVEST_FILE_PATH — VARCHAR2(250)
- L_INVEST_FILE_NM — VARCHAR2(500)
- P_INVEST_FILE_NM — VARCHAR2(500)
- FUND_EXPLAIN — VARCHAR2(4000)
- RISK_GRADE — VARCHAR2(2)
- RECOM_IMG_FILE_PATH — VARCHAR2(250)
- RECOM_IMG_L_FILE_NM — VARCHAR2(500)
- RECOM_IMG_P_FILE_NM — VARCHAR2(500)
- RESALE_DETAIL — VARCHAR2(4000)
FUND_ALTERNATIVE_INVESTMENT
- FUND_NO — VARCHAR2(20) — NOT NULL
- FUNDNAME — VARCHAR2(200)
- FUND_LOCAL — VARCHAR2(200)
- FUND_SCALE — VARCHAR2(200)
- FUND_TEXT — VARCHAR2(200)
- FUND_TYPE — VARCHAR2(200)
- FUND_MANAGEMENT — VARCHAR2(200)
- GLOBAL_GUBUN — VARCHAR2(200)
- GUBUN — VARCHAR2(200)
- FUND_IMG_PATH — VARCHAR2(200)
- RETRIEVAL — VARCHAR2(20)
FUND_COMPANY_INFO
- COMPANYCODE — VARCHAR2(10)
- COMPANYNAME — VARCHAR2(100)
- PHONE — VARCHAR2(50)
- HOMEPAGE — VARCHAR2(100)
FUND_DETAIL_INFO
- FUNDCODE — VARCHAR2(10)
- FUND_VIEW_YN — CHAR(1)
- RESALE_DETAIL — VARCHAR2(4000)
FUND_DICTIONARY
- DICTIONARY_ID — NUMBER(*,0)
- WORD — VARCHAR2(200)
- DESCRIPTION — CLOB
- ENGLISH — VARCHAR2(200)
- REGISTER_NM — VARCHAR2(20)
- REGIST_DT — DATE
- MODIFY_NM — VARCHAR2(20)
- MODIFY_DT — DATE
FUND_DICTIONARY_BACKUP
- DICTIONARY_ID — NUMBER(*,0)
- WORD — VARCHAR2(200)
- DESCRIPTION — CLOB
- ENGLISH — VARCHAR2(200)
FUND_ESG
- FUNDCODE — VARCHAR2(20) — NOT NULL
- FUNDNAME — VARCHAR2(100)
- SEQ_NO — NUMBER(2,0) — NOT NULL
- VIEW_YN — VARCHAR2(1)
- RISK_TEXT — VARCHAR2(300)
- LIST_IMG — VARCHAR2(50)
- LEAPLET_IMG1 — VARCHAR2(50)
- LEAPLET_IMG2 — VARCHAR2(50)
- LEAPLET_IMG3 — VARCHAR2(50)
- LEAPLET_IMG4 — VARCHAR2(50)
FUND_GLOBAL_RECOMMEND
- GLOBAL_RECOM_NO — NUMBER(*,0)
- FUNDCODE — VARCHAR2(10)
- GLOBAL_GUBUN — VARCHAR2(5)
- P_FILE_LOCATION — VARCHAR2(500)
FUND_KOSEF
- FUNDCODE — VARCHAR2(20) — NOT NULL
- ICON_IMG — VARCHAR2(50)
- FUNDNAME — VARCHAR2(200)
- INSIGNIA — VARCHAR2(20)
- VIEW_YN — VARCHAR2(1)
FUND_LOSS
- LOSS_NO — NUMBER — NOT NULL
- GONGSI_DT — VARCHAR2(10) — NOT NULL
- FILE_NM — VARCHAR2(200)
FUND_LOSS_INFO
- LOSS_NO — NUMBER — NOT NULL
- SEQ_NO — NUMBER — NOT NULL
- GUBUN — VARCHAR2(50)
- GOODS_NAME — VARCHAR2(200)
- PYEONGGA_AEK — NUMBER
- PER_NAV — NUMBER(5,2)
- VAR_AEK — NUMBER
- PER_VAR — NUMBER(5,2)
- SEQ_NO) — PCTFREE
FUND_MAIN
- FUNDCODE — VARCHAR2(20) — NOT NULL
- FUNDTYPE — VARCHAR2(20)
- ICON_IMG — VARCHAR2(50)
- SIMPLE_TEXT — VARCHAR2(20)
- DETAIL_TEXT — VARCHAR2(50)
- FUNDNAME — VARCHAR2(100)
- SEQ_NO — NUMBER(2,0)
- VIEW_YN — VARCHAR2(1)
- RISK_TEXT — VARCHAR2(300)
- LEAPLET_IMG1 — VARCHAR2(50)
- LEAPLET_IMG2 — VARCHAR2(50)
- LEAPLET_IMG3 — VARCHAR2(50)
- LEAPLET_IMG4 — VARCHAR2(100)
FUND_MANAGE_REPORT
- SUMDATE — DATE
- PRODUCTTYPE — VARCHAR2(10)
- TOTALAMOUNT — FLOAT(126)
- PRODUCTTYPE) — PCTFREE
FUND_MONTH_MANAGE_REPORT
- REPORT_NO — NUMBER(*,0)
- FUNDCODE — VARCHAR2(10)
- REPORT_GUBUN — VARCHAR2(5)
- YYYYMM — VARCHAR2(10)
- FILE_PATH — VARCHAR2(250)
- L_FILE_NM — VARCHAR2(500)
- P_FILE_NM — VARCHAR2(500)
- POSTED — DATE
FUND_NASDAQ_PRICE
- FUNDCODE — VARCHAR2(10) — NOT NULL
- STDDATE — DATE — NOT NULL
- NASDAQ100 — FLOAT(126)
- EXCHANGEPRICE — FLOAT(126)
- KOREANPRICE — FLOAT(126)
- BEFOREBAND — FLOAT(126)
- NEXTBAND — FLOAT(126)
- NEXTTOP — FLOAT(126)
- NEXTBOTTOM — FLOAT(126)
- SPLITYN — CHAR(1)
- SPECIFIC_GRAVITY — FLOAT(126)
- STDDATE) — PCTFREE
FUND_SALESCOMPANY
- FUNDCODE — VARCHAR2(10)
- COMPANYCODE — VARCHAR2(10)
- MAINCOMPYN — CHAR(1)
- COMPANYCODE) — PCTFREE
FUND_SEARCH_RECOMMEND
- SEARCH_RECOM_NO — NUMBER(*,0)
- FUNDCODE — VARCHAR2(10)
FUND_STANDARD_PRICE
- FUNDCODE — VARCHAR2(10)
- STDDATE — DATE
- STANDARDPRICE — FLOAT(126)
- STDPRICEUPDN — FLOAT(126)
- TAXABLEAMOUNT — FLOAT(126)
- STDPRICE2 — FLOAT(126)
- BMSTDPRICE — FLOAT(126)
- SPECIFIC_GRAVITY — FLOAT(126)
- STOCK_EXPOSURE — FLOAT(126)
- ETFFORWARDINVEST — FLOAT(126)
- ETFREVERSEINVEST — FLOAT(126)
- CASHINVEST — FLOAT(126)
- STDDATE) — PCTFREE
FUND_TDF
- FUNDCODE — VARCHAR2(20) — NOT NULL
- FUNDNAME — VARCHAR2(100)
- SEQ_NO — NUMBER(2,0) — NOT NULL
- VIEW_YN — VARCHAR2(1)
- RISK_TEXT — VARCHAR2(300)
- LIST_IMG — VARCHAR2(50)
- LEAPLET_IMG1 — VARCHAR2(50)
- LEAPLET_IMG2 — VARCHAR2(50)
- LEAPLET_IMG3 — VARCHAR2(50)
- LEAPLET_IMG4 — VARCHAR2(20)
FUND_YIELD_REPORT
- STD_DATE — DATE — NOT NULL
- FUND_CODE — VARCHAR2(10) — NOT NULL
- STDPRICE — FLOAT(126)
- BMSTDPRICE — FLOAT(126)
- SUIK — FLOAT(126)
- BM — FLOAT(126)
- SUIK_RT — VARCHAR2(126)
- BM_RT — VARCHAR2(126)
- FUND_CODE) — PCTFREE
INDEX_INFO
- INDEX_DATE — DATE
- INDEX_GUBUN — VARCHAR2(3)
- INDEX_NAME — VARCHAR2(50)
- INDEX_PRICE — FLOAT(126)
- STANDARD_DEVIATION — FLOAT(126)
- INDEX_GUBUN) — PCTFREE
KEYWORD_INFO
- KEYWORD_NO — VARCHAR2(8) — NOT NULL
- KEYWORD_GUBUN — VARCHAR2(2)
- KEYWORD_NM — VARCHAR2(200)
- KEYWORD_ENG_NM — VARCHAR2(200)
- SORT_ORDR — NUMBER
- VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
KEYWORD_MAIN
- KEYWORD_NO — VARCHAR2(8) — NOT NULL
- KEYWORD_NM — VARCHAR2(20)
- FILE_PATH — VARCHAR2(1000)
- P_FILE_NM — VARCHAR2(1000)
- L_FILE_NM — VARCHAR2(1000)
- SORT_ORDR — NUMBER
- VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
KEYWORD_MAIN_BACKUP
- KEYWORD_NO — VARCHAR2(8) — NOT NULL
- KEYWORD_NM — VARCHAR2(20)
- FILE_PATH — VARCHAR2(1000)
- P_FILE_NM — VARCHAR2(1000)
- L_FILE_NM — VARCHAR2(1000)
- SORT_ORDR — NUMBER
- VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
KIJA_MAGAZINE
- KIJA_NO — NUMBER — NOT NULL
- KIJA_GUBUN — VARCHAR2(2)
- PLTFOM_GUBUN — VARCHAR2(3)
- LCALS — VARCHAR2(3)
- SCALS — VARCHAR2(320)
- KIJA_TITLE — VARCHAR2(400)
- KIJA_CONTENTS — CLOB
- CNRS_URL — VARCHAR2(500)
- ORGINL_SOURCE — VARCHAR2(2000)
- VIEW_YN — VARCHAR2(1)
- MAIN_VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- ALTRTV_TEXT — VARCHAR2(200)
KIJA_MAGAZINE2
- KIJA_NO — NUMBER — NOT NULL
- KIJA_GUBUN — VARCHAR2(2)
- PLTFOM_GUBUN — VARCHAR2(3)
- LCALS — VARCHAR2(3)
- SCALS — VARCHAR2(320)
- KIJA_TITLE — VARCHAR2(400)
- KIJA_CONTENTS — CLOB
- CNRS_URL — VARCHAR2(500)
- ORGINL_SOURCE — VARCHAR2(2000)
- VIEW_YN — VARCHAR2(1)
- MAIN_VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- ALTRTV_TEXT — VARCHAR2(200)
KIJA_MAGAZINE_BACKUP
- KIJA_NO — NUMBER — NOT NULL
- KIJA_GUBUN — VARCHAR2(2)
- PLTFOM_GUBUN — VARCHAR2(3)
- LCALS — VARCHAR2(3)
- SCALS — VARCHAR2(320)
- KIJA_TITLE — VARCHAR2(400)
- KIJA_CONTENTS — CLOB
- CNRS_URL — VARCHAR2(500)
- ORGINL_SOURCE — VARCHAR2(2000)
- VIEW_YN — VARCHAR2(1)
- MAIN_VIEW_YN — VARCHAR2(1)
- REGIST_ID — VARCHAR2(50) — NOT NULL
- REGIST_DT — DATE — NOT NULL
- UPDT_ID — VARCHAR2(50) — NOT NULL
- UPDT_DT — DATE — NOT NULL
- ALTRTV_TEXT — VARCHAR2(200)
KOSEF_BBS
- BBS_NO — NUMBER(*,0)
- BBS_ID — VARCHAR2(10)
- REGISTER_NM — VARCHAR2(20)
- BBS_TITLE — VARCHAR2(200)
- BBS_CONTENTS — CLOB
- BBS_CONTENTS_TEXT — CLOB
- VIEW_YN — CHAR(1)
- DELETE_YN — CHAR(1)
- REGIST_DT — DATE
- MODIFY_DT — DATE
- DELETE_DT — DATE
- FILE_NAME — VARCHAR2(250)
- SAVE_FOLDER — VARCHAR2(250)
- BBS_CNT — NUMBER(*,0)
- BBS_RDATE — DATE
- BBS_GUBUN — VARCHAR2(20)
- FILE_SIZE — VARCHAR2(50)
외 65개 테이블