GO
CREATE TABLE [dbo].[ZL_ExLecturer](
[ID] [int] IDENTITY(1,1) NOT NULL,
[TechName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TechType] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TechSex] [int] NULL,
[TechTitle] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TechPhone] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[CreateTime] [datetime] NULL,
[TechSpecialty] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[TechHobby] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[TechIntrodu] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[TechLevel] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[TechDepart] [int] NULL,
[TechClass] [int] NULL,
[TechRecom] [int] NULL,
[Popularity] [int] NULL,
[Awardsinfo] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
[FileUpload] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[AddUser] [int] NULL,
[Professional] [int] 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_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'教师类型：内训,外请' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechType'
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_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechSex'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'职称：初级,中级，副高,正高' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechTitle'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'教师电话' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechPhone'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'特长' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechSpecialty'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'爱好' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechHobby'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'教师级别：一级，二级，三级' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechLevel'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'部门' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechDepart'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'专业类别：英语,计算机' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechClass'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'推荐讲师' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'TechRecom'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'人气' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'Popularity'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'获奖情况' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'Awardsinfo'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'上传照片' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'FileUpload'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'添加用户' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'AddUser'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'专业ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExLecturer', @level2type=N'COLUMN',@level2name=N'Professional'