校务系统数据库字典.doc

database dictionary report校务系统数据字典表名表说明acarda卡信息表adminlog数据库备份日志表bumen部门信息表changelog员工调动日志表changetype员工调动类型表chengji学生考试科目信息表churuclass班级库churulog学校仓库物品出入日志class班级信息表classlog学生班级调整日志表classroom教室信息表classsubject班级科目（这个不使用，留着备用）clientinfo客户信息（这个不使用，留着备用）commment评论信息（这个不使用，留着备用）coursehour（这个不使用，留着备用）courseplan（这个不使用，留着备用）dianmi学生点名信息表dorm（这个不使用，留着备用）dormfloor（这个不使用，留着备用）employeedel存放被删除员工信息表employeeinfo员工信息表examscore（这个不使用，留着备用）examtype（这个不使用，留着备用）goodlog（这个不使用，留着备用）goodsinfo物品信息表goodstype物品类型表gzrecorda卡跟踪记录表hourstate时段信息表hr人力资源考核hygoods会员商品表hygoodstype会员商品类型表hzlog汇总日志表，每一天的汇总信息都存放在这张表jfconfig会员积分设置表jflevel会员积分等级表jflog会员积分日志表jiaofei缴费表jiaofeilog学生缴费日志表，所有学生缴费信息包括续班缴费都在这张表jiaofuxs教辅销售表jindu教师教学进度表jindudetail教师教学进度明细表khitem人力资源考核明细项目表，具体评分knowledge教研学科组信息表leaveemployeeinfo（这个不使用，留着备用）leavegrade（这个不使用，留着备用）leavestudent（这个不使用，留着备用）marriage（这个不使用，留着备用）orderhis订货包括订书历史记录表orderinfo订货包括订书信息表payslog工资发放明细日志表paystructure薪资约定planinfo（这个不使用，留着备用）plantype（这个不使用，留着备用）popedom用户权限设置表provider供应商信息表qiandao教师添加课时信息表role系统角色信息表sleepinfo（这个不使用，留着备用）speciality员工专业类型信息表stationtype员工职务类型信息表statustype（这个不使用，留着备用）student学生信息表studentgrade学生考试类型表subject课程科目信息表systeminfo软件系统信息表userinfo系统用户信息表wagerecord（这个不使用，留着备用）xuejilog学籍调整日志表xueli员工学历类型表zhichentype员工职称类型表zsjflog赠送积分日志表acard序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1cardidint41002writemanvarchar505003writedatedatetime8233(getdate()4studentnamevarchar505005birthdaydatetime82336telephonevarchar505007schoolvarchar10010008gradevarchar505009wherestudyvarchar100100010howlongvarchar5050011purposevarchar3030012nenlivarchar5050013familyinfovarchar100100014fathervarchar2020015fworkplacevarchar200200016fphonevarchar2020017mothervarchar2020018mworkplacevarchar200200019mphonevarchar2020020whereknowvarchar2020021methodvarchar2020022baomingdatedatetime823323baomingclassvarchar2020024zhuanyuanvarchar2020025jsstuidint410026alevelvarchar22027meanvarchar5050028areavarchar100100029bmmethodvarchar5050030dm_teachervarchar5050031st_classvarchar5050032st_teachervarchar5050033sd_teachervarchar50500adminlog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1objectidint41002log_tablenamevarchar505003log_namevarchar505004log_datedatetime8233(getdate()5log_useridvarchar505006log_descvarchar5005000bumen序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1bumenidint41002bumennamevarchar505003fuzerenvarchar50500changelog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1logidint41002employeeidint41003employeenamevarchar505004beforetypeidvarchar505005aftertypeidvarchar505006useridvarchar505007changedatedatetime82338remarktext1621474836470changetype序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1typeidint41002typenamevarchar20200chengji序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1subjectidint41002subjectnamevarchar50500churuclass序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1chuidint41002goodstypevarchar505003goodsidvarchar505004numsint41005typesvarchar101006stunoint41007departidvarchar505008classnamevarchar505009useridvarchar5050010churudatedatetime8233(getdate()11remarktext1621474836470churulog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1chuidint41002goodstypevarchar505003goodsidvarchar505004numsint41005typesvarchar505006jinshourenvarchar505007departidvarchar505008classnamevarchar505009useridvarchar5050010churudatedatetime8233(getdate()11isclassvarchar22012remarktext1621474836470class序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1classidint41002classnamevarchar505003employeeidint41004weekenvarchar10010005hourstatevarchar10010006zerenint41007totalkeshiint41008remarktext16214748364709stardatedatetime823310enddatedatetime823311zhonwaivarchar5050012classroomvarchar50500classlog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1logidint41002studentidint41003studentnamevarchar505004beforeclassidvarchar5505afterclassidvarchar505006useridvarchar505007changedatevarchar505008remarkvarchar2562560classroom序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1classroomidint41002classnamevarchar50500classsubject序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1csubjectidint41002classidint41003subjectidint4100clientinfo序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1clientidint41002clientnamevarchar505003telephonevarchar202004companyvarchar10010005dutyvarchar202006emailvarchar505007addressvarchar1001000commment序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1commmentidint41002studentidint41003classnamevarchar505004termcommmenttext16214748364705lastcommmenttext1621474836470coursehour序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1houridint41002coursenamevarchar50500courseplan序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1courseidint41002classidvarchar505003houridint41004teacheridvarchar505005subjectidvarchar10010006classroomidvarchar505007weekdaysvarchar20200dianmi序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1dmidint41002stnumint41003classnamevarchar505004weekenvarchar505005hourstateint41006employeeidvarchar505007timesdatetime8233(getdate()8statevarchar505009classroomvarchar5050010stardatedatetime823311enddatedatetime823312shiduanvarchar50500dorm序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1dormidint41002dormnamevarchar505003flooridint41004tiptopint41005presentint4100dormfloor序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1flooridint41002floornamevarchar50500employeedel序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1employeeidint41002employeenamevarchar505003englishnamevarchar505004gendervarchar5505nationvarchar505006birthdayvarchar505007xueliidvarchar202008picturevarchar25625609polityvarchar2020010marriageidvarchar1010011specialityidvarchar5050012workdatevarchar5050013joindatevarchar5050014zhichenidvarchar2020015stationidvarchar2020016identitycardvarchar3030017telephonevarchar2020018addressvarchar200200019hendsetvarchar2020020nativeplacevarchar2020021hujiaddressvarchar256256022resumetext162147483647023otherinfotext162147483647024changetypevarchar2020025typevarchar2020026bumenvarchar20200employeeinfo序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1employeeidint41002employeenamevarchar505003englishnamevarchar505004gendervarchar5505nationvarchar505006birthdayvarchar505007xueliidvarchar202008picturevarchar25625609polityvarchar2020010marriageidvarchar1010011specialityidvarchar5050012workdatevarchar5050013joindatevarchar50500(getdate()14zhichenidvarchar2020015stationidvarchar2020016identitycardvarchar3030017telephonevarchar2020018addressvarchar200200019hendsetvarchar2020020nativeplacevarchar2020021hujiaddressvarchar256256022resumetext162147483647023otherinfotext162147483647024changetypevarchar2020025typevarchar2020026bumenvarchar20200examscore序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1scoreidint41002subjectidint41003scorelineint4100examtype序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1typeidint41002typenamevarchar50500goodlog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1logidint41002goodnamevarchar505003amountint41004typevarchar505005datesvarchar505006operatorvarchar505007useridvarchar505008bumenvarchar50500goodsinfo序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1goodsidint41002typenamevarchar505003goodsnamevarchar505004descripttext16214748364705measurevarchar202006provideridvarchar505007currentstockint41008managervarchar505009adddatevarchar50500(getdate()goodstype序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1typeidint41002goodsnamevarchar505003parentidint4100gzrecord序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1recordidint41002cardidint41003recordinfotext16214748364704writedatevarchar50500hourstate序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1stateidint41002statevaluevarchar50500hr序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1hridint41002employeeidvarchar505003jibievarchar505004departvarchar505005zhibievarchar505006yearsvarchar50500hygoods序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1hygidint41002goodsnamevarchar505003typeidint41004unitvarchar505005jifenint41006gnumint41007gdatedatetime8233(getdate()8moneysmoney8194(0)hygoodstype序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1typeidint41002typenamevarchar50500hzlog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1hzidint41002datesdatetime8233(getdate()3classnamevarchar505004shiduanvarchar10010005jiaofeiint41006xianyouint41007yuanint41008chaint41009zhuanint410010liuint410011chongint410012baoliuint410013zerenvarchar5050014jiaoshivarchar5050015renkevarchar5050016keshivarchar5050017qizhivarchar5050018chengfavarchar5050019yishangvarchar5050020suoyouvarchar50500jfconfig序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1jfcidint41002cnamevarchar505003cvaluevarchar505004cdescvarchar50500jflevel序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1levelidint41002levelnamevarchar505003levelminint4100(0)4levelmaxint4100(0)5dixianint4100(0)6syjfint41007duihuanint41008syjf2int41009jiaocaifeiint4100jflog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1jflogidint41002stunoint41003classidint41004cardidvarchar505005typesvarchar505006jfnumint4100(0)7useridvarchar505008jdescvarchar5005000()9jdatedatetime8233(getdate()10gidint410011moneysmoney8194(0)jiaofei序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1jfidint41002stunoint41003moneysvarchar50500jiaofeilog序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1jfidint41002classidint41003stunoint41004keshiint41005shijikeshiint41006yingjiaovarchar50500(0)7xuefeivarchar50500(0)8jiaocaifeivarchar50500(0)9shijiaovarchar50500(0)10qianfeivarchar50500(0)11shoujuvarchar5050012shoukuanrenvarchar5050013isjiaofeivarchar220(是)14adddatedatetime8233(getdate()15opravarchar5050016countsint410017remarktext162147483647018qujianvarchar5050019jiao1varchar50500(0)20jiao2varchar50500(0)21jiao3varchar50500(0)22jiao4varchar50500(0)23qinkuanvarchar5050024isyuvarchar50500(否)25yuanclassint4100jiaofuxs序号字段名标识主键类型长度精度小数位数允许空默认值字段说明1xsidint41002xstypevarchar505003xsnamevarchar505004xsnumint41005pricevarchar505006totalvarchar505007