1 / 17

Create Table sys_Teacher -- 教学在线教师数据表 ( ID varchar(50), Name varchar(50),

Create Table sys_Teacher -- 教学在线教师数据表 ( ID varchar(50), Name varchar(50), Pass varchar(50), Directory varchar(200), -- 虚拟目录 ShowUp varchar(2) default ' 是 ', -- 是否显示上传 ShowWeb varchar(2) default ' 是 ', -- 是否显示网页 UpFileCoverage varchar(2) default ' 是 ', -- 上传文件是否覆盖

vernon-rowland
Download Presentation

Create Table sys_Teacher -- 教学在线教师数据表 ( ID varchar(50), Name varchar(50),

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Create Table sys_Teacher --教学在线教师数据表 • ( • ID varchar(50), • Name varchar(50), • Pass varchar(50), • Directory varchar(200), --虚拟目录 • ShowUp varchar(2) default '是', --是否显示上传 • ShowWeb varchar(2) default '是', --是否显示网页 • UpFileCoverage varchar(2) default '是', --上传文件是否覆盖 • ClickNum int default 0, • IsAdmin varchar(2) default '否', --是否为管理员 • Check (ShowUp='是' or ShowUp='否'), • Check (ShowWeb='是' or ShowWeb='否'), • Check (UpFileCoverage='是' or UpFileCoverage='否'), • Check (IsAdmin='是' or IsAdmin='否'), • Primary Key(ID) • )

  2. 学生数据表 • Create Table sys_Student • ( • ID varchar(50), • Name varchar(50), • Pass varchar(50), • Class varchar(200), • Primary Key(ID) • )

  3. 登录视图 • Create View v_sys_Login(ID, Name, Pass, Kind, IsAdmin) • AS • Select ID, Name, Pass, 'T', IsAdmin From sys_Teacher • Union • Select ID, Name, Pass, 'S', '否' From sys_Student • GO

More Related