表名：ZL_Recruitment












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是是 否  
2Studionamenvarchar500   是 学员姓名
3PriorUserNamenvarchar500   是 预设用户名
4LogPassWordnvarchar500   是 预设登录密码
5TechIDint40   是 招生员ID
6CourseIDint40   是 课程ID
7ClassIDint40   是 班级
8Remarknvarchar10000   是 备注
9AddTimedatetime83   是 添加时间

简要说明：

学员信息表

GO
CREATE TABLE [dbo].[ZL_Recruitment](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Studioname] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[PriorUserName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[LogPassWord] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TechID] [int] NULL,
[CourseID] [int] NULL,
[ClassID] [int] NULL,
[Remark] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[AddTime] [datetime] NULL,
CONSTRAINT [PK_ZL_Recruitment] PRIMARY KEY CLUSTERED
(
[ID] ASC
) ON [PRIMARY]
) 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_Recruitment', @level2type=N'COLUMN',@level2name=N'Studioname'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'预设用户名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Recruitment', @level2type=N'COLUMN',@level2name=N'PriorUserName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'预设登录密码' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Recruitment', @level2type=N'COLUMN',@level2name=N'LogPassWord'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'招生员ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Recruitment', @level2type=N'COLUMN',@level2name=N'TechID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Recruitment', @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_Recruitment', @level2type=N'COLUMN',@level2name=N'ClassID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Recruitment', @level2type=N'COLUMN',@level2name=N'Remark'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Recruitment', @level2type=N'COLUMN',@level2name=N'AddTime'

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

detele from ZL_Recruitment

--注意：将删除整个表

drop table ZL_Recruitment

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

TRUNCATE table ZL_Recruitment