[計(jì)算機(jī)]畢業(yè)設(shè)計(jì)管理系統(tǒng)需求分析與架構(gòu)設(shè)計(jì)(編輯修改稿)
2024-10-20 11:46 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 [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 教師職稱(chēng)表： 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 班級(jí)表： 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 學(xué)生表： 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 學(xué)生志愿表： 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
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1