ASP.NET MVC 实现页落网资源分享网站+充值管理+后台管理（1）之数据库设计

时间：2022-12-11 16:29:09

本文主要讲解本项目网站所应用到的知识点，及数据库的相关设计：

一、知识点

（1）本项目主要采取ASP.NET MVC的编程模式，相信你已经了解到了MVC的具体含义是什么，这里不再赘述，有不了解的朋友，可以先了解相关资源，在来接着学习这里的知识。

（2）本项目已经进行多次抽象出了数据工厂模式、仓储类、业务层、实体层、及应用层，并将常用的和更改的一些帮助类和数据工厂模式、仓储类等封装成了程序集dll，大家可以直接下载应用或者访问开篇前的文章，里面有详细的讲解，这里不在赘述！

（3）本项目前端弹窗主要用到layer以及其他的一些数据验证插件，比如datepicker等，页面基本是原创手工重构，喜欢的朋友也可以参考或者在页落网上下载其他资源。

（4）本项目的数据库使用SQl Server创建，主键使用全球唯一码GUID字符串。

三、数据库设计

数据库的创建，相信你已经手脑纯熟了，这里不赘述，直接上创建代码：

（1）Base_SysLog系统日志表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Base_SysLog]    Script Date: 10/16/2018 14:29:11 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Base_SysLog](

    [SysLogId] [varchar](50) NOT NULL,

    [ObjectId] [varchar](50) NULL,

    [LogType] [varchar](50) NULL,

    [IPAddress] [varchar](50) NULL,

    [IPAddressName] [varchar](200) NULL,

    [CompanyId] [varchar](50) NULL,

    [DepartmentId] [varchar](50) NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](100) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](100) NULL,

    [ModuleId] [varchar](50) NULL,

    [Remark] [varchar](max) NULL,

    [Status] [varchar](50) NULL,

 CONSTRAINT [PK_BASE_SYSLOG] PRIMARY KEY NONCLUSTERED

(

    [SysLogId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'SysLogId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对象主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'ObjectId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'LogType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'IPAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP地址所在地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'IPAddressName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CompanyId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'DepartmentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模块主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'ModuleId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog', @level2type=N'COLUMN',@level2name=N'Status'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLog'

GO

ALTER TABLE [dbo].[Base_SysLog] ADD  CONSTRAINT [DF__Base_SysL__Creat__014935CB]  DEFAULT (getdate()) FOR [CreateDate]

GO

    （2）Base_SysLogDetail系统日志明细表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Base_SysLogDetail]    Script Date: 10/16/2018 14:44:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Base_SysLogDetail](

    [SysLogDetailId] [varchar](50) NOT NULL,

    [SysLogId] [varchar](50) NULL,

    [PropertyName] [varchar](50) NULL,

    [PropertyField] [varchar](50) NULL,

    [NewValue] [varchar](max) NULL,

    [OldValue] [varchar](50) NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](100) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](100) NULL,

 CONSTRAINT [PK_BASE_SYSLOGDETAIL] PRIMARY KEY NONCLUSTERED

(

    [SysLogDetailId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志明细主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'SysLogDetailId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日志主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'SysLogId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'PropertyName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性字段' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'PropertyField'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性新值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'NewValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'属性旧值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'OldValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统日志明细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_SysLogDetail'

GO

ALTER TABLE [dbo].[Base_SysLogDetail]  WITH CHECK ADD  CONSTRAINT [FK_Base_SysLogDetail_Base_SysLog] FOREIGN KEY([SysLogId])

REFERENCES [dbo].[Base_SysLog] ([SysLogId])

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[Base_SysLogDetail] CHECK CONSTRAINT [FK_Base_SysLogDetail_Base_SysLog]

GO

ALTER TABLE [dbo].[Base_SysLogDetail] ADD  CONSTRAINT [DF_Base_SysLogDetail_CreateDate1]  DEFAULT (getdate()) FOR [CreateDate]

GO

    （3）Base_DataDictionaryDetail数据字典详细表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Base_DataDictionaryDetail]    Script Date: 10/16/2018 14:45:27 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Base_DataDictionaryDetail](

    [DataDictionaryDetailId] [varchar](50) NOT NULL,

    [DataDictionaryType] [varchar](50) NULL,

    [ParentId] [varchar](50) NULL,

    [Code] [varchar](50) NULL,

    [DataDictionaryTitle] [nvarchar](200) NULL,

    [SortCode] [int] NULL,

    [Remark] [nvarchar](max) NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [varchar](50) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [varchar](50) NULL,

 CONSTRAINT [PK_Base_DataDictionaryDetail] PRIMARY KEY CLUSTERED

(

    [DataDictionaryDetailId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据字典ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DataDictionaryDetailId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据字典类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DataDictionaryType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'Code'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'字段名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DataDictionaryTitle'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'SortCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据字典详细表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_DataDictionaryDetail'

GO

ALTER TABLE [dbo].[Base_DataDictionaryDetail] ADD  CONSTRAINT [DF_Base_DataDictionaryDetail_ParentId]  DEFAULT ((0)) FOR [ParentId]

GO

ALTER TABLE [dbo].[Base_DataDictionaryDetail] ADD  CONSTRAINT [DF_Base_DataDictionaryDetail_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[Base_DataDictionaryDetail] ADD  CONSTRAINT [DF_Base_DataDictionaryDetail_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]

GO

    （4）Base_ProvinceCity省是区域表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Base_ProvinceCity]    Script Date: 10/16/2018 14:45:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Base_ProvinceCity](

    [ProvinceCityId] [varchar](50) NOT NULL,

    [ParentId] [varchar](50) NULL,

    [Category] [varchar](50) NULL,

    [Code] [varchar](50) NULL,

    [FullName] [varchar](50) NULL,

    [Enabled] [int] NULL,

    [SortCode] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [varchar](50) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [varchar](50) NULL,

 CONSTRAINT [PK_Base_ProvinceCity] PRIMARY KEY CLUSTERED

(

    [ProvinceCityId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省市区主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ProvinceCityId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'Category'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'Code'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'FullName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'Enabled'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'SortCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'省是区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_ProvinceCity'

GO

ALTER TABLE [dbo].[Base_ProvinceCity] ADD  CONSTRAINT [DF_Base_ProvinceCity_Enabled]  DEFAULT ((1)) FOR [Enabled]

GO

ALTER TABLE [dbo].[Base_ProvinceCity] ADD  CONSTRAINT [DF_Base_ProvinceCity_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[Base_ProvinceCity] ADD  CONSTRAINT [DF_Base_ProvinceCity_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]

GO

    （5）Base_User系统用户表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Base_User]    Script Date: 10/16/2018 14:46:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Base_User](

    [UserId] [varchar](50) NOT NULL,

    [Account] [varchar](50) NULL,

    [Password] [varchar](50) NULL,

    [Secretkey] [varchar](50) NULL,

    [RealName] [varchar](50) NULL,

    [Spell] [varchar](200) NULL,

    [Sex] [int] NULL,

    [Birthday] [datetime] NULL,

    [Mobile] [varchar](50) NULL,

    [OICQ] [varchar](50) NULL,

    [Email] [varchar](50) NULL,

    [ChangePasswordDate] [datetime] NULL,

    [OpenId] [int] NULL,

    [LogOnCount] [int] NULL,

    [FirstVisit] [datetime] NULL,

    [PreviousVisit] [datetime] NULL,

    [LastVisit] [datetime] NULL,

    [AuditStatus] [varchar](50) NULL,

    [AuditUserId] [varchar](50) NULL,

    [AuditUserName] [varchar](50) NULL,

    [AuditDateTime] [datetime] NULL,

    [Online] [int] NULL,

    [Remark] [varchar](200) NULL,

    [Enabled] [int] NULL,

    [SortCode] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [varchar](50) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [varchar](50) NULL,

 CONSTRAINT [PK_Base_User] PRIMARY KEY CLUSTERED

(

    [UserId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'UserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Account'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Password'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码秘钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Secretkey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'RealName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名拼音' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Spell'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Sex'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Birthday'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Mobile'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'OICQ'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Email'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改密码日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ChangePasswordDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单点登录标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'OpenId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'LogOnCount'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'FirstVisit'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'PreviousVisit'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'LastVisit'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'AuditDateTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否在线' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Online'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'Enabled'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'SortCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统用户表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Base_User'

GO

ALTER TABLE [dbo].[Base_User] ADD  CONSTRAINT [DF_Base_User_Online]  DEFAULT ((0)) FOR [Online]

GO

ALTER TABLE [dbo].[Base_User] ADD  CONSTRAINT [DF_Base_User_Enabled]  DEFAULT ((1)) FOR [Enabled]

GO

ALTER TABLE [dbo].[Base_User] ADD  CONSTRAINT [DF_Base_User_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[Base_User] ADD  CONSTRAINT [DF_Base_User_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]

GO

    （6）Com_Attachment资源附件信息表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_Attachment]    Script Date: 10/16/2018 14:47:15 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_Attachment](

    [FileID] [varchar](50) NOT NULL,

    [DataID] [varchar](50) NULL,

    [FileType] [varchar](500) NULL,

    [FileTitle] [nvarchar](200) NULL,

    [FileCover] [nvarchar](200) NULL,

    [FileMinCover] [nvarchar](200) NULL,

    [FileUrl] [nvarchar](200) NULL,

    [FileSize] [varchar](50) NULL,

    [FileSuffix] [varchar](50) NULL,

    [Remarks] [nvarchar](max) NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](200) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](200) NULL,

    [FileIndexUrl] [nvarchar](500) NULL,

    [ContentKey] [nvarchar](500) NULL,

    [BrowseNum] [int] NULL,

    [CollectionNum] [int] NULL,

    [Integral] [int] NULL,

 CONSTRAINT [PK_Com_Attachment] PRIMARY KEY CLUSTERED

(

    [FileID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附近ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'DataID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileTitle'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'封面' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileCover'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'封面缩略图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileMinCover'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件大小' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileSize'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件后缀' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileSuffix'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'Remarks'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'解压后首页地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'FileIndexUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键词' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'ContentKey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'浏览量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'BrowseNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'收藏量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'CollectionNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'积分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment', @level2type=N'COLUMN',@level2name=N'Integral'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'资源附件信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Attachment'

GO

ALTER TABLE [dbo].[Com_Attachment] ADD  CONSTRAINT [DF_Com_Attachment_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[Com_Attachment] ADD  CONSTRAINT [DF__Com_Attac__Brows__4E88ABD4]  DEFAULT ((0)) FOR [BrowseNum]

GO

ALTER TABLE [dbo].[Com_Attachment] ADD  CONSTRAINT [DF__Com_Attac__Colle__4F7CD00D]  DEFAULT ((0)) FOR [CollectionNum]

GO

ALTER TABLE [dbo].[Com_Attachment] ADD  CONSTRAINT [DF__Com_Attac__Integ__5070F446]  DEFAULT ((0)) FOR [Integral]

GO

    （7）Com_Banner广告信息表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_Banner]    Script Date: 10/16/2018 14:47:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_Banner](

    [BannerID] [varchar](50) NOT NULL,

    [BannerType] [varchar](50) NULL,

    [BannerTitle] [nvarchar](200) NULL,

    [BannerCenter] [nvarchar](max) NULL,

    [BannerImg] [nvarchar](200) NULL,

    [BannerLink] [nvarchar](200) NULL,

    [State] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [varchar](50) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [varchar](50) NULL,

 CONSTRAINT [PK_Com_Banner] PRIMARY KEY CLUSTERED

(

    [BannerID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerTitle'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerCenter'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerImg'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告列表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'BannerLink'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'广告状态(1正常)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'State'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'Com_Banner', @value=N'广告信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Banner'

GO

ALTER TABLE [dbo].[Com_Banner] ADD  CONSTRAINT [DF_Com_Banner_State]  DEFAULT ((1)) FOR [State]

GO

ALTER TABLE [dbo].[Com_Banner] ADD  CONSTRAINT [DF_Com_Banner_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[Com_Banner] ADD  CONSTRAINT [DF_Com_Banner_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]

GO

    （9）Com_Article文章信息表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_Article]    Script Date: 10/16/2018 14:48:13 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_Article](

    [ArticleID] [varchar](50) NOT NULL,

    [ArticleType] [varchar](50) NULL,

    [ArticleTitle] [nvarchar](200) NULL,

    [ArticleSubTitle] [nvarchar](200) NULL,

    [Source] [varchar](50) NULL,

    [ArticleContent] [nvarchar](max) NULL,

    [BrowseNumber] [int] NULL,

    [GiveNum] [int] NULL,

    [Remarks] [nvarchar](max) NULL,

    [PicUrl] [nvarchar](200) NULL,

    [PutTime] [date] NULL,

    [OptionSet] [int] NULL,

    [State] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](200) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](200) NULL,

 CONSTRAINT [PK_Com_Article] PRIMARY KEY CLUSTERED

(

    [ArticleID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleTitle'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章副标题' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleSubTitle'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'Source'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ArticleContent'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'浏览次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'BrowseNumber'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点赞量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'GiveNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'Remarks'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'题图' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'PicUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'PutTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'选项设置' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'OptionSet'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'State'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文章信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Article'

GO

ALTER TABLE [dbo].[Com_Article] ADD  CONSTRAINT [DF_Com_Article_BrowseNumber]  DEFAULT ((0)) FOR [BrowseNumber]

GO

ALTER TABLE [dbo].[Com_Article] ADD  CONSTRAINT [DF_Com_Article_GiveNum]  DEFAULT ((0)) FOR [GiveNum]

GO

ALTER TABLE [dbo].[Com_Article] ADD  CONSTRAINT [DF_Icos_Article_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

    （10）Com_DownloadLog下载日志表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_DownloadLog]    Script Date: 10/16/2018 14:48:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_DownloadLog](

    [DownloadLogID] [varchar](50) NOT NULL,

    [DataID] [varchar](50) NULL,

    [Integral] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](200) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](200) NULL,

 CONSTRAINT [PK_Com_DownloadLog] PRIMARY KEY CLUSTERED

(

    [DownloadLogID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'下载ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'DownloadLogID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'DataID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'使用积分' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'Integral'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_DownloadLog', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

ALTER TABLE [dbo].[Com_DownloadLog] ADD  DEFAULT ((0)) FOR [DeleteMark]

GO

    （11）OND_MessageReply评论信息表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[OND_MessageReply]    Script Date: 10/16/2018 14:49:14 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[OND_MessageReply](

    [MessageReplyID] [varchar](50) NOT NULL,

    [ParentID] [varchar](50) NULL,

    [DataID] [varchar](50) NULL,

    [MessageReplyCenter] [nvarchar](max) NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](200) NULL,

    [GiveNum] [int] NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](200) NULL,

 CONSTRAINT [PK_MessageReply] PRIMARY KEY CLUSTERED

(

    [MessageReplyID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'评论ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'MessageReplyID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'父级ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ParentID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'DataID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'评论内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'MessageReplyCenter'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'点赞量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'GiveNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'留言评论信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OND_MessageReply'

GO

ALTER TABLE [dbo].[OND_MessageReply] ADD  CONSTRAINT [DF__OND_Messa__Delet__5BE2A6F2]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[OND_MessageReply] ADD  CONSTRAINT [DF_OND_MessageReply_GiveNum]  DEFAULT ((0)) FOR [GiveNum]

GO

    （12）Com_PayFor支付流水表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_PayFor]    Script Date: 10/16/2018 14:49:38 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_PayFor](

    [PayForID] [varchar](50) NOT NULL,

    [DataID] [varchar](50) NULL,

    [PayForContent] [nvarchar](50) NULL,

    [PayForType] [varchar](50) NULL,

    [PayForTime] [datetime] NULL,

    [PayForUrl] [nvarchar](200) NULL,

    [PayForState] [int] NULL,

    [Integral] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](200) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](200) NULL,

 CONSTRAINT [PK_Com_PayFor] PRIMARY KEY CLUSTERED

(

    [PayForID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'DataID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForContent'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付凭证' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'支付状态(0未支付,1已支付)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'PayForState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金币' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'Integral'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_PayFor', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

ALTER TABLE [dbo].[Com_PayFor] ADD  CONSTRAINT [DF__Com_PayFo__PayFo__5812160E]  DEFAULT ((0)) FOR [PayForState]

GO

ALTER TABLE [dbo].[Com_PayFor] ADD  CONSTRAINT [DF_Com_PayFor_Integral]  DEFAULT ((0)) FOR [Integral]

GO

ALTER TABLE [dbo].[Com_PayFor] ADD  CONSTRAINT [DF__Com_PayFo__Delet__59063A47]  DEFAULT ((0)) FOR [DeleteMark]

GO

    （13）Com_Member会员信息表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_Member]    Script Date: 10/16/2018 14:50:04 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_Member](

    [MemberID] [varchar](50) NOT NULL,

    [Account] [varchar](50) NULL,

    [Password] [varchar](50) NULL,

    [Secretkey] [varchar](50) NULL,

    [RealName] [varchar](50) NULL,

    [Spell] [varchar](200) NULL,

    [Sex] [int] NULL,

    [Birthday] [datetime] NULL,

    [Mobile] [varchar](50) NULL,

    [OICQ] [varchar](50) NULL,

    [Email] [varchar](50) NULL,

    [ChangePasswordDate] [datetime] NULL,

    [OpenId] [int] NULL,

    [LogOnCount] [int] NULL,

    [FirstVisit] [datetime] NULL,

    [PreviousVisit] [datetime] NULL,

    [LastVisit] [datetime] NULL,

    [AuditStatus] [varchar](50) NULL,

    [AuditUserId] [varchar](50) NULL,

    [AuditUserName] [varchar](50) NULL,

    [AuditDateTime] [datetime] NULL,

    [Online] [int] NULL,

    [Remark] [varchar](200) NULL,

    [Enabled] [int] NULL,

    [SortCode] [int] NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [varchar](50) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [varchar](50) NULL,

    [PhotoUrl] [varchar](50) NULL,

    [MemberType] [int] NULL,

    [Integral] [int] NULL,

    [VerCode] [varchar](50) NULL,

    [State] [int] NULL,

 CONSTRAINT [PK_Com_Member] PRIMARY KEY CLUSTERED

(

    [MemberID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'MemberID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录账户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Account'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Password'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码秘钥' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Secretkey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'RealName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名拼音' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Spell'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Sex'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Birthday'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Mobile'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'QQ号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'OICQ'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Email'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后修改密码日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ChangePasswordDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单点登录标识' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'OpenId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'LogOnCount'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'第一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'FirstVisit'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上一次访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'PreviousVisit'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'最后访问时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'LastVisit'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核员' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'AuditDateTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否在线' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Online'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Enabled'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'排序码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'SortCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'头像地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'PhotoUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员类型（0普通会员，1VIP会员）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'MemberType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'金币' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'Integral'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'验证码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'VerCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态（0未激活，1正常使用）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member', @level2type=N'COLUMN',@level2name=N'State'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'会员表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Member'

GO

ALTER TABLE [dbo].[Com_Member] ADD  CONSTRAINT [DF_Com_Member_Online]  DEFAULT ((0)) FOR [Online]

GO

ALTER TABLE [dbo].[Com_Member] ADD  CONSTRAINT [DF_Com_Member_Enabled]  DEFAULT ((1)) FOR [Enabled]

GO

ALTER TABLE [dbo].[Com_Member] ADD  CONSTRAINT [DF_Com_Member_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

ALTER TABLE [dbo].[Com_Member] ADD  CONSTRAINT [DF_Com_Member_CreateDate]  DEFAULT (getdate()) FOR [CreateDate]

GO

ALTER TABLE [dbo].[Com_Member] ADD  DEFAULT ((0)) FOR [Integral]

GO

ALTER TABLE [dbo].[Com_Member] ADD  DEFAULT ((0)) FOR [State]

GO

    （14）Com_Approve操作记录表

USE [SysDataBase]

GO

/****** Object:  Table [dbo].[Com_Approve]    Script Date: 10/16/2018 14:50:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Com_Approve](

    [ApproveId] [varchar](50) NOT NULL,

    [DataId] [varchar](50) NULL,

    [Action] [nvarchar](50) NULL,

    [ActionCode] [varchar](50) NULL,

    [Idea] [nvarchar](400) NULL,

    [DeleteMark] [int] NULL,

    [CreateDate] [datetime] NULL,

    [CreateUserId] [varchar](50) NULL,

    [CreateUserName] [nvarchar](200) NULL,

    [ModifyDate] [datetime] NULL,

    [ModifyUserId] [varchar](50) NULL,

    [ModifyUserName] [nvarchar](200) NULL,

 CONSTRAINT [PK_Com_Approve] PRIMARY KEY CLUSTERED

(

    [ApproveId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批记录ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ApproveId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'DataId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批动作' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'Action'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'动作编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ActionCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批意见' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'Idea'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'删除标记' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'DeleteMark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'CreateUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'CreateUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ModifyUserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve', @level2type=N'COLUMN',@level2name=N'ModifyUserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审批记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Com_Approve'

GO

ALTER TABLE [dbo].[Com_Approve] ADD  CONSTRAINT [DF_Com_Approve_DeleteMark]  DEFAULT ((0)) FOR [DeleteMark]

GO

　　

相关文章