留学评估数据库设计.doc

Ahui第 3 页2019/2/19留学评估数据库设计表名：extra_abroad(对外合作项目表前缀加上extra)表名列名数据类型功能extra_abroadIDNUMBER编号2nameVARCHAR2(20)姓名3sexVARCHAR2(2)性别4B_yearNUMBER出生年5B_monthNUMBER出生月6B_dayNUMBER出生日7degreeVARCHAR2(12)学历8SpecialityVARCHAR2(50)专业9vocationVARCHAR2(26)职业10Graduate_schoolVARCHAR2(80)毕业学校名称11Graduate_dateVARCHAR2(30)毕业时间12Study_countryVARCHAR2(30)拟留学国家(US,G,S)13Study_specialityVARCHAR2(50)拟学专业14Study_levelVarchar2(50)拟留学层次15If_ refuseVarchar2(100)是否有拒签记录16EmailVARCHAR2(50)EMAIL17telephoneVARCHAR2(60)电话18faxVARCHAR2(60)传真19PostcodeVARCHAR2(6)邮编20addressVARCHAR2(150)地址21Mark_IELTSNUMBERIELTS分数22Mark_greNUMBERGRE分数23Mark_toeflNUMBERTOEFL分数24recognizor_1_nameVARCHAR2(50)经济担保人1姓名25recognizor_1_relationVARCHAR2(50)与经济担保人1关系26recognizor_1_jobVARCHAR2(50)经济担保人1职业27recognizor_1_positionVARCHAR2(50)经济担保人1职位28recognizor_1_unitVARCHAR2(150)经济担保人1单位29recognizor_1_incomeVARCHAR2(150)经济担保人1年收入30recognizor_1_moneyVARCHAR2(150)经济担保人1担保金额31recognizor_2_nameVARCHAR2(50)经济担保人2姓名32recognizor_2_relationVARCHAR2(50)与经济担保人2关系33recognizor_2_jobVARCHAR2(50)经济担保人2职业34recognizor_2_positionVARCHAR2(50)经济担保人2职位35recognizor_2_unitVARCHAR2(150)经济担保人2单位36recognizor_2_incomeVARCHAR2(150)经济担保人2年收入37recognizor_2_moneyVARCHAR2(150)经济担保人2担保金额38recognizor_3_nameVARCHAR2(50)经济担保人3姓名39recognizor_3_relationVARCHAR2(50)与经济担保人3关系40recognizor_3_jobVARCHAR2(50)经济担保人3职业41recognizor_3_positionVARCHAR2(50)经济担保人3职位42recognizor_3_unitVARCHAR2(150)经济担保人3单位43recognizor_3_incomeVARCHAR2(150)经济担保人3年收入44recognizor_3_moneyVARCHAR2(150)经济担保人3担保金额45recognizor_savingVARCHAR2(50)担保人银行存款46recognizor_saving_memoVARCHAR2(50)担保人银行存款备注47recognizor_stockVARCHAR2(50)担保人股票48recognizor_stock_memoVARCHAR2(150)担保人股票备注49recognizor_bondVARCHAR2(50)担保人债券50recognizor_bond_memoVARCHAR2(150)担保人债券备注51recognizor_realtyVARCHAR2(50)担保人不动产52recognizor_realty_memoVARCHAR2(150)担保人不动产备注53recognizor_otherVARCHAR2(50)担保人其他54recognizor_other_memoVARCHAR2(150)担保人其他备注55recognizor_totalVARCHAR2(50)担保人合计56recognizor_total_memoVARCHAR2(150)担保人合计备注57timeDate填写时间58Send_flagChar(1)是否已发给评估公司必填: 姓名、学历、毕业学校、毕业时间、拟学专业、EMAIL地址CREATE TABLE CERNET.EXTRA_SCHOLARSHIP(ID NUMBER, NAME VARCHAR2(20), SEX VARCHAR2(2), B_YEAR NUMBER, B_MONTH NUMBER, B_DAY NUMBER, LEVEL VARCHAR2(12), SPECIALITY VARCHAR2(50), VOCATION VARCHAR2(26), GRADUATE_SCHOOL VARCHAR2(80), GRADUATE_DATE VARCHAR2(30), STUDY_COUNTRY VARCHAR2(30), STUDY_SPECIALITY VARCHAR2(50), STUDY_LEVEL VARCHAR2(50), IF_ REFUSE VARCHAR2(100), EMAIL VARCHAR2(50), TELEPHONE VARCHAR2(60), FAX VARCHAR2(60), POSTCODE VARCHAR2(6), ADDRESS VARCHAR2(150), MARK_IELTS NUMBER, MARK_GRE NUMBER, MARK_TOEFL NUMBER, RECOGNIZOR_1_NAME VARCHAR2(50), RECOGNIZOR_1_RELATION VARCHAR2(50), RECOGNIZOR_1_JOB VARCHAR2(50), RECOGNIZOR_1_POSITION VARCHAR2(50), RECOGNIZOR_1_UNIT VARCHAR2(150), RECOGNIZOR_1_INCOME VARCHAR2(150), RECOGNIZOR_1_MONEY VARCHAR2(150), RECOGNIZOR_2_NAME VARCHAR2(50), RECOGNIZOR_2_RELATION VARCHAR2(50), RECOGNIZOR_2_JOB VARCHAR2(50), RECOGNIZOR_2_POSITION VARCHAR2(50), RECOGNIZOR_2_UNIT VARCHAR2(150), RECOGNIZOR_2_INCOME VARCHAR2(150), RECOGNIZOR_2_MONEY VARCHAR2(150), RECOGNIZOR_3_NAME VARCHAR2(50), RECOGNIZOR_3_RELATION VARCHAR2(50), RECOGNIZOR_3_JOB VARCHAR2(50), RECOGNIZOR_3_POSITION VARCHAR2(50), RECOGNIZOR_3_UNIT VARCHAR2(150), RECOGNIZOR_3_INCOME VARCHAR2(150), RECOGNIZOR_3_MONEY VARCHAR2(150), RECOGNIZOR_SAVING VARCHAR2(50), RECOGNIZOR_SAVING_MEMO VARCHAR2(50), RECOGNIZOR_STOCK VARCHAR2(50), RECOGNIZOR_STOCK_MEMO VARCHAR2(150), RECOGNIZOR_BOND VARCHAR2(50), RECOGNIZOR_BOND_MEMO VARCHAR2(150), RECOGNIZOR_REALTY VARCHAR2(50), RECOGNIZOR_REALT