序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | Pubid | int | 4 | 0 | 是 | 是 | 否 | 互动ID | ||
2 | PubName | nvarchar | 255 | 0 | 是 | 互动名称 | ||||
3 | PubClass | int | 4 | 0 | 是 | 0 | 信息类别(0-内容 1-商城 2-黄页 3-店铺) | |||
4 | PubTableName | nvarchar | 255 | 0 | 是 | 互动数据表名 | ||||
5 | PubType | int | 4 | 0 | 是 | 0 | 互动类型(0-评论 1-投票 2-活动 3-留言 4-问券调查 5-通用统计) | |||
6 | PubOneOrMore | int | 4 | 0 | 是 | 0 | 是否多条(0-无限制 1-每人限一条) | |||
7 | PubIPOneOrMore | int | 4 | 0 | 是 | 重复IP提交信息次数 | ||||
8 | PubTemplate | nvarchar | 1000 | 0 | 是 | 模板地址 | ||||
9 | PubLoadstr | nvarchar | 1000 | 0 | 是 | 调用字符 | ||||
10 | PubModelID | int | 4 | 0 | 是 | 0 | 模型ID | |||
11 | PubNodeID | nvarchar | 1000 | 0 | 是 | 0 | 系统节点ID | |||
12 | PubTemplateID | nvarchar | 1000 | 0 | 是 | 0 | 黄页节点ID | |||
13 | Pubinfo | ntext | 16 | 0 | 是 | 说明 | ||||
14 | PubIsTrue | int | 4 | 0 | 是 | 0 | 是否需要审核(0-不需要 1-需要审核) | |||
15 | PubCode | int | 4 | 0 | 是 | 0 | 是否需要验证码(0-不需要 1-需要) | |||
16 | PubLogin | int | 4 | 0 | 是 | 0 | 是否需要登陆(0-不需要 1-需要) | |||
17 | PubAddnum | int | 4 | 0 | 是 | 0 | 参与人数 | |||
18 | PubBindPub | int | 4 | 0 | 是 | 绑定互动 | ||||
19 | PubShowType | int | 4 | 0 | 是 | 0 | 投票显示方式(0-传统 1-柱状 2-圆形) | |||
20 | PubInputTM | nvarchar | 1000 | 0 | 是 | 提交窗口模板 | ||||
21 | PubInputLoadStr | nvarchar | 255 | 0 | 是 | 调用提交窗口代码 | ||||
22 | PubCreateTime | datetime | 8 | 3 | 是 | getdate | 创建时间 | |||
23 | PubLoginUrl | nvarchar | 255 | 0 | 是 | 设置登陆地址 | ||||
24 | PubOpenComment | int | 4 | 0 | 是 | 是否开启评论 | ||||
25 | PubEndTime | datetime | 8 | 3 | 是 | 结束时间 | ||||
26 | PubIsDel | int | 4 | 0 | 是 | 0 | 是否被删除 1-删除 | |||
27 | PubTimeSlot | int | 4 | 0 | 是 | 10 | 间隔时间,单位秒 | |||
28 | Pubkeep | int | 4 | 0 | 是 | 7 | 保留天数信息 | |||
29 | Puberrmsg | nvarchar | 1000 | 0 | 是 | |||||
30 | PubGourl | nvarchar | 1000 | 0 | 是 | 更新跳转地址 | ||||
31 | PubSiteID | int | 4 | 0 | 是 | 0 | 站点ID | |||
32 | Public | int | 4 | 0 | 是 | 1 | 公开 | |||
33 | PubPermissions | nvarchar | 255 | 0 | 是 | 互动模块权限 | ||||
34 | Interval | nvarchar | 20 | 0 | 是 | 投票间隔 | ||||
35 | PubFlag | int | 4 | 0 | 是 | 互动标识 |
互动模型表
GO
CREATE TABLE [dbo].[ZL_Pub](
[Pubid] [int] IDENTITY(1,1) NOT NULL,
[PubName] [nvarchar](255) NULL,
[PubClass] [int] NULL CONSTRAINT [DF_ZL_Pub_PubClass] DEFAULT (0),
[PubTableName] [nvarchar](255) NULL,
[PubType] [int] NULL CONSTRAINT [DF_ZL_Pub_PubType] DEFAULT (0),
[PubOneOrMore] [int] NULL CONSTRAINT [DF_ZL_Pub_PubOneOrMore] DEFAULT (0),
[PubIPOneOrMore] [int] NULL,
[PubTemplate] [nvarchar](1000) NULL,
[PubLoadstr] [nvarchar](1000) NULL,
[PubModelID] [int] NULL CONSTRAINT [DF_ZL_Pub_PubModelID] DEFAULT (0),
[PubNodeID] [nvarchar](1000) NULL CONSTRAINT [DF_ZL_Pub_PubNodeID] DEFAULT (0),
[PubTemplateID] [nvarchar](1000) NULL CONSTRAINT [DF_ZL_Pub_PubTemplateID] DEFAULT (0),
[Pubinfo] [ntext] NULL,
[PubIsTrue] [int] NULL CONSTRAINT [DF_ZL_Pub_PubIsTrue] DEFAULT (0),
[PubCode] [int] NULL CONSTRAINT [DF_ZL_Pub_PubPubCode] DEFAULT (0),
[PubLogin] [int] NULL CONSTRAINT [DF_ZL_Pub_PubNeedReg] DEFAULT (0),
[PubAddnum] [int] NULL CONSTRAINT [DF_ZL_Pub_PubAddnum] DEFAULT (0),
[PubBindPub] [int] NULL,
[PubShowType] [int] NULL CONSTRAINT [DF_ZL_Pub_PubShowType] DEFAULT (0),
[PubInputTM] [nvarchar](1000) NULL,
[PubInputLoadStr] [nvarchar](255) NULL,
[PubCreateTime] [datetime] NULL CONSTRAINT [DF_ZL_Pub_PubCreateTime] DEFAULT (getdate()),
[PubLoginUrl] [nvarchar](255) NULL,
[PubOpenComment] [int] NULL,
[PubEndTime] [datetime] NULL,
[PubIsDel] [int] NULL CONSTRAINT [DF_ZL_Pub_PubIsDel] DEFAULT (0),
[PubTimeSlot] [int] NULL CONSTRAINT [DF_ZL_Pub_PubTimeSlot] DEFAULT (10),
[Pubkeep] [int] NULL CONSTRAINT [DF_ZL_Pub_Pubkeep] DEFAULT (7),
[Puberrmsg] [nvarchar](1000) NULL,
[PubGourl] [nvarchar](1000) NULL,
[PubSiteID] [int] NULL CONSTRAINT [DF_ZL_Pub_PubSiteID] DEFAULT (0),
[Public] [int] NULL CONSTRAINT [DF_ZL_Pub_Public] DEFAULT ((1)),
[PubPermissions] [nvarchar](255) NULL,
[Interval][nvarchar](20) NULL,
[PubFlag] [int] NULL,
CONSTRAINT [PK_ZL_Pub] PRIMARY KEY CLUSTERED
(
[Pubid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Pubid'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息类别(0-内容 1-商城 2-黄页 3-店铺)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubClass'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动数据表名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTableName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动类型(0-评论 1-投票 2-活动 3-留言 4-问券调查 5-通用统计)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否多条(0-无限制 1-每人限一条)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubOneOrMore'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重复IP提交信息次数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubIPOneOrMore'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTemplate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调用字符' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubLoadstr'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模型ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubModelID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统节点ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubNodeID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'黄页节点ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTemplateID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Pubinfo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需要审核(0-不需要 1-需要审核)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubIsTrue'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需要验证码(0-不需要 1-需要)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubCode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需要登陆(0-不需要 1-需要)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubLogin'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参与人数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubAddnum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'绑定互动' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubBindPub'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'投票显示方式(0-传统 1-柱状 2-圆形)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubShowType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交窗口模板' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubInputTM'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调用提交窗口代码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubInputLoadStr'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubCreateTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设置登陆地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubLoginUrl'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否开启评论' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubOpenComment'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubEndTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否被删除 1-删除' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubIsDel'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'间隔时间,单位秒' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTimeSlot'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保留天数信息' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Pubkeep'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新跳转地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubGourl'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'站点ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubSiteID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公开' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Public'
GO
SET IDENTITY_INSERT [ZL_Pub] ON
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubNodeID],[PubTemplateID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 2,N'文章投票',0,N'ZL_Pub_WZTP',3,0,0,N'/互动模板/默认留言文章投票模板.html',N'WZTP',17,N'0',N'0',0,0,0,6,0,0,N'/互动模板/默认留言文章投票提交模板.html',N'WZTP',N'2016-1-28 17:21:01',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 3,N'在线调查',6,N'ZL_Pub_ZXDC',4,0,0,N'/互动模板/默认问券在线调查模板.html',N'ZXDC',18,0,0,0,1,0,0,N'/互动模板/默认问券在线调查提交模板.html',N'ZXDC',N'2016-5-6 9:56:05',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 4,N'提问',5,N'ZL_Pub_TW',3,0,0,N'/互动模板/默认留言提问模板.html',N'TW',21,0,0,0,2,0,0,N'/互动模板/默认留言提问提交模板.html',N'TW',N'2016-5-7 19:01:33',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 5,N'问题回答',0,N'ZL_Pub_WTHD',0,0,0,N'/互动模板/默认评论问题回答模板.html',N'WTHD',22,0,0,0,1,0,0,N'/互动模板/默认评论问题回答提交模板.html',N'WTHD',N'2016-5-7 19:01:52',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 6,N'最佳答案',0,N'ZL_Pub_ZJDA',0,0,0,N'/互动模板/默认评论最佳答案模板.html',N'ZJDA',23,0,0,0,0,0,0,N'/互动模板/默认评论最佳答案提交模板.html',N'ZJDA',N'2016-5-7 19:02:04',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
SET IDENTITY_INSERT [ZL_Pub] OFF
detele from ZL_Pub
drop table ZL_Pub
TRUNCATE table ZL_Pub