（企業(yè)管理套表）學生成績管理系統(tǒng)數(shù)據(jù)庫表結構說明

明字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空學號,StuID,Char(12),是,否姓名,StuName,varchar(8),否,否性別,Sex,char(2),否,否出生日期,BirthDate,datetime(8),否,否籍貫,Native,varchar(40),否,否入學時間,EntranceTime,datetime(8),否,否政治面貌,PoliticalFace,Nchar(12),否,否家庭住址,Address,Nvarchar(50),否,否個人電話,PerPhone,Nchar(11身份證號,IDNum,varchar(1照片,Photo,varbinary(max),否,否班級編號,ClassID,Char(9),否,否宿舍編號,DormitoryId,Char(4),否,否民族,National,Nchar(2),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空班級編號,ClassID,char(9),是,否班級名稱,ClassName,varchar(20),否,否人數(shù),Num,tinyint(1),否,否專業(yè)編號,SpecializeID,char(2),否,否系部編號,DepartmentID,char(2),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空專業(yè)編號,SpecializeID,char(2),是,否專業(yè)名稱,SpecializeName,varchar(20),否,否系部編號,DepartmentID,char(2),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空系部編號,DepartmentID,char(2),是,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,char(10),是,否性別,Sex,char(2),否,否出生日期,BirthDate,datetime(8),否,否政治面貌,PoliticalFace,varchar(8),否,否籍貫,Native,varchar(40),否,否民族,National,Nchar(2),否,否電子郵箱,Email,Varchar(50),否,否身份證號,IDNum,varchar(18),否,否照片,Photo,varbinary(max),否,否第壹學歷,FirstDegree,char(4),否,否最高學歷,HighestDegree,char(4),否,否職務,Position,Narchar(8),否,否備注,Notes,varchar(255),否,是字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空課程編號,CourseID,char(8),是,否課程性質,CourseNature,char(10),否,否學分,Credits,tinyint(1),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空用戶名,UserName,varchar(1密碼,Pwd,varchar(10),否,否用戶組編號,GroupID,bit(1),否,否刪除標記,DeleteMarkers,varchar(20),否,是字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(10),是,否課程編號,CourseID,char(8),是,否班級編號,ClassID,char(9),是,否學期,Term,tinyint(1),否,否教室編號,ClassroomID,varchar(10),否,否每周學時,WeeklyHours,tinyint(1),否,否學期工作量,TermWorkload,tinyint(3),否,否午別,WuBie,Vchar(2),否,否節(jié)次,JieCi,Char(2),否,否備注,Notes,varchar(255),否,是字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空學期,Term,tinyint(1),是,否系部編號,DepartmentID,char(2),否,否專業(yè)編號,SpecializeID,char(2),否,否課程編號,CourseID,char(8),否,否起始周,StartWeek,tinyint(1),否,否結束周,EndWeek,tinyint(1),否,否理論學時,TheoryHours,tinyint(1),否,否實踐學時,PracticeHours,tinyint(1),否,否總學時,SumHours,tinyint(1),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空學期,Term,tinyint(1),是,否學號,StuID,char(12),否,否課程編號,CourseID,char(8),否,否考試成績,ExamGrade,Tinyint(1),否,否平時成績,ParTGrade,Tinyint(1),,期評,Grade,Tinyint(1),,字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空自動編號,RewardPunID,Int(4),是,否學號,StuID,char(12),否,否學期,Term,tinyint(1),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教室類型,ClassroomType,varchchar(10),否,否備注,Notes,Varchar(255),否,是字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空實訓編號,TrainingID,Varchar(10),是,否實訓地點,TrainingPlace,Varchar(50),否,否實訓費用,TrainingCost,Char(5),否,否實訓時間,TrainingTime,Datetime,否,否實訓情況,TrainingSituation,Varchar(50),否,否備注,Notes,Varchar(255),否,否,,,否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空實訓編號,TrainingID,Varchar(10),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否專業(yè)方向,ProDirection,Varchar(20),否,否學位,Degree,Vchar(20),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否論文標題,PaperTitle,Vchar(100),否,否性質,PaperNature,Varchar(20),否,否發(fā)表刊物,PublishAtions,Varchar(20),否,否發(fā)表時間,PublishTime,Datetime,否,否卷號,RollNum,Char(4),否,否字數(shù),Words,Char(12),否,否單位排序,UnitSorting,Char(10),否,否作者排序,AuthorSorting,Char(10),否,否刊物性質,AtionsNature,Char(10),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否科研項目,KeYProjects,Varchar(50),否,否科研類型,KeYType,Varchar(20),否,否結項時間,JieXTime,Datetime,否,否資助金額,Grants,Char(20),否,否項目編號,ProjectsNum,Char(20),否,否主持人,Hoster,Vchar(8),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否職稱,ZhiCh,Vchar(12),否,否現(xiàn)所于單位,NowUnit,Varchar(30),否,否備注,Notes,Varchar(255),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否進修訪問地點,StudyVisitPlace,Varchar(50),否,否時間,StudyTime,Varchar(20),否,否性質,StudyNature,Vchar(20),否,否身份,Identity,Vchar(20),否,否兼職情況,PartTimeJob,Vchar(20),否,否備注,Notes,Varchar(255),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否授予單位,GrantUnit,Varchar(20),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否學年學期,SchoolSemester,Char(4),否,否上課系部,ClassDepartment,Vchar(20),否,否上課專業(yè),ClassPro,Vchar(20),否,否課程,Course,Vchar(20),否,否上課班級,Classroom,Vchar(20),否,否上課地點（教室）,ClassPlace,Vchar(20),否,否授課類型,ClassType,Vchar(20),否,否備注,Notes,Varchar(255),否,否字段描述,字段名,數(shù)據(jù)類型,是否主鍵,是否為空教師編號,TeacherID,Char(12),否,否學年學期,SchoolSemester,Char(4),否,否上課系部,ClassDepartment,Vchar(20),否,否上課專業(yè),ClassPro,Vchar(20),否,否課程,Course,Vchar(20),否,否上課班級,Classroom,Vchar(20),否,否上課地點（教室）,ClassPlace,Vchar(20),否,否授