/****** 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