USE [Sam_DB]
GO
/****** Object: Table [dbo].[Base_AppendProperty] Script Date: 2020/5/9 9:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_AppendProperty](
[Property_ID] [varchar](50) NOT NULL,
[Property_Function] [varchar](50) NULL,
[Property_Control_ID] [varchar](50) NULL,
[Property_Name] [varchar](50) NULL,
[Property_Control_DataSource] [varchar](max) NULL,
[Property_Control_Length] [int] NOT NULL,
[Property_Control_Style] [varchar](50) NULL,
[SortCode] [int] NULL,
[DeleteMark] [int] NULL,
[CreateDate] [date] NULL,
[CreateUserId] [varchar](50) NULL,
[CreateUserName] [varchar](50) NULL,
[ModifyDate] [datetime] NULL,
[ModifyUserId] [varchar](50) NULL,
[ModifyUserName] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Base_AppendPropertyInstance] Script Date: 2020/5/9 9:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_AppendPropertyInstance](
[PropertyInstance_ID] [varchar](50) NOT NULL,
[Property_Control_ID] [varchar](50) NULL,
[PropertyInstance_Value] [varchar](max) NULL,
[PropertyInstance_Key] [varchar](50) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Base_Log] Script Date: 2020/5/9 9:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_Log](
[LogID] [varchar](50) NOT NULL,
[Type] [varchar](50) NULL,
[LogMessage] [nvarchar](500) NULL,
[CreateTime] [datetime] NULL,
[CreateUserName] [varchar](50) NULL,
[CreateUserID] [varchar](50) NULL,
[LocalIP] [varchar](50) NULL,
[ClassName] [varchar](50) NULL,
CONSTRAINT [PK_Base_Log] PRIMARY KEY CLUSTERED
(
[LogID] 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
/****** Object: Table [dbo].[Base_Organization] Script Date: 2020/5/9 9:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_Organization](
[Organization_ID] [varchar](50) NOT NULL,
[Organization_Code] [varchar](20) NULL,
[Organization_Name] [varchar](50) NULL,
[Organization_InnerPhone] [varchar](20) NULL,
[Organization_OuterPhone] [varchar](20) NULL,
[Organization_Manager] [varchar](50) NULL,
[Organization_AssistantManager] [varchar](50) NULL,
[Organization_Fax] [varchar](20) NULL,
[Organization_Zipcode] [varchar](20) NULL,
[Organization_Address] [varchar](200) NULL,
[ParentId] [varchar](50) NULL,
[Organization_Remark] [varchar](200) NULL,
[SortCode] [int] NULL,
[DeleteMark] [int] NULL,
[CreateDate] [date] NULL,
[CreateUserId] [varchar](50) NULL,
[CreateUserName] [varchar](50) NULL,
[ModifyDate] [datetime] NULL,
[ModifyUserId] [varchar](50) NULL,
[ModifyUserName] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Base_RoleRight] Script Date: 2020/5/9 9:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_RoleRight](
[RoleRight_ID] [varchar](50) NOT NULL,
[Roles_ID] [varchar](50) NULL,
[Menu_Id] [varchar](50) NULL,
[CreateDate] [datetime] NULL,
[CreateUserId] [varchar](50) NULL,
[CreateUserName] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Base_Roles] Script Date: 2020/5/9 9:40:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Base_Roles](
[Roles_ID] [varchar](50) NOT NULL,
[ParentId] [varchar](50) NULL,
[Roles_Name] [varchar](50) NULL,
[Roles_Remark] [varchar](200) NULL,
[SortCode] [int] NULL,
[DeleteMark] [int] NULL,
[CreateDate] [datetime] NULL,
[CreateUserId] [varchar](50) NULL,
[CreateUserName] [varchar](50) NULL,
[ModifyDate] [datetime] NULL,
[ModifyUserId] [varchar](50) NULL,
[ModifyUserName] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Base_StaffOrganize] Script Date:�