GO
CREATE TABLE [dbo].[ZL_ExStudent](
[Stuid] [int] IDENTITY(1,1) NOT NULL,
[Stuname] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Stupassword] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Stucardno] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Userid] [int] NULL,
[Exptime] [datetime] NULL,
[Lognum] [int] NULL,
[Examnum] [int] NULL,
[Logtimeout] [int] NULL,
[Stugroup] [int] NULL,
[Regulation] [int] NULL,
[strCompetence] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[Course] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
[Qualified] [int] NULL,
[Addtime] [datetime] NULL,
CONSTRAINT [PK_ZL_ExStudent] PRIMARY KEY CLUSTERED
(
[Stuid] 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_ExStudent', @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_ExStudent', @level2type=N'COLUMN',@level2name=N'Stuname'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码(二重密码)' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Stupassword'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生考号(卡)' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Stucardno'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'捆绑用户ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Userid'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'到期有效时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Exptime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'登陆次数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Lognum'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考试次数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Examnum'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'登录时长' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @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_ExStudent', @level2type=N'COLUMN',@level2name=N'Stugroup'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'监管人' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Regulation'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'考生权限' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'strCompetence'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'学习课程' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @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_ExStudent', @level2type=N'COLUMN',@level2name=N'Qualified'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'启用时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExStudent', @level2type=N'COLUMN',@level2name=N'Addtime'