數據庫結構--舉報

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