表名：ZL_ExStudytime












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1StudyIDint40是是 否 培训ID
2Stuidint40   是 学员ID
3Courseint40   是 课程
4Studytimenvarchar20000   是 学习时间
5Resttimentext160   是 每日学习时间安排
6Scheduleint40   是 学员当前进度
7Reviewsnvarchar10000   是 评语

简要说明：

在线考试时间记录表

GO
CREATE TABLE [dbo].[ZL_ExStudytime](
[StudyID] [int] IDENTITY(1,1) NOT NULL,
[Stuid] [int] NULL,
[Course] [int] NULL,
[Studytime] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL,
[Resttime] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[Schedule] [int] NULL,
[Reviews] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_ExStudytime] PRIMARY KEY CLUSTERED
(
[StudyID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'培训ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'StudyID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学员ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'Stuid'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'Course'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学习时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'Studytime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'每日学习时间安排' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'Resttime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学员当前进度' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'Schedule'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'评语' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudytime', @level2type=N'COLUMN',@level2name=N'Reviews'

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

detele from ZL_ExStudytime

--注意：将删除整个表

drop table ZL_ExStudytime

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

TRUNCATE table ZL_ExStudytime