表名：ZL_UserCourse












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2CourseIDint40   是 课程ID
3ClassIDint40   是 班级ID
4UserIDint40   是 用户ID
5CurrCoureHourfloat80   是 当前课时
6Stateint40   是 开放状态
7AddTimedatetime83   是 申请时间
8PayMentint40   是 是否付款
9OrderIDnvarchar500   是 订单号
10Aunitint40   是 是否审核:0为否,1为是
11Remarknvarchar10000   是 备注

简要说明：

用户课程表

GO
CREATE TABLE [dbo].[ZL_UserCourse](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CourseID] [int] NULL,
[ClassID] [int] NULL,
[UserID] [int] NULL,
[CurrCoureHour] [float] NULL,
[State] [int] NULL,
[AddTime] [datetime] NULL,
[PayMent] [int] NULL,
[OrderID] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Aunit] [int] NULL,
[Remark] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL
) 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_UserCourse', @level2type=N'COLUMN',@level2name=N'CourseID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'班级ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'ClassID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'当前课时' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'CurrCoureHour'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'开放状态' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'State'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'申请时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'AddTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'是否付款' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'PayMent'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'订单号' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'OrderID'
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_UserCourse', @level2type=N'COLUMN',@level2name=N'Aunit'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_UserCourse', @level2type=N'COLUMN',@level2name=N'Remark'



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

detele from ZL_UserCourse

--注意：将删除整个表

drop table ZL_UserCourse

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

TRUNCATE table ZL_UserCourse