表名：ZL_ExAttendance












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1AttIDint40是是 否 考勤ID
2Stuidint40   是 学员ID
3LogTimedatetime83   是 登录时间
4Logtimeoutint40   是 登录时长
5Locationnvarchar2550   是 当前位置
6StuNamenvarchar2550   是 用户名称

简要说明：

在线考试申请表

GO
CREATE TABLE [dbo].[ZL_ExAttendance](
[AttID] [int] IDENTITY(1,1) NOT NULL,
[Stuid] [int] NULL,
[LogTime] [datetime] NULL,
[Logtimeout] [int] NULL,
[Location] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[StuName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_ZL_ExAttendance] PRIMARY KEY CLUSTERED
(
[AttID] ASC
) ON [PRIMARY]
) 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_ExAttendance', @level2type=N'COLUMN',@level2name=N'AttID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学员ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAttendance', @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_ExAttendance', @level2type=N'COLUMN',@level2name=N'LogTime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'登录时长' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAttendance', @level2type=N'COLUMN',@level2name=N'Logtimeout'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'当前位置' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAttendance', @level2type=N'COLUMN',@level2name=N'Location'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExAttendance', @level2type=N'COLUMN',@level2name=N'StuName'

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

detele from ZL_ExAttendance

--注意：将删除整个表

drop table ZL_ExAttendance

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

TRUNCATE table ZL_ExAttendance