系统日志表结构

1、系统日志表结构

CREATE TABLE [dbo].[sys_api_log](
	[id] [nvarchar](64) NOT NULL,
	[method] [nvarchar](200) NULL,
	[path] [nvarchar](400) NULL,
	[client] [nvarchar](400) NULL,
	[content] [nvarchar](max) NULL,
	[remark] [nvarchar](max) NULL,
	[isdeleted] [int] NULL,
	[creator] [nvarchar](64) NULL,
	[creatorName] [nvarchar](32) NULL,
	[creatDate] [datetime] NULL,
	[modifier] [nvarchar](64) NULL,
	[modifierName] [nvarchar](32) NULL,
	[modifyDate] [datetime] NULL,
	[times] [bigint] NULL,
	[result] [nvarchar](max) NULL,
	[process_code] [nvarchar](64) NULL,
	[equip_code] [nvarchar](64) NULL,
	[PlantCode] [varchar](50) NULL,
	[Interface] [varchar](255) NULL,
	[System] [nvarchar](255) NULL,
	[SendCount] [int] NULL,
	[SystemOperation] [nvarchar](55) NULL,
	[SyncTaskID] [varchar](255) NULL,
	[resultData] [nvarchar](max) NULL,
 CONSTRAINT [PK__sys_api___3213E83F6C0C82A1] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[sys_api_log] ADD  CONSTRAINT [DF__sys_api_l__isdel__55F4C372]  DEFAULT ((0)) FOR [isdeleted]
GO

ALTER TABLE [dbo].[sys_api_log] ADD  DEFAULT (NULL) FOR [resultData]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'方法名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sys_api_log', @level2type=N'COLUMN',@level2name=N'method'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'请求的方法路径' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sys_api_log', @level2type=N'COLUMN',@level2name=N'path'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'客户端IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sys_api_log', @level2type=N'COLUMN',@level2name=N'client'
GO

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

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sys_api_log', @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'sys_api_log', @level2type=N'COLUMN',@level2name=N'isdeleted'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sys_api_log', @level2type=N'COLUMN',@level2name=N'creator'
GO

EXEC sys.sp_addextended