序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | AID | int | 4 | 0 | 是 | 是 | 否 | 主键ID | ||
2 | ActiveUserID | int | 4 | 0 | 是 | 活动发起人 | ||||
3 | ActiveTitle | nvarchar | 225 | 0 | 是 | 活动标题 | ||||
4 | ActiveContext | nvarchar | 4000 | 0 | 是 | 活动内容 | ||||
5 | ActiveStateTime | datetime | 8 | 3 | 是 | 活动开始时间 | ||||
6 | ActiveEndTime | datetime | 8 | 3 | 是 | 活动结束时间 | ||||
7 | ActiveAddTime | datetime | 8 | 3 | 是 | 活动添加时间 | ||||
8 | ActivePic | nvarchar | 200 | 0 | 是 | 活动图片 | ||||
9 | RoomID | int | 4 | 0 | 是 | 班级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
TRUNCATE table ZL_RoomActive