[计算机]毕业设计管理系统需求分析与架构设计内容摘要:

[DepartmentNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [DepartmentName] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [DepartmentType] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED 教师职称表: CREATE TABLE [dbo].[Title]( [TitleNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [TitleName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, CONSTRAINT [PK_Title] PRIMARY KEY CLUSTERED 教师表: CREATE TABLE [dbo].[Teacher]( [UserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Password] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [FullName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [DepartmentNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [EMail] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Phone] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [Mobile] [nvarchar](15) COLLATE Chinese_PRC_CI_AS NULL, [Title] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Role] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Teacher] PRIMARY KEY CLUSTERED 班级表: CREATE TABLE [dbo].[Class]( [ClassNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NOT NULL, [ClassTutor] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Class] PRIMARY KEY CLUSTERED 学生表: CREATE TABLE [dbo].[Student]( [UserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [Password] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [FullName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [ClassNO] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [EMail] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Phone] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, [Mobile] [nvarchar](15) COLLATE Chinese_PRC_CI_AS NULL, [TeacherNO] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL, CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED 学生志愿表: CREATE TABLE [dbo].[StudentAssignment]( [AssignmentID] [int] IDENTITY(1,1) NOT NULL, [StudentUserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, [TeacherUserName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL, Page15/17。
阅读剩余 0%
本站所有文章资讯、展示的图片素材等内容均为注册用户上传(部分报媒/平媒内容转载自网络合作媒体),仅供学习参考。 用户通过本站上传、发布的任何内容的知识产权归属用户或原始著作权人所有。如有侵犯您的版权,请联系我们反馈本站将在三个工作日内改正。