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)