數據庫結構–舉報

/****** Object:  Table [dbo].[E_CMS_User_Report]    Script Date: 2021/12/21 17:57:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[E_CMS_User_Report]( [ReportId] [int] IDENTITY(1,1) NOT NULL, [ReportReasons] [varchar](50) NOT NULL, [ReportAudit] [bit] NOT NULL, [BusinessId] [varchar](50) NOT NULL, [BusinessType] [int] NOT NULL, [ReportPicture] [varchar](50) NOT NULL, [remark] [varchar](100) NOT NULL, [ReporterUserId] [varchar](50) NOT NULL, [ToReporterUserId] [varchar](50) NOT NULL, [CreateTime] [datetime] NOT NULL, [CreateUserId] [varchar](50) NULL, [UpdateTime] [datetime] NOT NULL, [UpdateUserId] [varchar](50) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[E_CMS_User_Report] ADD  CONSTRAINT [DF_E_CMS_User_Report_ReportAudit]  DEFAULT ((0)) FOR [ReportAudit] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'投訴的原因' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'ReportReasons' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'審批狀態(待審,已審批)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'ReportAudit' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'關聯業務ID(貼子,評論)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'BusinessId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'業務類型(1.帖子 2評論)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'BusinessType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上傳圖片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'ReportPicture' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'補充說明' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @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'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'ReporterUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'被舉報或投訴人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'ToReporterUserId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建時間' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'CreateTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'創建人ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @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'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'UpdateTime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report', @level2type=N'COLUMN',@level2name=N'UpdateUserId' GO EXEC sys.sp_addextendedproperty @name=N'report', @value=N'用戶舉報' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'E_CMS_User_Report' GO

暗黑源码库包揽全网大多数网站源码教程,提供小程序、公众号、APP、H5、商城、支付、游戏、区块链、直播、影音、小说等源码教程,注册会员可免费学习交流。
用户必须遵守《计算机软件保护条例(2013修订)》第十七条:为了学习和研究软件内含的设计思想和原理,通过安装、显示、传输或者存储软件等方式使用软件的,可以不经软件著作权人许可,不向其支付报酬。鉴于此条例,用户从本平台下载的全部源码(软件)教程仅限学习研究,未经版权归属者授权不得商用,若因商用引起的版权纠纷,一切责任均由使用者自行承担,本平台所属公司及其雇员不承担任何法律责任。
暗黑源码库 » 數據庫結構–舉報
赞助VIP 享更多特权,立即登录下载海量资源
喜欢我嘛?喜欢就按“ctrl+D”收藏我吧!♡