GO
CREATE TABLE [dbo].[ZL_ExClassgroup](
[GroupID] [int] IDENTITY(1,1) NOT NULL,
[Regulationame] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Regulation] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
[Ratednumber] [int] NULL,
[Actualnumber] [int] NULL,
[Setuptime] [datetime] NULL,
[Endtime] [datetime] NULL,
[CourseID] [int] NULL,
[ShiPrice] [money] NULL,
[LinPrice] [money] NULL,
[CourseHour] [int] NULL,
[Presented] [int] NULL,
[isCou] [int] NULL,
[Speaker] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ClassID] [int] NULL
CONSTRAINT [PK_ZL_ExClassgroup] PRIMARY KEY CLUSTERED
([GroupID] ASC
) ON [PRIMARY]
) ON [PRIMARY]

EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'班级ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'GroupID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'班级名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Regulationame'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'班级负责人' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @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_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Ratednumber'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'实际人数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Actualnumber'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'开放时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Setuptime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Endtime'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'CourseID'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'售价' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'ShiPrice'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'优惠价' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'LinPrice'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课时' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'CourseHour'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'订购此班级是否赠送此课程(免费)' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Presented'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'是否打折' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'isCou'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'主讲人' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'Speaker'
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'课程分类ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_ExClassgroup', @level2type=N'COLUMN',@level2name=N'ClassID'