ÿþUSE [master] GO /****** Object: Database [WCS_TC] Script Date: 2025/4/16 21:36:50 ******/ CREATE DATABASE [WCS_TC] CONTAINMENT = NONE ON PRIMARY ( NAME = N'WCS_TC', FILENAME = N'E:\TCDB\UseDB\WCS_TC.mdf' , SIZE = 1515520KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) LOG ON ( NAME = N'WCS_TC_log', FILENAME = N'E:\TCDB\UseDB\WCS_TC_log.ldf' , SIZE = 1449984KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) WITH CATALOG_COLLATION = DATABASE_DEFAULT GO ALTER DATABASE [WCS_TC] SET COMPATIBILITY_LEVEL = 150 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [WCS_TC].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [WCS_TC] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [WCS_TC] SET ANSI_NULLS OFF GO ALTER DATABASE [WCS_TC] SET ANSI_PADDING OFF GO ALTER DATABASE [WCS_TC] SET ANSI_WARNINGS OFF GO ALTER DATABASE [WCS_TC] SET ARITHABORT OFF GO ALTER DATABASE [WCS_TC] SET AUTO_CLOSE OFF GO ALTER DATABASE [WCS_TC] SET AUTO_SHRINK OFF GO ALTER DATABASE [WCS_TC] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [WCS_TC] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [WCS_TC] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [WCS_TC] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [WCS_TC] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [WCS_TC] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [WCS_TC] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [WCS_TC] SET DISABLE_BROKER GO ALTER DATABASE [WCS_TC] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [WCS_TC] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [WCS_TC] SET TRUSTWORTHY OFF GO ALTER DATABASE [WCS_TC] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [WCS_TC] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [WCS_TC] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [WCS_TC] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [WCS_TC] SET RECOVERY FULL GO ALTER DATABASE [WCS_TC] SET MULTI_USER GO ALTER DATABASE [WCS_TC] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [WCS_TC] SET DB_CHAINING OFF GO ALTER DATABASE [WCS_TC] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) GO ALTER DATABASE [WCS_TC] SET TARGET_RECOVERY_TIME = 60 SECONDS GO ALTER DATABASE [WCS_TC] SET DELAYED_DURABILITY = DISABLED GO ALTER DATABASE [WCS_TC] SET QUERY_STORE = OFF GO USE [WCS_TC] GO /****** Object: Table [dbo].[Dt_ApiInfo] Script Date: 2025/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_ApiInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [ApiCode] [varchar](50) NOT NULL, [ApiName] [varchar](50) NULL, [ApiAddress] [varchar](200) NOT NULL, [Remark] [varchar](50) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_ApiInfo_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_DeviceInfo] Script Date: 2025/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_DeviceInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [DispatchId] [int] NULL, [DeviceCode] [varchar](20) NOT NULL, [DeviceName] [varchar](50) NOT NULL, [DeviceType] [varchar](20) 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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/4/16 21:36:50 ******/ 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](10) 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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/4/16 21:36:50 ******/ 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](50) NOT NULL, [ProtocolDetailType] [varchar](50) NOT NULL, [ProtocalDetailValue] [varchar](50) NOT NULL, [ProtocolDetailDes] [varchar](500) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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/4/16 21:36:50 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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/4/16 21:36:50 ******/ 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] [int] 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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_StationManger] Script Date: 2025/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StationManger]( [Id] [int] IDENTITY(1,1) NOT NULL, [StationCode] [varchar](50) NOT NULL, [StationName] [varchar](50) NULL, [StationType] [int] NOT NULL, [StackerCraneStationCode] [varchar](50) NOT NULL, [StationDeviceCode] [varchar](50) NOT NULL, [StackerCraneCode] [varchar](50) NOT NULL, [AGVStationCode] [varchar](50) NULL, [Remark] [varchar](50) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [IsOccupied] [int] NULL, CONSTRAINT [PK_Dt_StationManger_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/4/16 21:36:50 ******/ 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, [PalletType] [int] NOT NULL, [DeviceCode] [varchar](50) NOT NULL, [Roadway] [varchar](10) NOT NULL, [TaskType] [int] NOT NULL, [TaskState] [int] NOT NULL, [SourceAddress] [varchar](50) NOT NULL, [TargetAddress] [varchar](50) NOT NULL, [CurrentAddress] [varchar](50) NOT NULL, [NextAddress] [varchar](50) NOT NULL, [ExceptionMessage] [varchar](500) NULL, [Grade] [int] NOT NULL, [WMSId] [int] NOT NULL, [Dispatchertime] [datetime] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [AgvTaskNum] [varchar](50) NULL, [WarehouseId] [int] NULL, [HeightType] [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/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Task_Hty]( [TaskId] [int] IDENTITY(1,1) NOT NULL, [SourceId] [int] NOT NULL, [OperateType] [varchar](255) NOT NULL, [InsertTime] [datetime] NOT NULL, [TaskNum] [int] NOT NULL, [AgvTaskNum] [varchar](50) NULL, [PalletCode] [varchar](50) NOT NULL, [PalletType] [int] NOT NULL, [DeviceCode] [varchar](50) NOT NULL, [Roadway] [varchar](10) NOT NULL, [TaskType] [int] NOT NULL, [TaskState] [int] NOT NULL, [SourceAddress] [varchar](50) NOT NULL, [TargetAddress] [varchar](50) NOT NULL, [CurrentAddress] [varchar](50) NOT NULL, [NextAddress] [varchar](50) NOT NULL, [ExceptionMessage] [varchar](500) NULL, [Grade] [int] NOT NULL, [WMSId] [int] NOT NULL, [Dispatchertime] [datetime] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, [WarehouseId] [int] NULL, [HeightType] [int] NULL, CONSTRAINT [PK_Dt_Task_Hty_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_TaskExecuteDetail] Script Date: 2025/4/16 21:36:50 ******/ 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](50) NOT NULL, [NextAddress] [varchar](50) NOT NULL, [IsManual] [bit] NOT NULL, [IsNormal] [bit] NOT NULL, [Description] [varchar](max) NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_TaskExecuteDetail_TaskDetailId] PRIMARY KEY CLUSTERED ( [TaskDetailId] 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 /****** Object: Table [dbo].[Dt_Warehouse] Script Date: 2025/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Warehouse]( [WarehouseId] [int] NOT NULL, [WarehouseCode] [varchar](20) NOT NULL, [WarehouseName] [varchar](20) NOT NULL, [WarehouseType] [varchar](20) NOT NULL, [WarehouseStatus] [int] NOT NULL, [WarehouseDes] [varchar](255) NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_Warehouse_WarehouseId] PRIMARY KEY CLUSTERED ( [WarehouseId] 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_WarehouseDevice] Script Date: 2025/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_WarehouseDevice]( [Id] [int] IDENTITY(1,1) NOT NULL, [DeviceId] [int] NOT NULL, [DeviceCode] [varchar](50) NOT NULL, [DeviceName] [varchar](50) NOT NULL, [WarehouseId] [int] NOT NULL, [WarehouseCode] [varchar](50) NOT NULL, [WarehouseName] [varchar](50) NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_WarehouseDevice_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_Department] Script Date: 2025/4/16 21:36:50 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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/4/16 21:36:50 ******/ 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/4/16 21:36:50 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) 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/4/16 21:36:50 ******/ 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](max) NULL, [ResponseParam] [varchar](max) NULL, [Success] [int] NULL, [Url] [varchar](2000) NULL, [UserIP] [varchar](20) NULL, [UserName] [varchar](50) NULL, [UserId] [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] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Menu] Script Date: 2025/4/16 21:36:50 ******/ 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/4/16 21:36:50 ******/ 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/4/16 21:36:50 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_RoleAuth_AuthId] PRIMARY KEY CLUSTERED ( [AuthId] 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_RoleDataPermission] Script Date: 2025/4/16 21:36:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_RoleDataPermission]( [Id] [int] IDENTITY(1,1) NOT NULL, [RoleId] [int] NOT NULL, [RoleName] [varchar](50) NOT NULL, [WarehouseId] [int] NOT NULL, [WarehouseName] [varchar](50) NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_RoleDataPermission_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_Tenant] Script Date: 2025/4/16 21:36:50 ******/ 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](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Tenant_TenantId] PRIMARY KEY CLUSTERED ( [TenantId] 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_User] Script Date: 2025/4/16 21:36:50 ******/ 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, [Remark] [varchar](200) NULL, [UserPwd] [varchar](200) NOT NULL, [UserTrueName] [varchar](100) NOT NULL, [Enable] [tinyint] NOT NULL, [HeadImageUrl] [varchar](500) NULL, [LastModifyPwdDate] [datetime] NULL, [TenantId] [bigint] NOT NULL, [Creater] [varchar](50) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](50) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_User_User_Id] PRIMARY KEY CLUSTERED ( [User_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 ALTER TABLE [dbo].[Dt_DeviceProtocol] ADD DEFAULT ('1') FOR [DeviceProDataLength] GO ALTER TABLE [dbo].[Dt_Warehouse] ADD DEFAULT ('0') FOR [WarehouseStatus] 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_ApiInfo', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ApiCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãS Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ApiName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãS0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo', @level2type=N'COLUMN',@level2name=N'ApiAddress' 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_ApiInfo', @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_ApiInfo', @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_ApiInfo', @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_ApiInfo', @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_ApiInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¥cãSáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_ApiInfo' 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'Œ¦^hˆ;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DispatchId' 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Æ~ÖSe'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'X›W: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'X›W: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ï1uM‘n' , @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_StationManger', @level2type=N'COLUMN',@level2name=N'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'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'StationCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'StationName' 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'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'StationType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ù[”^X›W:g’c-R-B\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'StackerCraneStationCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS¾‹Y÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'StationDeviceCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'X›W:g÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'StackerCraneCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'AGVÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'AGVStationCode' 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_StationManger', @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_StationManger', @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_StationManger', @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_StationManger', @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_StationManger', @level2type=N'COLUMN',@level2name=N'ModifyDate' 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'Dt_StationManger', @level2type=N'COLUMN',@level2name=N'IsOccupied' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðShˆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManger' 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'XbØv{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletType' 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_Task', @level2type=N'COLUMN',@level2name=N'DeviceCode' 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¡R NÑ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'AGVûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'AgvTaskNum' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ؚ¦^{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'HeightType' 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'AGVûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_Hty', @level2type=N'COLUMN',@level2name=N'AgvTaskNum' 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'XbØv{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_Hty', @level2type=N'COLUMN',@level2name=N'PalletType' 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_Task_Hty', @level2type=N'COLUMN',@level2name=N'DeviceCode' 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¡R NÑ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'ؚ¦^{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_Hty', @level2type=N'COLUMN',@level2name=N'HeightType' 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¡RgbLˆfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse', @level2type=N'COLUMN',@level2name=N'WarehouseCode' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^ Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse', @level2type=N'COLUMN',@level2name=N'WarehouseName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^{|‹W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse', @level2type=N'COLUMN',@level2name=N'WarehouseType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse', @level2type=N'COLUMN',@level2name=N'WarehouseStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse', @level2type=N'COLUMN',@level2name=N'WarehouseDes' 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_Warehouse', @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_Warehouse', @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_Warehouse', @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_Warehouse', @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_Warehouse', @level2type=N'COLUMN',@level2name=N'ModifyDate' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Warehouse' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_WarehouseDevice', @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_WarehouseDevice', @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_WarehouseDevice', @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_WarehouseDevice', @level2type=N'COLUMN',@level2name=N'ModifyDate' 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'Ä~Ç~¶g„g' , @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'M‘ny˜' , @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[xQRhˆID' , @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'pencnText' , @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'pencnValue' , @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'pencnID' , @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'UserId' 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'܃USM‘n' , @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'҉r‚hˆ' , @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'҉r‚ID' , @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';N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleDataPermission', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'҉r‚;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleDataPermission', @level2type=N'COLUMN',@level2name=N'RoleId' 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_RoleDataPermission', @level2type=N'COLUMN',@level2name=N'RoleName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^;N.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleDataPermission', @level2type=N'COLUMN',@level2name=N'WarehouseId' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN“^ Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleDataPermission', @level2type=N'COLUMN',@level2name=N'WarehouseName' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleDataPermission', @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_RoleDataPermission', @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_RoleDataPermission', @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_RoleDataPermission', @level2type=N'COLUMN',@level2name=N'ModifyDate' 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'҉r‚ID' , @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'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'/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'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'ß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 [WCS_TC] SET READ_WRITE GO