ÿþUSE [master]

GO

/****** Object:  Database [WIDESEAWCS_JAMK]    Script Date: 2025/2/12 14:34:26 ******/

CREATE DATABASE [WIDESEAWCS_JAMK]

 CONTAINMENT = NONE

 ON  PRIMARY 

( NAME = N'WIDESEAWCS_JAMK', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\WIDESEAWCS_JAMK.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )

 LOG ON 

( NAME = N'WIDESEAWCS_JAMK_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\WIDESEAWCS_JAMK_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET COMPATIBILITY_LEVEL = 130

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [WIDESEAWCS_JAMK].[dbo].[sp_fulltext_database] @action = 'enable'

end

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET ANSI_NULL_DEFAULT OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET ANSI_NULLS OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET ANSI_PADDING OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET ANSI_WARNINGS OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET ARITHABORT OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET AUTO_CLOSE OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET AUTO_SHRINK OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET AUTO_UPDATE_STATISTICS ON 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET CURSOR_CLOSE_ON_COMMIT OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET CURSOR_DEFAULT  GLOBAL 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET CONCAT_NULL_YIELDS_NULL OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET NUMERIC_ROUNDABORT OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET QUOTED_IDENTIFIER OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET RECURSIVE_TRIGGERS OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET  ENABLE_BROKER 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET DATE_CORRELATION_OPTIMIZATION OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET TRUSTWORTHY OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET ALLOW_SNAPSHOT_ISOLATION OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET PARAMETERIZATION SIMPLE 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET READ_COMMITTED_SNAPSHOT OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET HONOR_BROKER_PRIORITY OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET RECOVERY FULL 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET  MULTI_USER 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET PAGE_VERIFY CHECKSUM  

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET DB_CHAINING OFF 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET TARGET_RECOVERY_TIME = 60 SECONDS 

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET DELAYED_DURABILITY = DISABLED 

GO

EXEC sys.sp_db_vardecimal_storage_format N'WIDESEAWCS_JAMK', N'ON'

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET QUERY_STORE = OFF

GO

USE [WIDESEAWCS_JAMK]

GO

ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;

GO

ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;

GO

USE [WIDESEAWCS_JAMK]

GO

/****** Object:  Table [dbo].[Dt_DeviceInfo]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceInfo](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[DeviceCode] [varchar](20) NOT NULL,

	[DeviceName] [varchar](50) NOT NULL,

	[DeviceType] [varchar](50) NOT NULL,

	[DeviceStatus] [varchar](20) NOT NULL,

	[DeviceIp] [varchar](20) NOT NULL,

	[DevicePort] [int] NOT NULL,

	[DevicePlcType] [varchar](50) NOT NULL,

	[DeviceRemark] [varchar](200) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DeviceInfo_Id] 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]

GO

/****** Object:  Table [dbo].[Dt_DeviceProtocol]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceProtocol](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[DeviceId] [int] NOT NULL,

	[DeviceChildCode] [varchar](20) NOT NULL,

	[DeviceProDataBlock] [varchar](50) NOT NULL,

	[DeviceProOffset] [decimal](10, 1) NOT NULL,

	[DeviceProDataType] [varchar](10) NOT NULL,

	[DeviceProDataLength] [int] NOT NULL,

	[DeviceProParamName] [varchar](50) NOT NULL,

	[DeviceProParamType] [varchar](50) NOT NULL,

	[DeviceProParamDes] [varchar](50) NULL,

	[DeviceProRemark] [varchar](200) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DeviceProtocol_Id] 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]

GO

/****** Object:  Table [dbo].[Dt_DeviceProtocolDetail]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceProtocolDetail](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[DeviceType] [varchar](20) NOT NULL,

	[DeviceProParamName] [varchar](255) NOT NULL,

	[ProtocolDetailType] [varchar](50) NOT NULL,

	[ProtocalDetailValue] [varchar](50) NOT NULL,

	[ProtocolDetailDes] [varchar](500) NULL,

	[Remark] [varchar](200) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DeviceProtocolDetail_Id] 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]

GO

/****** Object:  Table [dbo].[Dt_DispatchInfo]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DispatchInfo](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[Name] [varchar](50) NOT NULL,

	[JobGroup] [varchar](50) NOT NULL,

	[AssemblyName] [varchar](50) NOT NULL,

	[ClassName] [varchar](50) NOT NULL,

	[IntervalSecond] [int] NOT NULL,

	[BeginTime] [datetime] NULL,

	[EndTime] [datetime] NULL,

	[Remark] [varchar](1000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DispatchInfo_Id] 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]

GO

/****** Object:  Table [dbo].[Dt_Router]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Router](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[StartPosi] [varchar](50) NOT NULL,

	[NextPosi] [varchar](50) NOT NULL,

	[InOutType] [bigint] NOT NULL,

	[ChildPosi] [varchar](50) NOT NULL,

	[ChildPosiDeviceCode] [varchar](50) NOT NULL,

	[SrmRow] [int] NULL,

	[SrmColumn] [int] NULL,

	[SrmLayer] [int] NULL,

	[Depth] [int] NULL,

	[IsEnd] [bit] NOT NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_Router_Id] 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]

GO

/****** Object:  Table [dbo].[Dt_Task]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Task](

	[TaskId] [int] IDENTITY(1,1) NOT NULL,

	[TaskNum] [int] NOT NULL,

	[PalletCode] [varchar](50) NOT NULL,

	[Roadway] [varchar](10) NOT NULL,

	[TaskType] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

	[SourceAddress] [varchar](20) NOT NULL,

	[TargetAddress] [varchar](20) NOT NULL,

	[CurrentAddress] [varchar](20) NOT NULL,

	[NextAddress] [varchar](20) NOT NULL,

	[ExceptionMessage] [varchar](500) NULL,

	[Grade] [int] NOT NULL,

	[WMSId] [int] NOT NULL,

	[Dispatchertime] [datetime] NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[PalletCodequantity] [int] NULL,

	[Station_storey] [int] NULL,

	[MaterialType] [int] NULL,

 CONSTRAINT [PK_Dt_Task_TaskId] PRIMARY KEY CLUSTERED 

(

	[TaskId] 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].[Dt_Task_hty]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Task_hty](

	[TaskId] [int] IDENTITY(1,1) NOT NULL,

	[TaskNum] [int] NOT NULL,

	[PalletCode] [varchar](50) NOT NULL,

	[Roadway] [varchar](10) NOT NULL,

	[TaskType] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

	[SourceAddress] [varchar](20) NOT NULL,

	[TargetAddress] [varchar](20) NOT NULL,

	[CurrentAddress] [varchar](20) NOT NULL,

	[NextAddress] [varchar](20) NOT NULL,

	[ExceptionMessage] [varchar](500) NULL,

	[Grade] [int] NOT NULL,

	[WMSId] [int] NOT NULL,

	[Dispatchertime] [datetime] NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[Station_storey] [int] NULL,

	[MaterialType] [int] NULL,

	[PalletCodequantity] [int] NULL,

 CONSTRAINT [PK_Dt_Task_TaskId_copy1] PRIMARY KEY CLUSTERED 

(

	[TaskId] 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].[Dt_TaskExecuteDetail]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_TaskExecuteDetail](

	[TaskDetailId] [int] IDENTITY(1,1) NOT NULL,

	[TaskId] [int] NOT NULL,

	[TaskNum] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

	[CurrentAddress] [varchar](20) NOT NULL,

	[NextAddress] [varchar](20) NOT NULL,

	[IsManual] [bit] NOT NULL,

	[IsNormal] [bit] NOT NULL,

	[Description] [varchar](max) NOT NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

/****** Object:  Table [dbo].[PlatformStation]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[PlatformStation](

	[Station_id] [int] IDENTITY(1,1) NOT NULL,

	[Station_code] [varchar](20) NULL,

	[Station_material] [int] NULL,

	[Station_enable] [int] NULL,

	[Station_storey] [int] NULL,

	[ChildPosiDeviceCode] [varchar](50) NULL,

 CONSTRAINT [PK__AGVStati__55F10CA68E88C31F] PRIMARY KEY CLUSTERED 

(

	[Station_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

/****** Object:  Table [dbo].[Sys_Department]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Department](

	[DepartmentId] [int] IDENTITY(1,1) NOT NULL,

	[DepartmentName] [varchar](50) NULL,

	[DepartmentCode] [varchar](50) NULL,

	[ParentId] [int] NOT NULL,

	[DepartmentType] [varchar](50) NULL,

	[Enable] [int] NOT NULL,

	[Remark] [varchar](2000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Department_DepartmentId] PRIMARY KEY CLUSTERED 

(

	[DepartmentId] 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].[Sys_Dictionary]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Dictionary](

	[DicId] [int] IDENTITY(1,1) NOT NULL,

	[Config] [varchar](200) NULL,

	[DBServer] [varchar](50) NULL,

	[DBSql] [varchar](500) NULL,

	[DicName] [varchar](50) NULL,

	[DicNo] [varchar](50) NULL,

	[Enable] [tinyint] NULL,

	[OrderNo] [int] NULL,

	[ParentId] [int] NULL,

	[Remark] [varchar](2000) NULL,

	[SystemType] [int] NOT NULL,

	[Creater] [varchar](50) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](50) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Dictionary_DicId] PRIMARY KEY CLUSTERED 

(

	[DicId] 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].[Sys_DictionaryList]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_DictionaryList](

	[DicListId] [int] IDENTITY(1,1) NOT NULL,

	[DicName] [varchar](50) NULL,

	[DicValue] [varchar](50) NULL,

	[DicId] [int] NOT NULL,

	[Enable] [tinyint] NULL,

	[OrderNo] [int] NULL,

	[Remark] [varchar](2000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_DictionaryList_DicListId] PRIMARY KEY CLUSTERED 

(

	[DicListId] 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].[Sys_Log]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Log](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[BeginDate] [datetime] NULL,

	[ElapsedTime] [int] NULL,

	[EndDate] [datetime] NULL,

	[RequestParam] [varchar](2000) NULL,

	[ResponseParam] [varchar](2000) NULL,

	[Success] [int] NULL,

	[Url] [varchar](2000) NULL,

	[UserIP] [varchar](20) NULL,

	[UserName] [varchar](50) NULL,

	[User_Id] [int] NULL,

 CONSTRAINT [PK_Sys_Log_Id] 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]

GO

/****** Object:  Table [dbo].[Sys_Menu]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Menu](

	[MenuId] [int] IDENTITY(1,1) NOT NULL,

	[MenuName] [varchar](50) NULL,

	[Auth] [varchar](2000) NULL,

	[Icon] [varchar](200) NULL,

	[Description] [varchar](2000) NULL,

	[Enable] [tinyint] NULL,

	[TableName] [varchar](50) NULL,

	[ParentId] [int] NOT NULL,

	[Url] [varchar](50) NULL,

	[OrderNo] [int] NULL,

	[MenuType] [int] NULL,

	[Creater] [varchar](50) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](50) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Menu_MenuId] PRIMARY KEY CLUSTERED 

(

	[MenuId] 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].[Sys_Role]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Role](

	[RoleId] [int] IDENTITY(1,1) NOT NULL,

	[DeptId] [int] NULL,

	[Enable] [tinyint] NOT NULL,

	[ParentId] [int] NOT NULL,

	[RoleName] [varchar](50) NOT NULL,

	[Creater] [varchar](50) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](50) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED 

(

	[RoleId] 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].[Sys_RoleAuth]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_RoleAuth](

	[AuthId] [int] IDENTITY(1,1) NOT NULL,

	[AuthValue] [varchar](500) NULL,

	[MenuId] [int] NOT NULL,

	[RoleId] [int] NULL,

	[UserId] [int] NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Tenant]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Tenant](

	[TenantId] [int] IDENTITY(1,1) NOT NULL,

	[TenantName] [varchar](200) NOT NULL,

	[TenantType] [int] NOT NULL,

	[DbType] [int] NOT NULL,

	[ConnectionString] [varchar](1000) NOT NULL,

	[Status] [int] NOT NULL,

	[Remark] [varchar](2000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_User]    Script Date: 2025/2/12 14:34:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_User](

	[User_Id] [int] IDENTITY(1,1) NOT NULL,

	[UserName] [varchar](100) NOT NULL,

	[Role_Id] [int] NOT NULL,

	[RoleName] [varchar](100) NULL,

	[PhoneNo] [varchar](11) NULL,

	[Remark] [varchar](200) NULL,

	[UserPwd] [varchar](200) NOT NULL,

	[UserTrueName] [varchar](100) NOT NULL,

	[DeptName] [varchar](100) NULL,

	[Dept_Id] [int] NULL,

	[Email] [varchar](100) NULL,

	[Enable] [tinyint] NOT NULL,

	[Gender] [int] NULL,

	[HeadImageUrl] [varchar](500) NULL,

	[LastModifyPwdDate] [datetime] NULL,

	[Address] [varchar](200) NULL,

	[AuditDate] [datetime] NULL,

	[AuditStatus] [int] NULL,

	[Auditor] [varchar](100) NULL,

	[Token] [varchar](500) NULL,

	[TenantId] [bigint] NOT NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Dt_DeviceProtocol] ADD  DEFAULT ('1') FOR [DeviceProDataLength]

GO

ALTER TABLE [dbo].[Sys_User] ADD  DEFAULT ('0') FOR [TenantId]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YIP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceIp'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YïzãS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DevicePort'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PLC{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DevicePlcType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceRemark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YP[÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceChildCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OS®pencWW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataBlock'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OPûyÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProOffset'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataLength'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpe
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpe{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpeôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamDes'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProRemark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'DeviceType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®ÂSpe
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'DeviceProParamName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocolDetailType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~ÖS<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocalDetailValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~ôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocolDetailDes'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Name'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RRÄ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'JobGroup'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R@b(WDLLù[^vz^Æ
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'AssemblyName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R@b(W{|' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'ClassName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gbLôöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'IntervalSecond'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_ËYöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'BeginTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_göeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'EndTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RÏcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¦^
g¡RMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'w¹pMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'StartPosi'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'È~¹pMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'NextPosi'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ï1u{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'InOutType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[MOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ChildPosi'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[MOn@b^\¾Y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ChildPosiDeviceCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'L' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmRow'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmColumn'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'B\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmLayer'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ñm¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Depth'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/fgÈ~¹p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'IsEnd'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Yï1uMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Roadway'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'wËY0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'SourceAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TargetAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CurrentAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'NextAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_8^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'ExceptionMessage'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OHQ§~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Grade'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WMSûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'WMSId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RNÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Dispatchertime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCodequantity'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'|iB\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Station_storey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ire{|Wÿàe(uW[µk	ÿ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'MaterialType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'PalletCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Roadway'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'wËY0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'SourceAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TargetAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'CurrentAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'NextAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_8^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'ExceptionMessage'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OHQ§~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Grade'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WMSûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'WMSId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RNÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Dispatchertime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'|iB\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Station_storey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ire{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'MaterialType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØvpeÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'PalletCodequantity'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskDetailId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'CurrentAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'NextAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TºNå]Íd\O' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsManual'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&Tck8^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsNormal'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Description'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RgbLfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðSid' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PlatformStation', @level2type=N'COLUMN',@level2name=N'Station_id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PlatformStation', @level2type=N'COLUMN',@level2name=N'Station_code'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PlatformStation', @level2type=N'COLUMN',@level2name=N'Station_material'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PlatformStation', @level2type=N'COLUMN',@level2name=N'Station_enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'|iB\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PlatformStation', @level2type=N'COLUMN',@level2name=N'Station_storey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS@b^\¾Y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PlatformStation', @level2type=N'COLUMN',@level2name=N'ChildPosiDeviceCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N§~Ä~Ç~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~¶gg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Mny' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Config'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc^
g¡R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DBServer'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SqlíåS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DBSql'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQ
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'OrderNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6r§~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'û|ß~{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'SystemType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQpenc' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQRhID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicListId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnText' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnValue' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'OrderNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_ËYöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'BeginDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'öe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'ElapsedTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_göeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'EndDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷BlÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'RequestParam'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÍT^ÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'ResponseParam'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÍT^¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Success'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷Bl0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Url'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bIP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'UserIP'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'UserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'User_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUS
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CgP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Auth'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'þVh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Icon'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Description'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h
T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'TableName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6r§~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ï_' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Url'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'OrderNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'DeptId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6rID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òrh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr«ýNÁID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bCgP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'MenuId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÒrID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'RoleId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'UserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr«ýNÁ¡{t' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc^{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'DbType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þ¥cW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ConnectionString'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Status'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'User_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÒrID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Role_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'RoleName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'5uÝ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'PhoneNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Æ[x' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserPwd'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'w[ÓY
T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserTrueName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'DeptName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èèID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Dept_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'®±{' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Email'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''`+R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Gender'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'4YÏP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'HeadImageUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gTÆ[xîO9eöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'LastModifyPwdDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Address'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8höeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8h¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8hºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Auditor'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'äNLr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Token'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'TenantId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User'

GO

USE [master]

GO

ALTER DATABASE [WIDESEAWCS_JAMK] SET  READ_WRITE 

GO

