IM12345_Api/项目其他/sql/T_Chat_Messa...

USE [IM12345]
GO

/****** Object:  Table [dbo].[T_Chat_Message]    Script Date: 03/11/2020 10:51:23 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_Chat_Message](
	[F_Id] [bigint] IDENTITY(1,1) NOT NULL,
	[F_FromUser] [varchar](500) NULL,
	[F_ToUser] [varchar](500) NULL,
	[F_Message] [nvarchar](max) NULL,
	[F_File] [varchar](max) NULL,
	[F_IP] [varchar](50) NULL,
	[F_SourceType] [int] NULL,
	[F_MessageType] [int] NULL,
	[F_State] [int] NULL,
	[F_CreateUser] [varchar](500) NULL,
	[F_CreateTime] [datetime] NULL,
	[F_IsDelete] [int] NULL,
	[F_DeleteUser] [varchar](50) NULL,
	[F_DeleteTime] [datetime] NULL,
	[F_HumanClass] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[F_Id] 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'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_FromUser'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_ToUser'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_Message'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_File'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_IP'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型（1网站2微信）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_SourceType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'消息类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_MessageType'
GO

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发送人（判断图像 0不知 1客服 2客户 3机器人）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Chat_Message', @level2type=N'COLUMN',@level2name=N'F_HumanClass'
GO