PHP教材數(shù)據(jù)庫設(shè)計(jì).docVIP

教材管理系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)表xueshengxuehaoxingmingbanjixiuser_namepassword表laoshijiaoshihaoxinmingxiuser_namepassword表xixingmingxiuser_namepassword表adminnameuser_namepassword教材教材編號(hào),教材名,作者,出版社及版本號(hào)表jiaocaijcbianhaojcmingzuozhecbshebanben征訂訂單號(hào),教材編號(hào),教材名,作者,出版社及版本號(hào),征訂時(shí)間,征訂人,所訂班級(jí),征訂數(shù)量表zhengdingdingdanjcbianhaojcmingzuozhecbshebanbenshijianzdrenszbanjjizdshuliang入庫:教材編號(hào),教材名,作者,出版社及版本號(hào),市場價(jià),實(shí)購價(jià),數(shù)量,入庫時(shí)間.表rukujcbianhaojcmingzuozecbshebanbenscjiasgjiasuliangrukushijian發(fā)放時(shí)間領(lǐng)書人所屬班級(jí)數(shù)量表fafangshijianlsrenssbanjiffshulian實(shí)體:學(xué)生老師系級(jí)人員管理員征訂入庫發(fā)放實(shí)體:xueshenglaoshixiadminzhengdingrukufafang學(xué)生屬性學(xué)號(hào),姓名,班級(jí),系,賬號(hào),密碼老師屬性教師號(hào),姓名,系,賬號(hào),密碼系級(jí)人員屬性姓名,系,賬號(hào),密碼管理員屬性姓名,賬號(hào),密碼征訂屬性訂單號(hào),教材編號(hào),教材名,教材類型,作者,出版社及版本號(hào),征訂時(shí)間,征訂人,所訂班級(jí),征訂數(shù)量入庫屬性教材編號(hào),教材名,作者,出版社及版本號(hào),市場價(jià),實(shí)購價(jià),數(shù)量,入庫時(shí)間.發(fā)放屬性時(shí)間領(lǐng)書人所屬班級(jí)數(shù)量-phpMyAdminSQLDump-version2.10.2--主機(jī):localhost-生成日期:2008年04月18日06:31-服務(wù)器版本:5.0.45-PHP版本:5.2.3SETSQL_MODE=NO_AUTO_VALUE_ON_ZERO；-數(shù)據(jù)庫:jck-表的結(jié)構(gòu)admin-CREATETABLEadmin(namevarchar(20)NOTNULLCOMMENT管理員姓名,user_namevarchar(50)NOTNULLCOMMENT登錄名,passwordvarchar(20)NOTNULLCOMMENT密碼)ENGINE=MyISAMDEFAULTCHARSET=utf8；-導(dǎo)出表中的數(shù)據(jù)admin-表的結(jié)構(gòu)fafang-CREATETABLEfafang(shijiandateNOTNULLCOMMENT時(shí)間,lsrenvarchar(30)NOTNULLCOMMENT領(lǐng)書人,ssbanjivarchar(30)NOTNULLCOMMENT所屬班級(jí),ffsuliangvarchar(10)NOTNULLCOMMENT數(shù)量)ENGINE=MyISAMDEFAULTCHARSET=utf8；-導(dǎo)出表中的數(shù)據(jù)fafang-表的結(jié)構(gòu)laoshi-CREATETABLElaoshi(jiaoshihaovarchar(20)NOTNULLCOMMENT教師號(hào),xingmingvarchar(20)NOTNULLCOMMENT姓名,xivarchar(20)NOTNULLCOMMENT系號(hào),user_namevarchar(50)NOTNULLCOMMENT登錄名,passwordvarchar(20)NOTNULLCOMMENT密碼)ENGINE=MyISAMDEFAULTCHARSET=utf8；-導(dǎo)出表中的數(shù)據(jù)laoshi-表的結(jié)構(gòu)ruku-CREATETABLEruku(jcbianhaovarchar(50)NOTNULLCOMMENT教材編號(hào),jcmingvarchar(50)NOTNULLCOMMENT教材名,zuozhevarchar(30)NOTNULLCOMMENT作者,cbshevarchar(50)NOTNULLCOMMENT出版社,banbenvarchar(20)NOTNULLCOMMENT版本號(hào),scjiafloatNOTNULLCOMMENT市場價(jià),sgjiafloatNOTNULLCOMMENT實(shí)購價(jià),suliangint(10)NOTNULLCOMMENT數(shù)量,rukushijiandateNOTNULLCOMMENT入庫時(shí)間)ENGINE=MyISAMDEFAULTCHARSET=utf8；-導(dǎo)出表中的數(shù)據(jù)ruku-表的結(jié)構(gòu)xi-CREATETABLExi(xingmingvarchar(20)NOTNULLCOMMENT系管理人姓名,xivarchar(20)NOTNULLCOMMENT系號(hào),user_namevarchar(50)NOTNULLCOMMENT登錄名,passwordvarchar(20)NOTNULLCOMMENT密碼)ENGINE=MyISAMDEFAULTCHARSET=utf8；-導(dǎo)出表中的數(shù)據(jù)xi-表的結(jié)構(gòu)xushen-CREATETABLExushen(xuehaovarchar(20)NOTNULLCOMMENT學(xué)號(hào),xingmingvarchar(20)NOTNULLCOMMENT姓名,banjivarchar(20)NOTNULLCOMMENT班級(jí),xivarchar(20)NOTNULLCOMMENT系號(hào),user_namevarchar(50)NOTNULLCOMMENT登錄名,passwordvarchar(20)NOTNULLCOMMENT密碼)ENGINE=MyISAMDEFAULTCHARSET=utf8；-導(dǎo)出表中的數(shù)據(jù)xushen-表的結(jié)構(gòu)zhengding-CREATETABLEzhengding(dingdanvarchar(30)NOTNULLCOMMENT訂單號(hào),jcbianhaovarchar(30)NOTNULLCOMMENT教材編號(hào),jcmingvarchar(50)NOTNULLCOMMENT教材名,jcleixinvarchar(30)NOTNULLCOMMENT教材類型,zuozhevarchar(50)NOTNULLCOMMENT作者,cbshevarchar(50)NOTNULLCOMMENT出版社,banbenvarchar(20)NOTNULLCOMMEN