ÿþUSE [WIDESEAWCS_FG] GO /****** Object: Table [dbo].[Dt_DeviceInfo] Script Date: 2026/4/1 19:34:20 ******/ 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](30) NOT NULL, [DeviceStatus] [varchar](20) NOT NULL, [DeviceIp] [varchar](20) NOT NULL, [DevicePort] [int] NOT NULL, [DevicePlcType] [varchar](20) NOT NULL, [DeviceRemark] [varchar](200) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, [DispatchId] [int] 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_DeviceProtocol] Script Date: 2026/4/1 19:34:20 ******/ 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](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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_DeviceProtocolDetail] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_DeviceProtocolDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [DeviceType] [varchar](30) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_DispatchInfo] Script Date: 2026/4/1 19:34:20 ******/ 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Platform] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Platform]( [Id] [int] IDENTITY(1,1) NOT NULL, [PlatCode] [varchar](50) NULL, [PlatformName] [varchar](50) NULL, [Stacker] [varchar](50) NULL, [ExecutionMethod] [varchar](50) NULL, [PlatformType] [varchar](50) NULL, [Location] [varchar](50) NULL, [Capacity] [int] NULL, [Status] [varchar](50) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, [ProductionLine] [varchar](50) NULL, [DeviceCode] [varchar](50) NULL, [Roadway] [varchar](50) NULL, CONSTRAINT [PK_Dt_Platform_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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Router] Script Date: 2026/4/1 19:34:20 ******/ 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_StationManager] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StationManager]( [stationID] [int] IDENTITY(1,1) NOT NULL, [stationType] [int] NOT NULL, [stationDeviceCode] [varchar](50) NULL, [Roadway] [varchar](100) NULL, [stationChildCode] [varchar](255) NULL, [stationRemark] [varchar](255) NULL, [stationArea] [varchar](20) NULL, [stationLocation] [varchar](20) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, [remark] [varchar](255) NULL, [stationStatus] [varchar](20) NULL, [stationFloor] [varchar](255) NULL, CONSTRAINT [PK_Dt_StationManager_stationID] PRIMARY KEY CLUSTERED ( [stationID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Task] Script Date: 2026/4/1 19:34:20 ******/ 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](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, [Dispatchertime] [datetime] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, [AGVSign] [varchar](255) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Task_Hty] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Task_Hty]( [TaskId] [int] IDENTITY(1,1) NOT NULL, [TaskNum] [varchar](100) NOT NULL, [PalletCode] [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, [Dispatchertime] [datetime] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, [AGVSign] [varchar](255) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_TaskExecuteDetail] Script Date: 2026/4/1 19:34:20 ******/ 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].[Sys_Config] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Config]( [Id] [int] IDENTITY(1,1) NOT NULL, [ConfigKey] [varchar](255) NOT NULL, [ConfigValue] [text] NOT NULL, [Category] [varchar](255) NOT NULL, [Remark] [varchar](255) NULL, [SortCode] [int] NULL, [Status] [varchar](20) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Config_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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_DelLog] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_DelLog]( [Id] [int] IDENTITY(1,1) NOT NULL, [FileName] [varchar](255) NOT NULL, [Url] [varchar](255) NULL, [IntervalTime] [int] NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__Sys_DelL__3214EC078D4DA87C] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Department] Script Date: 2026/4/1 19:34:20 ******/ 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 ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Dictionary] Script Date: 2026/4/1 19:34:20 ******/ 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](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_DictionaryList] Script Date: 2026/4/1 19:34:20 ******/ 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 ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Log] Script Date: 2026/4/1 19:34:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Log]( [Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [BeginDate] [datetime] NULL, [ElapsedTime] [int] NULL, [EndDate] [datetime] NULL, [RequestParam] [varchar](max) NULL, [ResponseParam] [varchar](max) NULL, [Success] [int] NULL, [Url] [varchar](max) NULL, [UserIP] [varchar](200) NULL, [UserName] [varchar](200) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Menu] Script Date: 2026/4/1 19:34:20 ******/ 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](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Role] Script Date: 2026/4/1 19:34:20 ******/ 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](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) 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, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_RoleAuth] Script Date: 2026/4/1 19:34:20 ******/ 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: 2026/4/1 19:34:20 ******/ 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: 2026/4/1 19:34:20 ******/ 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 SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] ON INSERT [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate], [DispatchId]) VALUES (1, N'OtherDevice', N' NMO:g', N'OtherDevice', N'1', N'127.0.0.1', 502, N'ModbusTcp', NULL, N'System', CAST(N'2025-09-22T10:47:31.000' AS DateTime), NULL, NULL, 1) SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] OFF GO SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] ON INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, 1, N'OtherDevice', N'500', CAST(0.0 AS Decimal(10, 1)), N'int', 1, N'Heart', N'ReadDeviceCommand', N'Ã_ó', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, 1, N'OtherDevice', N'502', CAST(2.0 AS Decimal(10, 1)), N'int', 1, N'FaultBit', N'ReadDeviceCommand', N'Eeœ–¶r`hƋ', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, 1, N'OtherDevice', N'504', CAST(4.0 AS Decimal(10, 1)), N'int', 1, N'FaultCode', N'ReadDeviceCommand', N'Eeœ–x', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, 1, N'OtherDevice', N'1000', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'UpPosition', N'ReadDeviceCommand', N' N™eMOnáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, 1, N'OtherDevice', N'1002', CAST(0.0 AS Decimal(10, 1)), N'int', 1, N'UpRequest', N'ReadDeviceCommand', N' N™e÷‹Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, 1, N'OtherDevice', N'1004', CAST(2.0 AS Decimal(10, 1)), N'int', 1, N'UpReplyRequest', N'DeviceCommand', N'ÞV Y÷‹Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, 1, N'OtherDevice', N'1006', CAST(4.0 AS Decimal(10, 1)), N'int', 1, N'RequestPut', N'DeviceCommand', N'÷‹Bl N™e:g>e™e', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, 1, N'OtherDevice', N'1008', CAST(6.0 AS Decimal(10, 1)), N'int', 1, N'AllowPut', N'ReadDeviceCommand', N' N™e:gAQ¸‹>e™e', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, 1, N'OtherDevice', N'1010', CAST(8.0 AS Decimal(10, 1)), N'int', 1, N'PutFinish', N'DeviceCommand', N'AGV>e™eŒ[b', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, 1, N'OtherDevice', N'1012', CAST(10.0 AS Decimal(10, 1)), N'int', 1, N'UpFaultBit', N'ReadDeviceCommand', N'Eeœ–¶r`hƋ', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, 1, N'OtherDevice', N'1014', CAST(12.0 AS Decimal(10, 1)), N'int', 1, N'UpFaultCode', N'ReadDeviceCommand', N'Eeœ–x', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, 1, N'OtherDevice', N'1016', CAST(14.0 AS Decimal(10, 1)), N'string', 25, N'UpBarcode', N'ReadDeviceCommand', N'agxáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, 1, N'OtherDevice', N'1067', CAST(16.0 AS Decimal(10, 1)), N'string', 1, N'UpErrorMessage', N'ReadDeviceCommand', N'_8^ˆmo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, 1, N'OtherDevice', N'2000', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'DownPosition', N'DeviceCommand', N' N™eMOnáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, 1, N'OtherDevice', N'2002', CAST(24.0 AS Decimal(10, 1)), N'int', 1, N'DownRequest', N'Reset', N' N™e÷‹Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (45, 1, N'OtherDevice', N'2004', CAST(14.0 AS Decimal(10, 1)), N'int', 1, N'DownReplyRequest', N'DeviceCommand', N'ÞV Y÷‹Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (46, 1, N'OtherDevice', N'2006', CAST(16.0 AS Decimal(10, 1)), N'int', 1, N'RequestPickUp', N'DeviceCommand', N'÷‹Bl N™e:gÖS™e', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (47, 1, N'OtherDevice', N'2008', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'AllowPickUp', N'DeviceCommand', N' N™e:gAQ¸‹ÖS™e', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (48, 1, N'OtherDevice', N'2010', CAST(24.0 AS Decimal(10, 1)), N'int', 1, N'PickUpFinish', N'Reset', N'AGVÖS™eŒ[b', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (50, 1, N'OtherDevice', N'2012', CAST(14.0 AS Decimal(10, 1)), N'int', 1, N'DownFaultBit', N'DeviceCommand', N'Eeœ–¶r`hƋ', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (51, 1, N'OtherDevice', N'2014', CAST(16.0 AS Decimal(10, 1)), N'int', 1, N'DownFaultCode', N'DeviceCommand', N'Eeœ–x', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (52, 1, N'OtherDevice', N'2016', CAST(18.0 AS Decimal(10, 1)), N'string', 25, N'DownBarcode', N'DeviceCommand', N'agxáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (53, 1, N'OtherDevice', N'2067', CAST(24.0 AS Decimal(10, 1)), N'string', 1, N'DownErrorMessage', N'Reset', N'_8^ˆmo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL) SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] OFF GO SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] ON INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'OtherDevice', N'StackerCraneAutoStatus', N'ShutDown', N'0', N'å]\O!j_(0:\P:g)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'OtherDevice', N'StackerCraneAutoStatus', N'Manual', N'1', N'å]\O!j_(1:Kb¨R ÿ', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'OtherDevice', N'StackerCraneAutoStatus', N'Automatic', N'2', N'å]\O!j_(2:ꁨR)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'OtherDevice', N'StackerCraneAutoStatus', N'ComputerMode', N'3', N'å]\O!j_(3:5u!j_)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'OtherDevice', N'StackerCraneWorkStatus', N'Standby', N'0', N'¾‹Y¶r`(0:…_:g)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'OtherDevice', N'StackerCraneWorkStatus', N'PickUpWalk', N'1', N'¾‹Y¶r`(1:ÖS'Lˆp)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'OtherDevice', N'StackerCraneWorkStatus', N'PickUpWait', N'2', N'¾‹Y¶r`(2:ÖS'I{…_)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'OtherDevice', N'StackerCraneWorkStatus', N'PickUp', N'3', N'¾‹Y¶r`(3:ÖS'-N)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'OtherDevice', N'StackerCraneWorkStatus', N'PutWalk', N'4', N'¾‹Y¶r`(4:>e'Lˆp)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'OtherDevice', N'StackerCraneWorkStatus', N'PutWait', N'5', N'¾‹Y¶r`(5:>e'I{…_)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'OtherDevice', N'StackerCraneWorkStatus', N'Puting', N'6', N'¾‹Y¶r`(6:>e'-N)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, N'OtherDevice', N'StackerCraneWorkStatus', N'ReturnOrigin', N'7', N'¾‹Y¶r`(7:ÞVŸS¹p)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'OtherDevice', N'StackerCraneWorkStatus', N'ReverseOrigin', N'8', N'¾‹Y¶r`(8:ÞVÍSŸS¹p)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'OtherDevice', N'StackerCraneWorkStatus', N'Walking', N'9', N'¾‹Y¶r`(9:pLˆ-N)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, N'OtherDevice', N'StackerCraneWorkStatus', N'WorkCompleted', N'10', N'¾‹Y¶r`(10:ûN¡RŒ[b)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (16, N'OtherDevice', N'StackerCraneWorkStatus', N'InStockStandby', N'11', N'¾‹Y¶r`(11: g'…_}T)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (17, N'OtherDevice', N'StackerCraneWorkStatus', N'Warning', N'99', N'¾‹Y¶r`(99:¥bf‹)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (18, N'OtherDevice', N'StackerCraneWorkStatus', N'Maintenance', N'100', N'¾‹Y¶r`(100:ô~îO)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL) SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] OFF GO SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] ON INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N' NMO:g', N'OtherDevice', N'WIDESEAWCS_Tasks', N'CommonOtherDevicesJob', 2, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime)) INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'“¿~', N'CommonConveyorLine', N'WIDESEAWCS_Tasks', N'CommonConveyorLineJob', 2, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime)) INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'åe×_', N'DelLog', N'WIDESEAWCS_Tasks', N'CommonDeleteLogJob', 86400, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime)) INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'AGV', N'AGVTask', N'WIDESEAWCS_Tasks', N'CommonAGVJob', 2, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime)) SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] OFF GO SET IDENTITY_INSERT [dbo].[Sys_Config] ON INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'WMSIPBASE', N'http://127.0.0.1:5000', N'SYS_IPAddress', N'', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:14.733' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'AGVIPBASE', N'http://10.31.1.188:7000', N'SYS_IPAddress', NULL, NULL, NULL, N'admin', CAST(N'2025-09-24T08:59:26.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'GetAGVTask', N'/ics/out/task/getTaskOrderStatus', N'SYS_IPAddress', N'AGVûN¡Råg⋥cãS', NULL, NULL, N'admin', CAST(N'2025-09-24T09:00:49.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'SendAGVTask', N'/ics/taskOrder/addTask', N'SYS_IPAddress', N'AGVûN¡R NÑS', NULL, NULL, N'admin', CAST(N'2025-09-24T09:03:05.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'ContinueAGVTask', N'/ics/out/task/continueTask', N'SYS_IPAddress', N'AGVûN¡Rç~í~', NULL, NULL, N'admin', CAST(N'2025-09-24T09:05:17.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'CancelAVTask', N'/ics/out/task/cancelTask', N'SYS_IPAddress', N'AGVÖSˆmûN¡R', NULL, NULL, N'admin', CAST(N'2025-09-24T09:06:21.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'GetAVGStatus', N'/ics/out/device/list/deviceInfo', N'SYS_IPAddress', N'·ƒÖSAGV¶r`', NULL, NULL, N'admin', CAST(N'2025-09-24T09:08:35.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'PauseAGVTask', N'/ics/out/controlDevice', N'SYS_IPAddress', N'‚f\P/b` YAGV', NULL, NULL, N'admin', CAST(N'2025-09-24T09:10:08.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'AcrossFloorTask', N'/api/Task/AcrossFloorTaskAsync', N'SYS_IPAddress', N'·ƒÖSè|iB\2ûN¡R', NULL, NULL, N'admin', CAST(N'2025-10-09T20:42:12.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'CompleteTask', N'/api/Task/CompleteTaskAsync', N'SYS_IPAddress', N'ûN¡RŒ[b', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (18, N'UpdateTaskStatus', N'/api/Task/UpdateTaskStatus', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (19, N'AcrossFloorTask', N'/api/Task/AcrossFloorTaskAsync', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (20, N'StackerIsNeedRelocation', N'/api/Task/StackerIsNeedRelocationAsync', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (21, N'AGVIsNeedRelocation', N'/api/Task/AGVIsNeedRelocationAsync', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (22, N'UpdateStartLocationInfo', N'/api/Task/UpdateStartLocationInfo', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (23, N'RequestLocation', N'/api/Task/RequestLocation', N'SYS_IPAddress', N'÷‹Bl'MO', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) SET IDENTITY_INSERT [dbo].[Sys_Config] OFF GO SET IDENTITY_INSERT [dbo].[Sys_DelLog] ON INSERT [dbo].[Sys_DelLog] ([Id], [FileName], [Url], [IntervalTime], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'Log', NULL, 180, N'admin', CAST(N'2025-09-24T09:48:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_DelLog] ([Id], [FileName], [Url], [IntervalTime], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'Log_PLCReadWrite', NULL, 180, N'admin', CAST(N'2025-09-24T09:52:45.000' AS DateTime), NULL, NULL) SET IDENTITY_INSERT [dbo].[Sys_DelLog] OFF GO SET IDENTITY_INSERT [dbo].[Sys_Department] ON INSERT [dbo].[Sys_Department] ([DepartmentId], [DepartmentName], [DepartmentCode], [ParentId], [DepartmentType], [Enable], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'Ym_lRè', N'1', 1, NULL, 1, NULL, N'admin', CAST(N'2025-04-02T14:36:09.000' AS DateTime), NULL, NULL) SET IDENTITY_INSERT [dbo].[Sys_Department] OFF GO SET IDENTITY_INSERT [dbo].[Sys_Dictionary] ON INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'{valueField: ''Enable'', textField: ''Enable'', containField: null, handler: null }', N'1', NULL, N'/f&Te'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_StationManager', @level2type=N'COLUMN',@level2name=N'stationID' 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_StationManager', @level2type=N'COLUMN',@level2name=N'stationType' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'@b^\PLC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationDeviceCode' 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_StationManager', @level2type=N'COLUMN',@level2name=N'Roadway' 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_StationManager', @level2type=N'COLUMN',@level2name=N'stationChildCode' 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_StationManager', @level2type=N'COLUMN',@level2name=N'stationRemark' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾‹Y:SßW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationArea' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PWh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationLocation' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^€' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @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_StationManager', @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_StationManager', @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_StationManager', @level2type=N'COLUMN',@level2name=N'ModifyDate' 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_StationManager', @level2type=N'COLUMN',@level2name=N'remark' 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'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationStatus' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'|iB\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationFloor' 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_StationManager' 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'û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'ÖS>e'hƋ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'AGVSign' 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'û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'ÖS>e'hƋ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_Hty', @level2type=N'COLUMN',@level2name=N'AGVSign' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R†SòSá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¡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'Sys_Config', @level2type=N'COLUMN',@level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M‘n.•' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @level2type=N'COLUMN',@level2name=N'ConfigKey' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M‘n