slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Create Table sys_Teacher -- 教学在线教师数据表 ( ID varchar(50), Name varchar(50), PowerPoint Presentation
Download Presentation
Create Table sys_Teacher -- 教学在线教师数据表 ( ID varchar(50), Name varchar(50),

Loading in 2 Seconds...

play fullscreen
1 / 17

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


  • 110 Views
  • Uploaded on

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 ' 是 ', -- 上传文件是否覆盖

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Create Table sys_Teacher -- 教学在线教师数据表 ( ID varchar(50), Name varchar(50),' - vernon-rowland


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide10
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)
  • )
slide11
学生数据表
  • Create Table sys_Student
  • (
  • ID varchar(50),
  • Name varchar(50),
  • Pass varchar(50),
  • Class varchar(200),
  • Primary Key(ID)
  • )
slide12
登录视图
  • 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