数据库用户配置表

1

USE [HF_CloudSystem]
GO

/****** Object:  Table [dbo].[ControlSettings]    Script Date: 2019/7/30 13:49:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[ControlSettings](
 [SettingId] [bigint] IDENTITY(1,1) NOT NULL,
 [SettingName] [nvarchar](max) NULL,
 [SettingDesc] [nvarchar](max) NULL,
 [SettingCategory] [nvarchar](max) NULL,
 [SettingValue] [nvarchar](max) NULL,
 [SettingValueDefault] [nvarchar](max) NULL,
 [TenantId] [int] NULL,
 [CreatorUserId] [bigint] NULL,
 [CreationTime] [datetime2](7) NOT NULL,
 [LastModificationTime] [datetime2](7) NULL,
 [LastModifierUserId] [bigint] NULL,
 [DeleterUserId] [bigint] NULL,
 [DeletionTime] [datetime2](7) NULL,
 [IsDeleted] [bit] NOT NULL,
 CONSTRAINT [PK_ControlSettings] PRIMARY KEY CLUSTERED 
(
 [SettingId] 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