教務(wù)管理數(shù)據(jù)庫設(shè)計說明書(存儲版)
【正文】 nullKindnvarchar20Not nullCreaditsdecimal18,0Not nullTIDintNot null4.Dep字段名數(shù)據(jù)類型長度空值備注DIDintNot null主鍵DNamenvarchar20Not null5.Manager字段名數(shù)據(jù)類型長度空值備注MIDintNot null主鍵MNamenvarchar20Not nullMPwdchar10Not null6.News字段名數(shù)據(jù)類型長度空值備注NIDintNot null主鍵NTitlenvarchar200Not nullNContextNot nullNTimesmalldatetimeNot nullTIDint null7.SC字段名數(shù)據(jù)類型長度空值備注Snovarchar20notnullC_IDintnotnullC_Gradesmallintnull8.SClass字段名數(shù)據(jù)類型長度空值備注CIDintNot null主鍵CCountintNot nullCNamenvarchar20Not nullDIDintNot null9.stuinfo字段名數(shù)據(jù)類型長度空值備注Sno varchar20Not null主鍵SNamenvarchar20Not nullCIDint Not nullSCardIDvarchar20Not nullSBirth smalldatetimeSAddressnvarchar50Not nullSMembershipnvarchar10Not nullSStatenchar10Not nullSClassintNot nullSIsRegbitNot nullSIsSkipintNot nullSAwardntextNot nullSCostbitSPwdNvarchar5010．teacher字段名數(shù)據(jù)類型長度空值備注TIDintNot null主鍵TNamenvarchar20nullTPostvarchar20nullTDepintnull11.Parents字段名數(shù)據(jù)類型長度空值備注Snovarchar20Not nullParentsNamevarchar20Not nullParentsEmailvarchar50Not null/*==============================================================*//*1. Table: BackInfo *//*==============================================================*/create table BackInfo ( BID int not null, BCon text null, BTime smalldatetime null, constraint PK_BACKINFO primary key (BID))/*====
公司管理相關(guān)推薦
鄂ICP備17016276號-1