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

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

一、知识点

(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

  

上一篇:Poj1743 (后缀数组)


下一篇:关于读取txt文件中文乱码问题