【正文】 lues(39。, 39。, 39。)insert Education values (39。, 39。, 39。)insert Education values(39。, 39。, 39。)insert Education values (39。, 39。, 39。)insert Education values(39。, 39。, 39。)insert Education values (39。, 39。, 39。)insert Education values(39。, 39。, 39。)insert Education values (39。, 39。, 39。)insert Education values(39。, 39。, 39。插入學生信息表插入學生教育經(jīng)歷（Education）表insert Education values (39。000000000039。000000002039。000000000039。000000001939。000000000039。000000001839。000000000039。000000001739。000000000039。000000001639。000000000039。000000001539。000000000039。000000001439。000000000039。000000001339。000000000039。000000001239。000000000039。000000001139。000000000039。000000001039。000000000039。000000000939。000000000039。000000000839。000000000039。000000000739。000000000039。000000000639。000000000039。000000000539。000000000039。000000000439。000000000039。000000000339。000000000039。000000000239。000000000039。000000000139。000000000039。0000139。000000000039。201012101639。000000000039。201012101539。000000000039。201012101439。000000000039。201012101339。000000000039。201012101239。000000000039。201012101139。000000000039。201012101039。000000000039。201012100939。000000000039。201012100839。000000000039。201012100739。000000000039。201012100639。000000000039。201012100539。000000000039。201012100439。000000000039。201012100339。000000000039。201012100239。000000000039。201012100139。建筑39。北京田園建筑公司39。000000002039。食品39。雙匯39。000000001939。電腦39。三星39。000000001839。電腦39。方正39。000000001739。互聯(lián)網(wǎng)39。凡客39。000000001639?；ヂ?lián)網(wǎng)39。江民39。000000001539。互聯(lián)網(wǎng)39。金山39。000000001439?；ヂ?lián)網(wǎng)39。騰訊39。000000001339。銀行39。成都銀行39。000000001239。銀行39。中國招商銀行39。000000001139。運輸39。中國高鐵39。000000001039。運輸39。中國鐵路39。000000000939。金融39。中國銀行39。000000000839。金融39。中國工業(yè)銀行39。000000000739。運輸39。中國航空39。000000000639。運輸39。中國航天39。000000000539。金融39。中國建設銀行39。000000000439。金融39。中國農(nóng)業(yè)銀行39。000000000339。石油39。中國石化39。000000000239。保險39。中國人壽39。000000000139。成都信息工程學院39。0000139。男39。王國要39。201012101639。女39。復來語39。201012101539。女39。江燕39。201012101439。男39。方要39。201012101339。女39。樊霞39。201012100839。男39。吳天剛39。201012101039。男39。陳方39。201012101239。女39。商玉玲39。201012100939。女39。尹紫39。201012101139。女39。魏小敏39。201012100739。女39。趙艷39。201012100539。男39。嚴子義39。201012100639。男39。李四39。201012100439。男39。張四39。201012100339。男39。李三39。201012100239。男39。張三39。201012100139。為學生在校獎勵和處罰(StuSchoolRewardPunish)表創(chuàng)建唯一聚集索引create unique clustered index idx_StuSchoolRewardPunishon StuSchoolRewardPunish(cStudentsId)為學校用戶(SchoolUsers)表創(chuàng)建唯一聚集索引create unique clustered index idx_SchoolUserson SchoolUsers(cSchoolId)為招聘信息(RecruitmentInformation)表創(chuàng)建唯一聚集索引create unique clustered index idx_RecruitmentInformationon RecruitmentInformation(cCompanyId)為學生教育經(jīng)歷(Education)表創(chuàng)建唯一聚集索引create unique clustered index idx_Educationon Education(cStudentsId)為學生求職信息(ApplyJobInformation)表創(chuàng)建唯一聚集索引create unique clustered index idx_ApplyJobInformationon ApplyJobInformation(cStudentsId)學生信息創(chuàng)建學生教育經(jīng)歷(Education)表create table Education(cStudentsId char(10) NOT NULL,vEducationUndergo varchar(100) NOT NULL,vTrainUndergo varchar(100) NULL)alter table Educationadd constraint fkEducation foreign key(cStudentsId)referencesStudents(cStudentsId)創(chuàng)建學生求職信息(ApplyJobInformation)表create table ApplyJobInformation(vExpectWorkPlace varchar(30) NULL,vIndustry varchar(70) NOT NULL,cPosition char(50) NOT NULL,dApplyTime datetime NOT NULL,cStudentsId char(10) NOT NULL,mSalary money NULL)alter table ApplyJobInformationadd constraint fkApplyJobInformation foreign key(cStudentsId)references Students(cStudentsId)alter table add msalary money null創(chuàng)建學生聯(lián)系方式(StudentContact)表create table StudentContact(cStudentId char(10) NOT NULL,vStuConAddress varchar(100) NULL,cStuPhone char(11) NOT NULL,vStuMailAddress varchar(70) NULL)alter table StudentContactadd constraint fkStudentContact foreign key(cStudentId)referencesStudents(cStudentsId)alter table StudentContactadd constraint unqStuPhone unique(cStuPhone)alter table StudentContactadd constraint unqStuMailAddress unique(vStuMailAddress)創(chuàng)建學生在校(StudentsSchool)表create table StudentsSchool(cStudentsId char(10) NOT NULL,dStuEnteTime datetime NOT NULL,vStuMajor varchar(40) NOT NULL,dStuFinTime datetime NOT NULL)alter table StudentsSchooladd constraint fkStudentsSchool foreign key(cStudentsId)references Students(cStudentsId)創(chuàng)建學生在校獎勵和處罰(StuSchoolRewardPunish)表create table StuSchoolRewardPunish(cStudentsId char(10) NOT NULL,vStuReward varchar(100) NULL,vStuPunish varchar(100) NULL,vStuSchPost varchar(100) NULL,vCertificate varchar(50) NULL)alter table StuSchoolRewardPunishadd constraint fkStuSchoolRewardPunish foreign key(cStudentsId)references Students(cStudentsId) 創(chuàng)建學生介紹自己(IntroduceYourself)表create table IntroduceYourself(cStudentsId char(10) NOT NULL,vSelfAssessment varchar(100) NOT NULL,vSelfSpecialty varchar(100) NULL,vHobbiesInterest varchar(100) NULL)alter table introduceYourselfadd constraint fkIntroduceYourself foreign key (cStudentsId)referencesStudents(cStudentsId)學校信息創(chuàng)建學校聯(lián)系方式(SchoolContact)表create table SchoolContact(cSchoolId char(5) NOT NULL,vSchMailAddress varchar(70) NOT NULL)alter table SchoolContactadd constraint fkSchoolContact foreign key(cSchoolId) referencesSchool(cSchoolId)alter table SchoolContactadd constraint unqSchMailAddress unique (vSchMailAddress)創(chuàng)建學校通知(Notice)表create table Notice(cNoticeNo smallint NOT NULL,vNoticeTheme varchar(100) NOT NULL,dNoticeTime datetime NOT NULL,dThingTime datetime NOT NULL,vThingPlace varchar(80) NOT NULL,vThingContent varchar(200) NULL,vNoticeDepartment varchar(40) NOT NULL,constraint constraint_Notice primary key(cNoticeNo))創(chuàng)建學校用戶(Schoolusers)表create table Schoolusers(cSchoolId char(5) NOT NULL,cSchoolCode char(10) NOT NULL)alter table Schoolusersadd constraint fkSchoolusers foreign key(cSchoolId)referencesSchool(cSchoolId)創(chuàng)建公司（Company)表create table Company(cCompanyId char(10) NOT NULL,vCompanyName varchar(30) NOT NULL,vCompanyIndustry varchar(30) NOT NULL,constraint constraint_Company primary key(cCompanyId))alter table Companyadd constraint unqCompany unique(cCompanyId)②創(chuàng)建實體用戶表)))alter table Studentsadd constraint unqStudents unique(cStudentsId),39。創(chuàng)建學生(Students)表create table Students(cStudentsId char(10) NOT NULL,iStuImage image NULL,vStuName varchar(20) NOT NULL,cStuSex char(5) NOT NULL,sStuAge smallint NULL,constraint constraint_Studetns primary key(cStudentsId),check(sStuAge between 0 and 100),constraint chkStuSex check(cStuSex