yoons_talkadmin

Tables (50)

WYC_AGENCY

  • AGENCY_NO — NUMBER(10,0)
  • AGENCY_NAME — VARCHAR2(40)
  • MANAGER_NO — NUMBER(10,0)
  • STATUS — NUMBER(2,0)
  • SANGHO — VARCHAR2(100)
  • REGI_NO — VARCHAR2(20)
  • BUSI_CONDITION — VARCHAR2(50)
  • BUSI_ITEM — VARCHAR2(50)
  • ACOD — CHAR(3)
  • STATUS_REASON — NUMBER(2,0)
  • IS_INSURANCE_USE — NUMBER(2,0)
  • IS_CI_USE — NUMBER(2,0)
  • IS_CORP — NUMBER(2,0)
  • IS_YOONSAT — NUMBER(2,0)
  • AGENCY_SIZE — NUMBER(10,0)
  • START_FUND — NUMBER(10,0)
  • IS_CMS_USE — NUMBER(2,0)
  • CMS_CHARGER — VARCHAR2(20)
  • CMS_CHARGER_PHONE — VARCHAR2(14)
  • CMS_CHARGER_MOBILE_PHONE — VARCHAR2(14)
  • IS_CMS_TEACHER_GRANT — NUMBER(2,0)
  • CMS_MAX_AMOUNT_TRANSFER — NUMBER(10,0)
  • IS_CASH_RECEIPT — NUMBER(2,0)
  • TERMINAL_NO — VARCHAR2(50)
  • OPEN_YMD — DATE
  • CLOSE_YMD — DATE
  • ZIP_CODE — VARCHAR2(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(60)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PHONE — VARCHAR2(14)
  • FAX_NO — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • SENTENCE_COMMENT — VARCHAR2(1000)
  • IS_UNCOLLECTED — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE
  • AGENCY_MANAGER_NO — NUMBER(10,0)
  • GUARANTY_MONEY — NUMBER(10,0)
  • ORDER_DAY — VARCHAR2(5)
  • OUT_CONDITION — CHAR(1)
  • DEPOSITOR — VARCHAR2(50)
  • BANK_CODE — CHAR(2)
  • BANK_ACCOUNT — VARCHAR2(30)
  • CONFERENCE_NO — NUMBER(10,0)
  • BUSI_HEAD_OFFICE_NO — NUMBER(10,0)
  • REGION_NO — NUMBER(10,0)
  • IS_ENG_FOREST — NUMBER(2,0)
  • IS_DELAY_RECEIPT — NUMBER(2,0) — NOT NULL
  • IS_HEAD_AGENCY — NUMBER(2,0)
  • HEAD_AGENCY_NO — NUMBER(10,0)
  • TOTAL_AREA — NUMBER(10,2)
  • HOME_STUDY_AREA — NUMBER(10,2)
  • ACADEMY_AREA — NUMBER(10,2)
  • ETC_COMMENTS — VARCHAR2(500)
  • ADMIN_TEACHER_CNT — NUMBER(5,0)
  • IS_BOOK_CAFE — NUMBER(2,0)
  • IS_EVENT_ROOM — NUMBER(2,0)
  • IS_COUNCEL_ROOM — NUMBER(2,0)
  • STUDY_ROOM_CNT — NUMBER(2,0)
  • … +18

WYC_AGENCY_HISTORY

  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • CHANGE_KIND — NUMBER(5,0) — NOT NULL
  • CHANGE_DT — DATE — NOT NULL
  • CHANGE_COMMENT — VARCHAR2(1000) — NOT NULL

WYC_AGENCY_MANAGER

  • AGENCY_MANAGER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • AGENCY_MANAGER_NAME — VARCHAR2(20) — NOT NULL
  • AGENCY_MANAGER_ENG_NAME — VARCHAR2(30)
  • JUMIN_NO — CHAR(14)
  • MOBILE_PHONE — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • EDUCATION_INFO — VARCHAR2(50)
  • MAJOR — VARCHAR2(50)
  • CAREER — VARCHAR2(100)
  • SENTENCE_COMMENT — VARCHAR2(100)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • FAMILY — VARCHAR2(50)
  • REAL_NAME_CONFIRM_STATUS — NUMBER(2,0) — NOT NULL
  • IMAGE_PATH — VARCHAR2(200)
  • BIRTH_YMD — VARCHAR2(10)
  • SEX — NUMBER(2,0)

WYC_AGENCY_MONTH_STATUS

  • YEAR_MONTH — CHAR(6) — Primary key — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • IS_HEAD_AGENCY_AUTO — NUMBER(2,0)
  • IS_HEAD_AGENCY_MANUAL — NUMBER(2,0)

WYC_AGENCY_ORGANIZATION

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • KIND — NUMBER(2,0) — Primary key — NOT NULL
  • CCODE — NUMBER(10,0)
  • LAST_UPDATE_DT — DATE — NOT NULL

WYC_AGENCY_RELATION

  • PARENT_AGENCY_NO — NUMBER(10,0) — NOT NULL
  • CHILD_AGENCY_NO — NUMBER(10,0) — NOT NULL
  • PROCESS_DT — DATE — NOT NULL

WYC_AGENCY_SMS

  • AGENCY_NO — NUMBER(10,0)
  • IS_SALE_SMS — NUMBER(2,0)
  • IS_PAY_SMS — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE — NOT NULL

WYC_AGENCY_VISIT_REPORT

  • AGENCY_VISIT_REPORT_NO — NUMBER(10,0) — Primary key — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • VISIT_YMD — VARCHAR2(10) — NOT NULL
  • MANAGER_NO — NUMBER(10,0) — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL
  • KIND — NUMBER(2,0) — NOT NULL

WYC_AGENCY_VISIT_REPORT_ANS

  • AGENCY_VISIT_REPORT_NO — NUMBER(10,0) — NOT NULL
  • QUESTION_NO — NUMBER(10,0) — NOT NULL
  • ANSWER — NUMBER(2,0)
  • ANSWER_ETC — VARCHAR2(2000)

WYC_AGENCY_VISIT_REPORT_QUEST

  • QUESTION_NO — NUMBER(10,0) — NOT NULL
  • QUESTION — VARCHAR2(500) — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • KIND — NUMBER(2,0) — NOT NULL

WYC_AGENCY_WIDE_BUSINESS_AREA

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • WIDE_BUSINESS_AREA_NO — NUMBER(10,0) — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • LAST_UPDATE_DT — DATE

WYC_BANK_ACCOUNT

  • ACCOUNT_NO — NUMBER(10,0) — Primary key — NOT NULL
  • BANK_ACCOUNT — VARCHAR2(30) — NOT NULL
  • BANK_NAME — VARCHAR2(20) — NOT NULL
  • DEPOSITOR — VARCHAR2(20) — NOT NULL
  • STATUS — VARCHAR2(2) — NOT NULL
  • TRADE_BANK_CODE — CHAR(2) — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL

WYC_CASH_RECEIPT_ISSUE_TARGET

  • CMS_CASH_RECEIPT_TARGET_NO — NUMBER(10,0) — Primary key — NOT NULL
  • JUMIN_NO — VARCHAR2(14) — NOT NULL
  • EMAIL — VARCHAR2(50)
  • LAST_UPDATE_DT — DATE
  • IS_RECEIPT_EMAIL — NUMBER(1,0) — NOT NULL
  • KIND — NUMBER(2,0)

WYC_CLIENT

  • CLIENT_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CLIENT_NAME — VARCHAR2(20) — NOT NULL
  • REGI_NO — VARCHAR2(20) — NOT NULL
  • PHONE — VARCHAR2(14)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(60)
  • REMAIN_ADDRESS — VARCHAR2(40)
  • BUSI_CONDITION — VARCHAR2(50)
  • BUSI_ITEM — VARCHAR2(50)
  • REPRESENTATIVE_NAME — VARCHAR2(20)
  • BANK_ACCOUNT — VARCHAR2(20)
  • DEPOSITOR — VARCHAR2(20)
  • CHARGER_NAME — VARCHAR2(20)
  • EMAIL — VARCHAR2(50)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • TRADE_BANK_CODE — CHAR(2) — NOT NULL
  • ZIP_CODE — CHAR(7)
  • FAX_NO — VARCHAR2(14)

WYC_CMS_ACCOUNT

  • CMS_ACCOUNT_NO — NUMBER(10,0) — Primary key — NOT NULL
  • DEPOSITOR — VARCHAR2(50) — NOT NULL
  • DEPOSITOR_JUMIN_NO — CHAR(14) — NOT NULL
  • CMS_BANK_ACCOUNT — VARCHAR2(20) — NOT NULL
  • BANK_CODE — CHAR(2) — NOT NULL
  • EMAIL — VARCHAR2(50)
  • PHONE — VARCHAR2(14)
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(60)
  • REMAIN_ADDRESS — VARCHAR2(70)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • MOBILE_PHONE — VARCHAR2(14)
  • STATUS — NUMBER(2,0)

WYC_COMPANY

  • COMPANY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • COMPANY_NAME — VARCHAR2(20)
  • MAJOR_CODE — NUMBER(10,0)
  • REGI_NO — VARCHAR2(20)
  • PHONE — VARCHAR2(14)
  • FAX_NO — VARCHAR2(14)
  • BUSI_CONDITION — VARCHAR2(50)
  • BUSI_ITEM — VARCHAR2(50)
  • ZIP_CODE — CHAR(7)
  • ADDRESS — VARCHAR2(100)
  • ADDRESS_SUB — VARCHAR2(80)
  • LAST_UPDATE_DT — DATE

WYC_CONFERENCE

  • CONFERENCE_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CONFERENCE_NAME — VARCHAR2(50) — NOT NULL
  • BUSI_HEAD_OFFICE_NO — NUMBER(10,0) — NOT NULL

WYC_CUSTOMER_AUDIO_CONFIG

  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • IS_TAPE_ORDER — NUMBER(2,0) — NOT NULL
  • UPDATE_AGENCY_NO — NUMBER(10,0) — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL

WYC_CUSTOMER_CI

  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CI — CHAR(88) — NOT NULL
  • V_JUMIN_NO — CHAR(14)
  • BIRTHDAY — DATE
  • REAL_NAME — VARCHAR2(20)

WYC_CUSTOMER_JOIN

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CUSTOMER_NAME — VARCHAR2(20) — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • SOURCE_NO — NUMBER(10,0)
  • CMS_ACCOUNT_NO — NUMBER(10,0)
  • CMS_CASH_RECEIPT_TARGET_NO — NUMBER(10,0)
  • IS_REAL_ACTIVE — NUMBER(2,0)
  • CHANGE_DT — DATE
  • SENTENCE_COMMENT — VARCHAR2(200)
  • INTRO_CUSTOMER_NO — NUMBER(10,0)
  • CURRICULUM — NUMBER(2,0)
  • RECEIVE_METHOD — NUMBER(2,0)
  • IS_CASH_RECEIPT — NUMBER(2,0)
  • TRANS_STANDARD_DAY — VARCHAR2(2)
  • UPDATER_KIND — NUMBER(2,0) — NOT NULL
  • UPDATER_NO — NUMBER(10,0) — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL
  • COURSE — NUMBER(2,0)
  • IS_DEVIDED_PAYMENTS — NUMBER(2,0)
  • STATUS_REASON — NUMBER(2,0)
  • INFO_RECEIVE_RELATION_KIND — NUMBER(2,0)
  • STUDY_PLACE — NUMBER(2,0)
  • SERVICE_KIND — NUMBER(2,0)
  • BEFL_ALLOWANCE_KIND — NUMBER(2,0)
  • BEFL_ALLOWANCE_MONTH — NUMBER(2,0)
  • MANAGE_ALLOWANCE_RATIO — NUMBER(5,1)
  • COUNSEL_ALLOWANCE_RATIO — NUMBER(5,1)
  • INTRO_ALLOWANCE_RATIO — NUMBER(5,1)
  • FOOTHOLD_KIND — NUMBER(2,0)
  • AUDIO_STUDY_KIND — NUMBER(2,0)
  • IS_KIDSPOP — NUMBER(2,0)
  • IS_FOOTHOLD_REST — NUMBER(1,0)
  • RETURN_COMMENT — VARCHAR2(100)
  • RETURN_DT — DATE
  • IS_NEW_MANAGE — NUMBER(1,0)

WYC_FOOTHOLD

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • TEACHER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • FOOTHOLD_NAME — VARCHAR2(30) — NOT NULL
  • FOOTHOLD_KIND — NUMBER(2,0)
  • STATUS — NUMBER(2,0) — NOT NULL
  • OPEN_STATUS — NUMBER(2,0)
  • OPEN_YMD — DATE — NOT NULL
  • CLOSE_YMD — DATE
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(60)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • REGI_NO — VARCHAR2(20)
  • SANGHO — VARCHAR2(50)
  • BUSI_CONDITION — VARCHAR2(50)
  • BUSI_ITEM — VARCHAR2(50)
  • BUSI_PRCESS_DT — DATE
  • SB_INSTALL_DT — DATE
  • OPEN_STATUS_COMMENT — VARCHAR2(200)
  • SENTENCE_COMMENT — VARCHAR2(200)
  • PHONE — VARCHAR2(20)
  • OFFICE_PHONE — VARCHAR2(20)
  • BUSI_HEAD_OFFICE_NO — NUMBER(10,0)
  • CONFERENCE_NO — NUMBER(10,0)
  • IS_HYBRID_SB — NUMBER(2,0)

WYC_FOOTHOLD_APPLY

  • APPLY_NO — NUMBER(10,0) — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • IMAGE_PATH — VARCHAR2(50) — NOT NULL
  • TEACHER_NAME — VARCHAR2(20) — NOT NULL
  • AGE — NUMBER(3,0) — NOT NULL
  • BIRTH_YMD — VARCHAR2(10) — NOT NULL
  • SEX — NUMBER(2,0) — NOT NULL
  • PHONE — VARCHAR2(14) — NOT NULL
  • MOBILE_PHONE — VARCHAR2(14) — NOT NULL
  • EMAIL — VARCHAR2(50)
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(60)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • FAMILY_NAME — VARCHAR2(20)
  • CHILD_M_CNT — NUMBER(2,0)
  • CHILD_F_CNT — NUMBER(2,0)
  • CAREER_1 — VARCHAR2(200)
  • CAREER_2 — VARCHAR2(200)
  • CAREER_3 — VARCHAR2(200)
  • CAREER_TEXT — VARCHAR2(200)
  • EDUCATION_INFO — VARCHAR2(100)
  • EDUCATION_STATUS — NUMBER(2,0)
  • KIND — NUMBER(2,0)
  • FH_ZIP_CODE — CHAR(7)
  • FH_SIDO — VARCHAR2(20)
  • FH_GUGUN — VARCHAR2(20)
  • FH_DONG — VARCHAR2(60)
  • FH_REMAIN_ADDRESS — VARCHAR2(80)
  • FOOTHOLD_NAME — VARCHAR2(30)
  • FOOTHOLD_COMMENTS — VARCHAR2(100)
  • BUSI_HEAD_COMMENTS — VARCHAR2(100)
  • APPLY_DT — DATE — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL
  • MARRIAGE_KIND — NUMBER(2,0)
  • JUMIN_NO — VARCHAR2(14)
  • TEACHER_NO — NUMBER(10,0)
  • HEAD_OFFICE_FOOTHOLD_NAME — VARCHAR2(30)
  • IS_TEACHER_HISTORY — NUMBER(2,0)
  • IS_SWITCH — NUMBER(2,0)
  • OLD_BRAND_NAME — VARCHAR2(30)
  • APLLY_STEP — NUMBER(2,0)

WYC_FOOTHOLD_APPLY_STATUS

  • APPLY_NO — NUMBER(10,0) — NOT NULL
  • APPLY_DT — DATE — NOT NULL
  • PROCESS_DT — DATE — NOT NULL
  • APLLY_STEP — NUMBER(2,0)
  • STATUS — NUMBER(2,0)
  • MANAGER_NO — NUMBER(10,0)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • STATUS_COMMENT — VARCHAR2(1000)
  • H_STATUS — NUMBER(2,0)
  • H_PROCESS_DT — DATE

WYC_FOOTHOLD_FILE

  • APPLY_NO — NUMBER(10,0) — NOT NULL
  • IMAGE_NAME — VARCHAR2(50) — NOT NULL
  • IMAGE_SAVE_NAME — VARCHAR2(50) — NOT NULL
  • KIND — NUMBER(2,0) — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL

WYC_HEAD_OFFICE_EMPLOYEE

  • EMPLOYEE_NO — NUMBER(10,0) — Primary key — NOT NULL
  • EMPLOYEE_NAME — VARCHAR2(20) — NOT NULL
  • CCODE — NUMBER(10,0) — NOT NULL
  • JUMIN_NO — CHAR(14) — NOT NULL
  • PHONE — VARCHAR2(14)
  • MOBILE_PHONE — VARCHAR2(14) — NOT NULL
  • EMAIL — VARCHAR2(50)
  • LAST_UPDATE_DT — DATE
  • POSITION_NAME — VARCHAR2(20)
  • SENTENCE_COMMENT — VARCHAR2(50)
  • COMPANY_NO — NUMBER(10,0) — NOT NULL
  • SMS_KIND — NUMBER(2,0)

WYC_H_AGENCY

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • START_DT — DATE
  • END_DT — DATE
  • AGENCY_NAME — VARCHAR2(40) — NOT NULL
  • MANAGER_NO — NUMBER(10,0) — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • SANGHO — VARCHAR2(100)
  • REGI_NO — VARCHAR2(20)
  • BUSI_CONDITION — VARCHAR2(50)
  • BUSI_ITEM — VARCHAR2(50)
  • ACOD — CHAR(3)
  • STATUS_REASON — NUMBER(2,0)
  • IS_INSURANCE_USE — NUMBER(2,0)
  • IS_CI_USE — NUMBER(2,0)
  • IS_CORP — NUMBER(2,0)
  • IS_YOONSAT — NUMBER(2,0)
  • AGENCY_SIZE — NUMBER(10,0)
  • START_FUND — NUMBER(10,0)
  • IS_CMS_USE — NUMBER(2,0)
  • CMS_CHARGER — VARCHAR2(20)
  • CMS_CHARGER_PHONE — VARCHAR2(14)
  • CMS_CHARGER_MOBILE_PHONE — VARCHAR2(14)
  • IS_CMS_TEACHER_GRANT — NUMBER(2,0)
  • CMS_MAX_AMOUNT_TRANSFER — NUMBER(10,0)
  • IS_CASH_RECEIPT — NUMBER(2,0)
  • TERMINAL_NO — VARCHAR2(50)
  • OPEN_YMD — DATE
  • CLOSE_YMD — DATE
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(60)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PHONE — VARCHAR2(14)
  • FAX_NO — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • SENTENCE_COMMENT — VARCHAR2(1000)
  • IS_UNCOLLECTED — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE
  • AGENCY_MANAGER_NO — NUMBER(10,0) — NOT NULL
  • GUARANTY_MONEY — NUMBER(10,0)
  • ORDER_DAY — VARCHAR2(5)
  • OUT_CONDITION — CHAR(1)
  • DEPOSITOR — VARCHAR2(50)
  • BANK_CODE — CHAR(2)
  • BANK_ACCOUNT — VARCHAR2(30)
  • CONFERENCE_NO — NUMBER(10,0)
  • BUSI_HEAD_OFFICE_NO — NUMBER(10,0)
  • REGION_NO — NUMBER(10,0)
  • IS_HEAD_AGENCY — NUMBER(2,0)
  • HEAD_AGENCY_NO — NUMBER(10,0)
  • IS_ENG_FOREST — NUMBER(2,0)
  • F_MANAGER_NO — NUMBER(10,0)
  • F_CONFERENCE_NO — NUMBER(10,0)
  • CONTRACT_KIND — NUMBER(2,0)
  • IS_TAKEOVER — NUMBER(2,0)
  • W_MANAGER_NO — NUMBER(10,0)
  • IS_W_AGENCY — NUMBER(2,0)
  • IS_HOME_MASTER — NUMBER(2,0)
  • BUSINESS_GUGUN — VARCHAR2(20)
  • … +2

WYC_H_AGENCY_CONTRACT

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • MERGE_AGENCY_NO — NUMBER(10,0)

WYC_H_AGENCY_WIDE_BUSI_AREA

  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • START_DT — DATE — NOT NULL
  • END_DT — DATE — NOT NULL
  • WIDE_BUSINESS_AREA_NO — NUMBER(10,0) — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL

WYC_H_CMS

  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • RECEIVE_METHOD — NUMBER(2,0)
  • IS_CASH_RECEIPT — NUMBER(2,0)
  • TRANS_STANDARD_DAY — VARCHAR2(2)
  • CMS_ACCOUNT_NO — VARCHAR2(30)
  • CMS_CASH_RECEIPT_TARGET_NO — NUMBER(10,0)

WYC_H_CUSTOMER_JOIN

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • CHANGE_REASON — VARCHAR2(20)

WYC_H_CUSTOMER_SERVICE_KIND

  • CUSTOMER_NO — NUMBER(10,0) — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • START_DT — DATE — NOT NULL
  • END_DT — DATE — NOT NULL
  • SERVICE_KIND — NUMBER(2,0) — NOT NULL

WYC_H_FOOTHOLD_KIND

  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • FOOTHOLD_KIND — NUMBER(2,0) — NOT NULL

WYC_H_TEACHER

  • TEACHER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • TEACHER_NAME — VARCHAR2(20)
  • TEACHER_ENG_NAME — VARCHAR2(20)
  • JUMIN_NO — CHAR(14)
  • SEX — NUMBER(2,0)
  • IS_MARRIED — NUMBER(2,0)
  • BANK_ACCOUNT — VARCHAR2(30)
  • BANK_CODE — CHAR(2)
  • DEPOSITOR — VARCHAR2(20)
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(100)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PHONE — VARCHAR2(14)
  • MOBILE_PHONE — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • UPDATER_KIND — NUMBER(2,0)
  • UPDATER_NO — NUMBER(10,0)
  • TEACHER_REAL_NAME — VARCHAR2(20)
  • TEACHER_REAL_NAME_CONFIRM — NUMBER(2,0)
  • IS_NEW_TEACHER_TRAINING — NUMBER(2,0)

WYC_H_TEACHER_ASSIGN

  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • TEACHER_KIND — NUMBER(2,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • TEACHER_NO — NUMBER(10,0) — NOT NULL

WYC_H_TEACHER_JOIN

  • TEACHER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • STATUS — NUMBER(2,0) — NOT NULL
  • PRE_STATUS — NUMBER(2,0)

WYC_H_TEACHER_STUDY_PLACE

  • TEACHER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — Primary key — NOT NULL
  • END_DT — DATE — Primary key — NOT NULL
  • START_DT — DATE — Primary key — NOT NULL
  • STUDY_PLACE — NUMBER(2,0) — NOT NULL

WYC_H_TEACHER_WIDE_BUSI_AREA

  • TEACHER_NO — NUMBER(10,0) — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • START_DT — DATE — NOT NULL
  • END_DT — DATE — NOT NULL
  • IS_REP_WIDE_BUSINESS_AREA — NUMBER(2,0) — NOT NULL
  • UPDATE_NO — NUMBER(10,0) — NOT NULL
  • UPDATE_KIND — NUMBER(2,0) — NOT NULL

WYC_H_WIDE_INTRO_CUSTOMER

  • INTRO_CUSTOMER_NO — NUMBER(10,0) — NOT NULL
  • KIND — NUMBER(2,0) — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • START_DT — DATE — NOT NULL
  • END_DT — DATE — NOT NULL

WYC_IN_CLASS_TEACHER_MONTH

  • YEAR_MONTH — CHAR(6) — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • TEACHER_NO — NUMBER(10,0) — NOT NULL

WYC_IS_FOOTHOLD_AGENCY

  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • IS_FOOTHOLD — NUMBER(2,0) — NOT NULL
  • REGIST_DT — DATE — NOT NULL
  • MOBILE_PHONE — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • TEACHER_NAME — VARCHAR2(20)
  • LAST_UPDATE_DT — DATE — NOT NULL

WYC_PARENT

  • CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • RELATION_KIND — NUMBER(2,0) — Primary key — NOT NULL
  • PARENT_NAME — VARCHAR2(20) — NOT NULL
  • PARENT_JUMIN_NO — CHAR(14)
  • PHONE — VARCHAR2(14)
  • MOBILE_PHONE — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(100)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PARENT_WORK_PHONE — VARCHAR2(14)
  • IS_SMS — NUMBER(2,0)
  • UPDATER_SITE_KIND — NUMBER(2,0)
  • UPDATER_KIND — NUMBER(2,0)
  • UPDATER_NO — NUMBER(10,0)
  • LAST_UPDATE_DT — DATE

WYC_PRE_BUSINESS_AREA

  • KIND — NUMBER(2,0) — NOT NULL
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20) — NOT NULL
  • GUGUN — VARCHAR2(20) — NOT NULL
  • DONG — VARCHAR2(60) — NOT NULL
  • REMAIN_ADDRESS — VARCHAR2(80)
  • X — VARCHAR2(30)
  • Y — VARCHAR2(30)
  • SENTENCE_COMMENT — VARCHAR2(100)
  • MANAGER_NO — NUMBER(10,0) — NOT NULL
  • REGIST_DT — DATE
  • LAST_UPDATE_DT — DATE

WYC_TEACHER_AGREE

  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • TEACHER_NO — NUMBER(10,0) — NOT NULL
  • AGENCY_AGREE_DT — DATE
  • TEACHER_AGREE_DT — DATE
  • STATUS — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE
  • JUMIN_NO — CHAR(14)

WYC_TEACHER_JOIN_20100202

  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • TEACHER_NO — NUMBER(10,0) — NOT NULL
  • TEACHER_GRADE_NO — NUMBER(2,0)
  • TEAM — CHAR(2)
  • STATUS — NUMBER(2,0) — NOT NULL
  • SENTENCE_COMMENT — VARCHAR2(200)
  • IS_REAL_ACTIVE — NUMBER(2,0) — NOT NULL
  • IS_EARLY_MEMBER_WHOLE_TEACHER — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • ADD_MARGIN — NUMBER(10,0)

WYC_TEACHER_JOIN_20130118

  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • TEACHER_NO — NUMBER(10,0) — NOT NULL
  • TEACHER_GRADE_NO — NUMBER(2,0)
  • TEAM — CHAR(2)
  • STATUS — NUMBER(2,0) — NOT NULL
  • SENTENCE_COMMENT — VARCHAR2(200)
  • IS_REAL_ACTIVE — NUMBER(2,0) — NOT NULL
  • IS_EARLY_MEMBER_WHOLE_TEACHER — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • ADD_MARGIN — NUMBER(10,0)
  • IS_REP_WIDE_BUSINESS_AREA — NUMBER(2,0)
  • STUDY_PLACE — NUMBER(2,0)

WYC_WIDE_BUSINESS_AREA

  • WIDE_BUSINESS_AREA_NO — NUMBER(10,0) — Primary key — NOT NULL
  • WIDE_BUSINESS_AREA_NAME — VARCHAR2(30) — NOT NULL
  • LAST_UPDATE_DT — DATE

WYC_WIDE_INTRO_CUSTOMER

  • INTRO_CUSTOMER_NO — NUMBER(10,0) — NOT NULL
  • KIND — NUMBER(2,0) — NOT NULL
  • CUSTOMER_NAME — VARCHAR2(20) — NOT NULL
  • SIDO — VARCHAR2(20) — NOT NULL
  • GUGUN — VARCHAR2(20) — NOT NULL
  • DONG — VARCHAR2(60) — NOT NULL
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PARENT_NAME — VARCHAR2(20) — NOT NULL
  • PARENT_MOBILE_PHONE — VARCHAR2(14) — NOT NULL
  • AGENCY_NO — NUMBER(10,0) — NOT NULL
  • INTRO_AGENCY_NO — NUMBER(10,0) — NOT NULL
  • LAST_UPDATE_DT — DATE

가족관계 (WYC_FAMILY_RELATION)

  • FAMILY_CUSTOMER_NO — NUMBER(10,0) — Primary key — NOT NULL
  • CUSTOMER_NO (CUSTOMER_NO2) — NUMBER(10,0) — Foreign key → 고객.CUSTOMER_NO
  • RELATION_KIND — NUMBER(2,0) — NOT NULL
  • LAST_UPDATE_DT — DATE — NOT NULL

고객 (WYC_CUSTOMER)

  • CUSTOMER_NO — NUMBER(10,0) — Primary key
  • JUMIN_NO — CHAR(14)
  • CUSTOMER_NAME — VARCHAR2(20)
  • MCOD — CHAR(7)
  • SEX — NUMBER(2,0) — NOT NULL
  • SCHOOL — VARCHAR2(50)
  • SCHOOL_YEAR — NUMBER(2,0)
  • ZIP_CODE — VARCHAR2(7) — NOT NULL
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(100)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PHONE — VARCHAR2(14)
  • MOBILE_PHONE — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • UPDATER_KIND — NUMBER(2,0) — NOT NULL
  • UPDATER_NO — NUMBER(10,0) — NOT NULL
  • SCHOOL_CODE — NUMBER(10,0)
  • REAL_NAME_CONFIRM_STATUS — NUMBER(2,0)
  • LAST_UPDATE_DT — DATE — NOT NULL
  • EN_NICK_NAME — VARCHAR2(50)
  • DI — CHAR(64)
  • REAL_BIRTHDAY — VARCHAR2(10)
  • BIRTH_YMD — VARCHAR2(10)
  • REGAL_DONG_CODE — VARCHAR2(20)
  • ADRESS_KIND — VARCHAR2(5)

고객이력 (WYC_H_CUSTOMER)

  • 고객번호 (CUSTOMER_NO) — NUMBER(10,0) — Primary key — NOT NULL
  • 종료일시 (END_DT) — DATE — Primary key — NOT NULL
  • 시작일시 (START_DT) — DATE — Primary key — NOT NULL
  • CUSTOMER_NAME — VARCHAR2(20)
  • JUMIN_NO — CHAR(14)
  • MCOD — CHAR(18)
  • SEX — NUMBER(2,0)
  • SCHOOL — VARCHAR2(50)
  • SCHOOL_YEAR — NUMBER(2,0)
  • ZIP_CODE — CHAR(7)
  • SIDO — VARCHAR2(20)
  • GUGUN — VARCHAR2(20)
  • DONG — VARCHAR2(100)
  • REMAIN_ADDRESS — VARCHAR2(80)
  • PHONE — VARCHAR2(14)
  • MOBILE_PHONE — VARCHAR2(14)
  • EMAIL — VARCHAR2(50)
  • UPDATER_KIND — NUMBER(2,0)
  • UPDATER_NO — NUMBER(20,0)
  • SCHOOL_CODE — NUMBER(20,0)
  • REAL_NAME_CONFIRM_STATUS — NUMBER(2,0)