表名:ZL_RoomActive












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1AIDint40  主键ID
2ActiveUserIDint40    活动发起人
3ActiveTitlenvarchar2250    活动标题
4ActiveContextnvarchar40000    活动内容
5ActiveStateTimedatetime83    活动开始时间
6ActiveEndTimedatetime83    活动结束时间
7ActiveAddTimedatetime83    活动添加时间
8ActivePicnvarchar2000    活动图片
9RoomIDint40    班级ID

简要说明:

班级活动表

GO
CREATE TABLE [dbo].[ZL_RoomActive](
[AID] [int] IDENTITY(1,1) NOT NULL,
[ActiveUserID] [int] NULL,
[ActiveTitle] [nvarchar](225) NULL,
[ActiveContext] [nvarchar](4000) NULL,
[ActiveStateTime] [datetime] NULL,
[ActiveEndTime] [datetime] NULL,
[ActiveAddTime] [datetime] NULL,
[ActivePic] [nvarchar](200) NULL,
[RoomID] [int] NULL,
 CONSTRAINT [PK_Active] PRIMARY KEY CLUSTERED
(
[AID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动发起人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActiveUserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动标题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActiveTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActiveContext'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动开始时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActiveStateTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动结束时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActiveEndTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动添加时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActiveAddTime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'活动图片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'ActivePic'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_RoomActive', @level2type=N'COLUMN', @level2name=N'RoomID'

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

detele from ZL_RoomActive

--注意:将删除整个表

drop table ZL_RoomActive

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

TRUNCATE table ZL_RoomActive