/****** Object:  Table [dbo].[SysUserOperationLog]    Script Date: 2022/4/10 2:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SysUserOperationLog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[userName] [nvarchar](50) NULL,
	[userNickName] [nvarchar](50) NULL,
	[userId] [int] NOT NULL,
	[ip] [nvarchar](150) NULL,
	[apiPath] [nvarchar](150) NULL,
	[beginTime] [datetime] NOT NULL,
	[endTime] [datetime] NOT NULL,
	[opTime] [nvarchar](50) NULL,
	[requestMethod] [nvarchar](50) NULL,
	[requestData] [nvarchar](max) NULL,
	[responseBodyData] [nvarchar](max) NULL,
	[agent] [nvarchar](1000) NULL,
	[actionName] [nvarchar](50) NULL,
	[actionDescription] [nvarchar](50) NULL,
	[controllerName] [nvarchar](50) NULL,
	[controllerDescription] [nvarchar](50) NULL,
	[statusCode] [int] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[dataSources] [nvarchar](50) NULL,
 CONSTRAINT [PK_SysUserOperationLog] PRIMARY KEY CLUSTERED 
(
	[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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[SysUserOperationLog] ADD  CONSTRAINT [DF_SysUserOperationLog_userId]  DEFAULT ((0)) FOR [userId]
GO

ALTER TABLE [dbo].[SysUserOperationLog] ADD  CONSTRAINT [DF_SysUserOperationLog_statusCode]  DEFAULT ((0)) FOR [statusCode]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÐòÁÐ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Óû§µÇ¼Õ˺Å' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'userName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Óû§µÇ¼êdzÆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'userNickName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Óû§ÐòÁÐ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'userId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'IPµØÖ·' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'ip'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÇëÇóµØÖ·' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'apiPath'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿ªÊ¼Ê±¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'beginTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'½áÊøʱ¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'endTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ºÄʱ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'opTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÇëÇó·½Ê½' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'requestMethod'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÇëÇóÊý¾Ý' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'requestData'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'·µ»ØÊý¾Ý' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'responseBodyData'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´úÀíÇþµÀ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'agent'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶¯×÷·½·¨Ãû³Æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'actionName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶¯×÷·½·¨ÃèÊö' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'actionDescription'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿ØÖÆÆ÷Ãû³Æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'controllerName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¿ØÖÆÆ÷Ãû³Æ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'controllerDescription'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'״̬Âë' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'statusCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'´´½¨Ê±¼ä' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'createTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Êý¾ÝÀ´Ô´' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog', @level2type=N'COLUMN',@level2name=N'dataSources'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Óû§²Ù×÷ÈÕÖ¾' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SysUserOperationLog'
GO