XinXiangXLX_API/文档/Sql/sql_20190604...

USE [CallCenter_XinXiangXLX]
GO

/****** Object:  Table [dbo].[T_Sys_OperateLogs]    Script Date: 06/04/2019 15:25:38 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_Sys_OperateLogs]') AND type in (N'U'))
DROP TABLE [dbo].[T_Sys_OperateLogs]
GO

USE [CallCenter_XinXiangXLX]
GO

/****** Object:  Table [dbo].[T_Sys_OperateLogs]    Script Date: 06/04/2019 15:25:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[T_Sys_OperateLogs](
	[F_Id] [int] IDENTITY(1,1) NOT NULL,
	[F_OptBy] [nvarchar](500) NULL,--操作人工号
	[F_OptIP] [nvarchar](500) NULL,--操作人IP
	[F_OptOn] [datetime] NULL,--操作时间
	[F_OptCode] [nvarchar](50) NULL,--操作编号：add,edit,delete
	[F_Module] [nvarchar](2000) NULL,--模块名称
	[F_OptTables] [nvarchar](500) NULL,--操作表名
	[F_OptID] [nvarchar](500) null,--操作ID
	[F_Descript] [ntext] NULL,--操作描述
 CONSTRAINT [PK_T_Sys_OperateLogs] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_OptBy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作人IP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_OptIP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_OptOn'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作编号：add,edit,delete' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_OptCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模块名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_Module'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作表名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_OptTables'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_OptID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'操作描述' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_Sys_OperateLogs', @level2type=N'COLUMN',@level2name=N'F_Descript'
GO