表名：ZL_Courseware












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2Coursewarenvarchar500   是 课件主题
3CoursNumint40   是 课件次序
4Listenint40   是 可否试听：0为否,1为是
5UpdateTimedatetime83   是 更新时间
6FileUrlnvarchar2550   是 试听地址
7CourseIDint40   是 课程ID
8Speakernvarchar500   是 主讲人
9SJNamevarchar2550   是 设计者
10Statusint40   是 状态:0为可用;1为不可用
11Descriptionvarchar2550   是 简介
12Classificationvarchar2550   是 分类
13CoursTypeint40   是 课件类型:0为外部课件;1为SCORM标准课件
14CreationTimedatetime83   是 课件创建时间

简要说明：

课程分类表

GO
CREATE TABLE [dbo].[ZL_Courseware](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Courseware] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CoursNum] [int] NULL,
[Listen] [int] NULL,
[UpdateTime] [datetime] NULL,
[FileUrl] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[CourseID] [int] NULL,
[Speaker] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,[SJName] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Status] [int] NULL,
[Description] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Classification] [varchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[CoursType] [int] NULL,
[CreationTime] [datetime] NULL
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课件主题' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'Courseware'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课件次序' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'CoursNum'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'可否试听：0为否,1为是' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'Listen'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'UpdateTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'试听地址' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'FileUrl'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'CourseID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'主讲人' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Courseware', @level2type=N'COLUMN',@level2name=N'Speaker'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'状态:0为可用;1为不可用' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Courseware', @level2type=N'COLUMN', @level2name=N'Status'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'简介' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Courseware', @level2type=N'COLUMN', @level2name=N'Description'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'分类' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Courseware', @level2type=N'COLUMN', @level2name=N'Classification'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课件类型:0为外部课件;1为SCORM标准课件 ' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Courseware', @level2type=N'COLUMN', @level2name=N'CoursType'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课件创建时间' ,@level0type=N'USER', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Courseware', @level2type=N'COLUMN', @level2name=N'CreationTime'

--注意：将清空全表数据

detele from ZL_Courseware

--注意：将删除整个表

drop table ZL_Courseware

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Courseware