<?xml version="1.0" encoding="utf-8"?>
|
<Schema Namespace="TEST.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
|
<EntityContainer Name="TESTStoreContainer">
|
<EntitySet Name="__EFMigrationsHistory" EntityType="TEST.Store.__EFMigrationsHistory" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="Base_SysExceptionInfo" EntityType="TEST.Store.Base_SysExceptionInfo" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_app" EntityType="TEST.Store.sys_app" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_code_gen" EntityType="TEST.Store.sys_code_gen" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_code_gen_config" EntityType="TEST.Store.sys_code_gen_config" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_code_modular" EntityType="TEST.Store.sys_code_modular" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_config" EntityType="TEST.Store.sys_config" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_dict_data" EntityType="TEST.Store.sys_dict_data" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_dict_type" EntityType="TEST.Store.sys_dict_type" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_emp" EntityType="TEST.Store.sys_emp" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_emp_ext_org_pos" EntityType="TEST.Store.sys_emp_ext_org_pos" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_emp_pos" EntityType="TEST.Store.sys_emp_pos" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_file" EntityType="TEST.Store.sys_file" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_forms" EntityType="TEST.Store.sys_forms" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_log_audit" EntityType="TEST.Store.sys_log_audit" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_log_ex" EntityType="TEST.Store.sys_log_ex" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_log_op" EntityType="TEST.Store.sys_log_op" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_log_vis" EntityType="TEST.Store.sys_log_vis" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_low_code_module" EntityType="TEST.Store.sys_low_code_module" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_low_code_module_database" EntityType="TEST.Store.sys_low_code_module_database" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_menu" EntityType="TEST.Store.sys_menu" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_notice" EntityType="TEST.Store.sys_notice" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_notice_user" EntityType="TEST.Store.sys_notice_user" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_org" EntityType="TEST.Store.sys_org" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_pos" EntityType="TEST.Store.sys_pos" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_role" EntityType="TEST.Store.sys_role" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_role_data_scope" EntityType="TEST.Store.sys_role_data_scope" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_role_menu" EntityType="TEST.Store.sys_role_menu" store:Type="Tables" store:Schema="dbo" store:Name="sys_role_menu">
|
<DefiningQuery>SELECT
|
[sys_role_menu].[SysRoleId] AS [SysRoleId],
|
[sys_role_menu].[SysMenuId] AS [SysMenuId]
|
FROM [dbo].[sys_role_menu] AS [sys_role_menu]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="sys_timer" EntityType="TEST.Store.sys_timer" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_user" EntityType="TEST.Store.sys_user" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_user_data_scope" EntityType="TEST.Store.sys_user_data_scope" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="sys_user_role" EntityType="TEST.Store.sys_user_role" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="ware_container_vs_material" EntityType="TEST.Store.ware_container_vs_material" store:Type="Tables" store:Schema="dbo" store:Name="ware_container_vs_material">
|
<DefiningQuery>SELECT
|
[ware_container_vs_material].[Id] AS [Id],
|
[ware_container_vs_material].[WareContainerCode] AS [WareContainerCode],
|
[ware_container_vs_material].[WareMaterialCode] AS [WareMaterialCode],
|
[ware_container_vs_material].[Quantity] AS [Quantity],
|
[ware_container_vs_material].[PurchaseNo] AS [PurchaseNo],
|
[ware_container_vs_material].[DeliveryNo] AS [DeliveryNo],
|
[ware_container_vs_material].[CollectNo] AS [CollectNo],
|
[ware_container_vs_material].[OrdersNo] AS [OrdersNo],
|
[ware_container_vs_material].[Status] AS [Status],
|
[ware_container_vs_material].[CreatedTime] AS [CreatedTime],
|
[ware_container_vs_material].[UpdatedTime] AS [UpdatedTime],
|
[ware_container_vs_material].[CreatedUserId] AS [CreatedUserId],
|
[ware_container_vs_material].[CreatedUserName] AS [CreatedUserName],
|
[ware_container_vs_material].[UpdatedUserName] AS [UpdatedUserName],
|
[ware_container_vs_material].[UpdatedUserId] AS [UpdatedUserId],
|
[ware_container_vs_material].[IsLocked] AS [IsLocked],
|
[ware_container_vs_material].[IsDeleted] AS [IsDeleted],
|
[ware_container_vs_material].[Remarks] AS [Remarks],
|
[ware_container_vs_material].[StockStatus] AS [StockStatus],
|
[ware_container_vs_material].[Price] AS [Price],
|
[ware_container_vs_material].[BarNo] AS [BarNo],
|
[ware_container_vs_material].[OrderType] AS [OrderType],
|
[ware_container_vs_material].[Unit] AS [Unit],
|
[ware_container_vs_material].[WareMaterialName] AS [WareMaterialName]
|
FROM [dbo].[ware_container_vs_material] AS [ware_container_vs_material]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="ware_device_wareing" EntityType="TEST.Store.ware_device_wareing" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="ware_flow_record" EntityType="TEST.Store.ware_flow_record" store:Type="Tables" store:Schema="dbo" store:Name="ware_flow_record">
|
<DefiningQuery>SELECT
|
[ware_flow_record].[Id] AS [Id],
|
[ware_flow_record].[RecordType] AS [RecordType],
|
[ware_flow_record].[ReservoirArea] AS [ReservoirArea],
|
[ware_flow_record].[WareHousingNo] AS [WareHousingNo],
|
[ware_flow_record].[PurchaseNo] AS [PurchaseNo],
|
[ware_flow_record].[DeliveryNo] AS [DeliveryNo],
|
[ware_flow_record].[CollectNo] AS [CollectNo],
|
[ware_flow_record].[SourceWareLocationCode] AS [SourceWareLocationCode],
|
[ware_flow_record].[ToWareLocationCode] AS [ToWareLocationCode],
|
[ware_flow_record].[WareContainerCode] AS [WareContainerCode],
|
[ware_flow_record].[WareContainerName] AS [WareContainerName],
|
[ware_flow_record].[WareMaterialCode] AS [WareMaterialCode],
|
[ware_flow_record].[WareMaterialName] AS [WareMaterialName],
|
[ware_flow_record].[Quantity] AS [Quantity],
|
[ware_flow_record].[BarCode] AS [BarCode],
|
[ware_flow_record].[BasicSupplierInfoCode] AS [BasicSupplierInfoCode],
|
[ware_flow_record].[WarehousingType] AS [WarehousingType],
|
[ware_flow_record].[WareGoodsshelvesCode] AS [WareGoodsshelvesCode],
|
[ware_flow_record].[Status] AS [Status],
|
[ware_flow_record].[TenantId] AS [TenantId],
|
[ware_flow_record].[CreatedTime] AS [CreatedTime],
|
[ware_flow_record].[UpdatedTime] AS [UpdatedTime],
|
[ware_flow_record].[CreatedUserId] AS [CreatedUserId],
|
[ware_flow_record].[CreatedUserName] AS [CreatedUserName],
|
[ware_flow_record].[UpdatedUserName] AS [UpdatedUserName],
|
[ware_flow_record].[UpdatedUserId] AS [UpdatedUserId],
|
[ware_flow_record].[IsDeleted] AS [IsDeleted],
|
[ware_flow_record].[Remarks] AS [Remarks],
|
[ware_flow_record].[OutInFlag] AS [OutInFlag],
|
[ware_flow_record].[SpecificationModel] AS [SpecificationModel],
|
[ware_flow_record].[U8Warehouse] AS [U8Warehouse],
|
[ware_flow_record].[U8DepName] AS [U8DepName],
|
[ware_flow_record].[cWhName] AS [cWhName]
|
FROM [dbo].[ware_flow_record] AS [ware_flow_record]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="ware_location_vs_container" EntityType="TEST.Store.ware_location_vs_container" store:Type="Tables" store:Schema="dbo" store:Name="ware_location_vs_container">
|
<DefiningQuery>SELECT
|
[ware_location_vs_container].[Id] AS [Id],
|
[ware_location_vs_container].[WareStorehouseCode] AS [WareStorehouseCode],
|
[ware_location_vs_container].[WareRegionCode] AS [WareRegionCode],
|
[ware_location_vs_container].[WareLocationCode] AS [WareLocationCode],
|
[ware_location_vs_container].[WareContainerCode] AS [WareContainerCode],
|
[ware_location_vs_container].[IsEmptyContainer] AS [IsEmptyContainer],
|
[ware_location_vs_container].[Status] AS [Status],
|
[ware_location_vs_container].[CreatedTime] AS [CreatedTime],
|
[ware_location_vs_container].[UpdatedTime] AS [UpdatedTime],
|
[ware_location_vs_container].[CreatedUserId] AS [CreatedUserId],
|
[ware_location_vs_container].[CreatedUserName] AS [CreatedUserName],
|
[ware_location_vs_container].[UpdatedUserName] AS [UpdatedUserName],
|
[ware_location_vs_container].[UpdatedUserId] AS [UpdatedUserId],
|
[ware_location_vs_container].[IsDeleted] AS [IsDeleted],
|
[ware_location_vs_container].[Remarks] AS [Remarks],
|
[ware_location_vs_container].[Row] AS [Row],
|
[ware_location_vs_container].[Lane] AS [Lane],
|
[ware_location_vs_container].[LocTypeCode] AS [LocTypeCode],
|
[ware_location_vs_container].[DeepcellNo] AS [DeepcellNo],
|
[ware_location_vs_container].[UnionCode] AS [UnionCode],
|
[ware_location_vs_container].[WareContainerName] AS [WareContainerName]
|
FROM [dbo].[ware_location_vs_container] AS [ware_location_vs_container]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="ware_site" EntityType="TEST.Store.ware_site" store:Type="Tables" store:Schema="dbo" store:Name="ware_site">
|
<DefiningQuery>SELECT
|
[ware_site].[Id] AS [Id],
|
[ware_site].[Code] AS [Code],
|
[ware_site].[Describe] AS [Describe],
|
[ware_site].[Xcoordinate] AS [Xcoordinate],
|
[ware_site].[Ycoordinate] AS [Ycoordinate],
|
[ware_site].[Status] AS [Status],
|
[ware_site].[CreatedTime] AS [CreatedTime],
|
[ware_site].[UpdatedTime] AS [UpdatedTime],
|
[ware_site].[CreatedUserId] AS [CreatedUserId],
|
[ware_site].[TenantId] AS [TenantId],
|
[ware_site].[CreatedUserName] AS [CreatedUserName],
|
[ware_site].[UpdatedUserId] AS [UpdatedUserId],
|
[ware_site].[UpdatedUserName] AS [UpdatedUserName],
|
[ware_site].[IsDeleted] AS [IsDeleted],
|
[ware_site].[Name] AS [Name],
|
[ware_site].[SiteType] AS [SiteType],
|
[ware_site].[Lane] AS [Lane],
|
[ware_site].[OperationRemarks] AS [OperationRemarks],
|
[ware_site].[LineType] AS [LineType]
|
FROM [dbo].[ware_site] AS [ware_site]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="ware_task" EntityType="TEST.Store.ware_task" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="ware_task_bak" EntityType="TEST.Store.ware_task_bak" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="ware_task_sub" EntityType="TEST.Store.ware_task_sub" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="ware_task_sub_bak" EntityType="TEST.Store.ware_task_sub_bak" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_area" EntityType="TEST.Store.wms_area" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_container" EntityType="TEST.Store.wms_container" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_container_type" EntityType="TEST.Store.wms_container_type" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_location_type" EntityType="TEST.Store.wms_location_type" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_material" EntityType="TEST.Store.wms_material" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_materialcontainer" EntityType="TEST.Store.wms_materialcontainer" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_materialstock" EntityType="TEST.Store.wms_materialstock" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_part" EntityType="TEST.Store.wms_part" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_place" EntityType="TEST.Store.wms_place" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="wms_task" EntityType="TEST.Store.wms_task" store:Type="Tables" Schema="dbo" />
|
<EntitySet Name="v_empty_location" EntityType="TEST.Store.v_empty_location" store:Type="Views" store:Schema="dbo" store:Name="v_empty_location">
|
<DefiningQuery>SELECT
|
[v_empty_location].[Id] AS [Id],
|
[v_empty_location].[PlaceCode] AS [PlaceCode],
|
[v_empty_location].[PlaceStatus] AS [PlaceStatus],
|
[v_empty_location].[AreaId] AS [AreaId],
|
[v_empty_location].[RowNo] AS [RowNo],
|
[v_empty_location].[ColumnNo] AS [ColumnNo],
|
[v_empty_location].[LayerNo] AS [LayerNo],
|
[v_empty_location].[DeepcellNo] AS [DeepcellNo],
|
[v_empty_location].[Aisle] AS [Aisle],
|
[v_empty_location].[Line] AS [Line],
|
[v_empty_location].[Islock] AS [Islock],
|
[v_empty_location].[EmptyContainer] AS [EmptyContainer],
|
[v_empty_location].[PositionnoForSrm] AS [PositionnoForSrm],
|
[v_empty_location].[Xzb] AS [Xzb],
|
[v_empty_location].[Yzb] AS [Yzb],
|
[v_empty_location].[Zzb] AS [Zzb],
|
[v_empty_location].[Length] AS [Length],
|
[v_empty_location].[Width] AS [Width],
|
[v_empty_location].[Height] AS [Height],
|
[v_empty_location].[MaxWeight] AS [MaxWeight],
|
[v_empty_location].[HeightLevel] AS [HeightLevel],
|
[v_empty_location].[Priority] AS [Priority],
|
[v_empty_location].[CreatedTime] AS [CreatedTime],
|
[v_empty_location].[UpdatedTime] AS [UpdatedTime],
|
[v_empty_location].[CreatedUserId] AS [CreatedUserId],
|
[v_empty_location].[CreatedUserName] AS [CreatedUserName],
|
[v_empty_location].[UpdatedUserId] AS [UpdatedUserId],
|
[v_empty_location].[UpdatedUserName] AS [UpdatedUserName],
|
[v_empty_location].[IsDeleted] AS [IsDeleted],
|
[v_empty_location].[WareLocationTypeCode] AS [WareLocationTypeCode],
|
[v_empty_location].[UnionCode] AS [UnionCode]
|
FROM [dbo].[v_empty_location] AS [v_empty_location]</DefiningQuery>
|
</EntitySet>
|
<EntitySet Name="v_ware_inventory_by_container" EntityType="TEST.Store.v_ware_inventory_by_container" store:Type="Views" store:Schema="dbo" store:Name="v_ware_inventory_by_container">
|
<DefiningQuery>SELECT
|
[v_ware_inventory_by_container].[Id] AS [Id],
|
[v_ware_inventory_by_container].[WareLocationCode] AS [WareLocationCode],
|
[v_ware_inventory_by_container].[LocTypeCode] AS [LocTypeCode],
|
[v_ware_inventory_by_container].[LocTypeName] AS [LocTypeName],
|
[v_ware_inventory_by_container].[Row] AS [Row],
|
[v_ware_inventory_by_container].[Lane] AS [Lane],
|
[v_ware_inventory_by_container].[WareContainerCode] AS [WareContainerCode],
|
[v_ware_inventory_by_container].[WareMaterialCode] AS [WareMaterialCode],
|
[v_ware_inventory_by_container].[WareMaterialName] AS [WareMaterialName],
|
[v_ware_inventory_by_container].[OrdersNo] AS [OrdersNo],
|
[v_ware_inventory_by_container].[OrderType] AS [OrderType],
|
[v_ware_inventory_by_container].[PurchaseNo] AS [PurchaseNo],
|
[v_ware_inventory_by_container].[DeliveryNo] AS [DeliveryNo],
|
[v_ware_inventory_by_container].[CollectNo] AS [CollectNo],
|
[v_ware_inventory_by_container].[Quantity] AS [Quantity],
|
[v_ware_inventory_by_container].[ItemBatchNo] AS [ItemBatchNo],
|
[v_ware_inventory_by_container].[Unit] AS [Unit],
|
[v_ware_inventory_by_container].[Remarks] AS [Remarks],
|
[v_ware_inventory_by_container].[IsLocked] AS [IsLocked],
|
[v_ware_inventory_by_container].[IsDeleted] AS [IsDeleted],
|
[v_ware_inventory_by_container].[UpdatedUserId] AS [UpdatedUserId],
|
[v_ware_inventory_by_container].[UpdatedUserName] AS [UpdatedUserName],
|
[v_ware_inventory_by_container].[UpdatedTime] AS [UpdatedTime],
|
[v_ware_inventory_by_container].[CreatedUserId] AS [CreatedUserId],
|
[v_ware_inventory_by_container].[CreatedUserName] AS [CreatedUserName],
|
[v_ware_inventory_by_container].[CreatedTime] AS [CreatedTime],
|
[v_ware_inventory_by_container].[BatchNo] AS [BatchNo],
|
[v_ware_inventory_by_container].[ContainerType] AS [ContainerType],
|
[v_ware_inventory_by_container].[StockStatus] AS [StockStatus],
|
[v_ware_inventory_by_container].[IsEmptyContainer] AS [IsEmptyContainer],
|
[v_ware_inventory_by_container].[DeepcellNo] AS [DeepcellNo],
|
[v_ware_inventory_by_container].[UnionCode] AS [UnionCode],
|
[v_ware_inventory_by_container].[PartCode] AS [PartCode],
|
[v_ware_inventory_by_container].[PartName] AS [PartName],
|
[v_ware_inventory_by_container].[RealLocationCode] AS [RealLocationCode],
|
[v_ware_inventory_by_container].[LineType] AS [LineType]
|
FROM [dbo].[v_ware_inventory_by_container] AS [v_ware_inventory_by_container]</DefiningQuery>
|
</EntitySet>
|
<AssociationSet Name="FK_sys_dict_data_sys_dict_type_TypeId" Association="TEST.Store.FK_sys_dict_data_sys_dict_type_TypeId">
|
<End Role="sys_dict_type" EntitySet="sys_dict_type" />
|
<End Role="sys_dict_data" EntitySet="sys_dict_data" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_emp_ext_org_pos_sys_emp_SysEmpId" Association="TEST.Store.FK_sys_emp_ext_org_pos_sys_emp_SysEmpId">
|
<End Role="sys_emp" EntitySet="sys_emp" />
|
<End Role="sys_emp_ext_org_pos" EntitySet="sys_emp_ext_org_pos" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_emp_ext_org_pos_sys_org_SysOrgId" Association="TEST.Store.FK_sys_emp_ext_org_pos_sys_org_SysOrgId">
|
<End Role="sys_org" EntitySet="sys_org" />
|
<End Role="sys_emp_ext_org_pos" EntitySet="sys_emp_ext_org_pos" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_emp_ext_org_pos_sys_pos_SysPosId" Association="TEST.Store.FK_sys_emp_ext_org_pos_sys_pos_SysPosId">
|
<End Role="sys_pos" EntitySet="sys_pos" />
|
<End Role="sys_emp_ext_org_pos" EntitySet="sys_emp_ext_org_pos" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_emp_pos_sys_emp_SysEmpId" Association="TEST.Store.FK_sys_emp_pos_sys_emp_SysEmpId">
|
<End Role="sys_emp" EntitySet="sys_emp" />
|
<End Role="sys_emp_pos" EntitySet="sys_emp_pos" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_emp_pos_sys_pos_SysPosId" Association="TEST.Store.FK_sys_emp_pos_sys_pos_SysPosId">
|
<End Role="sys_pos" EntitySet="sys_pos" />
|
<End Role="sys_emp_pos" EntitySet="sys_emp_pos" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_low_code_module_database_sys_low_code_module_SysLowCodeId" Association="TEST.Store.FK_sys_low_code_module_database_sys_low_code_module_SysLowCodeId">
|
<End Role="sys_low_code_module" EntitySet="sys_low_code_module" />
|
<End Role="sys_low_code_module_database" EntitySet="sys_low_code_module_database" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_role_data_scope_sys_org_SysOrgId" Association="TEST.Store.FK_sys_role_data_scope_sys_org_SysOrgId">
|
<End Role="sys_org" EntitySet="sys_org" />
|
<End Role="sys_role_data_scope" EntitySet="sys_role_data_scope" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_role_data_scope_sys_role_SysRoleId" Association="TEST.Store.FK_sys_role_data_scope_sys_role_SysRoleId">
|
<End Role="sys_role" EntitySet="sys_role" />
|
<End Role="sys_role_data_scope" EntitySet="sys_role_data_scope" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_role_menu_sys_menu_SysMenuId" Association="TEST.Store.FK_sys_role_menu_sys_menu_SysMenuId">
|
<End Role="sys_menu" EntitySet="sys_menu" />
|
<End Role="sys_role_menu" EntitySet="sys_role_menu" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_role_menu_sys_role_SysRoleId" Association="TEST.Store.FK_sys_role_menu_sys_role_SysRoleId">
|
<End Role="sys_role" EntitySet="sys_role" />
|
<End Role="sys_role_menu" EntitySet="sys_role_menu" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_user_data_scope_sys_org_SysOrgId" Association="TEST.Store.FK_sys_user_data_scope_sys_org_SysOrgId">
|
<End Role="sys_org" EntitySet="sys_org" />
|
<End Role="sys_user_data_scope" EntitySet="sys_user_data_scope" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_user_data_scope_sys_user_SysUserId" Association="TEST.Store.FK_sys_user_data_scope_sys_user_SysUserId">
|
<End Role="sys_user" EntitySet="sys_user" />
|
<End Role="sys_user_data_scope" EntitySet="sys_user_data_scope" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_user_role_sys_role_SysRoleId" Association="TEST.Store.FK_sys_user_role_sys_role_SysRoleId">
|
<End Role="sys_role" EntitySet="sys_role" />
|
<End Role="sys_user_role" EntitySet="sys_user_role" />
|
</AssociationSet>
|
<AssociationSet Name="FK_sys_user_role_sys_user_SysUserId" Association="TEST.Store.FK_sys_user_role_sys_user_SysUserId">
|
<End Role="sys_user" EntitySet="sys_user" />
|
<End Role="sys_user_role" EntitySet="sys_user_role" />
|
</AssociationSet>
|
<AssociationSet Name="FK_wms_materialcontainer_wms_container_ContainerId" Association="TEST.Store.FK_wms_materialcontainer_wms_container_ContainerId">
|
<End Role="wms_container" EntitySet="wms_container" />
|
<End Role="wms_materialcontainer" EntitySet="wms_materialcontainer" />
|
</AssociationSet>
|
<AssociationSet Name="FK_wms_materialcontainer_wms_material_MaterialId" Association="TEST.Store.FK_wms_materialcontainer_wms_material_MaterialId">
|
<End Role="wms_material" EntitySet="wms_material" />
|
<End Role="wms_materialcontainer" EntitySet="wms_materialcontainer" />
|
</AssociationSet>
|
<AssociationSet Name="FK_wms_place_wms_area_AreaId" Association="TEST.Store.FK_wms_place_wms_area_AreaId">
|
<End Role="wms_area" EntitySet="wms_area" />
|
<End Role="wms_place" EntitySet="wms_place" />
|
</AssociationSet>
|
</EntityContainer>
|
<EntityType Name="__EFMigrationsHistory">
|
<Key>
|
<PropertyRef Name="MigrationId" />
|
</Key>
|
<Property Name="MigrationId" Type="nvarchar" Nullable="false" MaxLength="150" />
|
<Property Name="ProductVersion" Type="nvarchar" Nullable="false" MaxLength="32" />
|
</EntityType>
|
<EntityType Name="Base_SysExceptionInfo">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="varchar" Nullable="false" MaxLength="255" />
|
<Property Name="module" Type="varchar" MaxLength="500" />
|
<Property Name="exceptionLevel" Type="varchar" MaxLength="500" />
|
<Property Name="exceptionSource" Type="varchar(max)" />
|
<Property Name="exceptionFun" Type="varchar(max)" />
|
<Property Name="sourceData" Type="varchar(max)" />
|
<Property Name="exceptionMsg" Type="varchar(max)" />
|
<Property Name="exceptionData" Type="varchar(max)" />
|
<Property Name="host" Type="varchar" MaxLength="500" />
|
<Property Name="key1" Type="varchar" MaxLength="500" />
|
<Property Name="key2" Type="varchar" MaxLength="500" />
|
<Property Name="key3" Type="varchar" MaxLength="500" />
|
<Property Name="creator" Type="varchar" MaxLength="500" />
|
<Property Name="createTime" Type="datetime" />
|
</EntityType>
|
<EntityType Name="sys_app">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="20" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Active" Type="nvarchar" MaxLength="5" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_code_gen">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="AuthorName" Type="nvarchar" MaxLength="20" />
|
<Property Name="TablePrefix" Type="nvarchar" MaxLength="5" />
|
<Property Name="GenerateType" Type="nvarchar" MaxLength="20" />
|
<Property Name="DatabaseName" Type="nvarchar" MaxLength="100" />
|
<Property Name="TableName" Type="nvarchar" MaxLength="100" />
|
<Property Name="NameSpace" Type="nvarchar" MaxLength="100" />
|
<Property Name="BusName" Type="nvarchar" MaxLength="100" />
|
<Property Name="MenuApplication" Type="nvarchar" MaxLength="50" />
|
<Property Name="MenuPid" Type="bigint" Nullable="false" />
|
<Property Name="LowCodeId" Type="bigint" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_code_gen_config">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="CodeGenId" Type="bigint" Nullable="false" />
|
<Property Name="ColumnName" Type="nvarchar" Nullable="false" MaxLength="100" />
|
<Property Name="ColumnComment" Type="nvarchar" MaxLength="100" />
|
<Property Name="NetType" Type="nvarchar" MaxLength="50" />
|
<Property Name="DtoNetType" Type="nvarchar" MaxLength="50" />
|
<Property Name="EffectType" Type="nvarchar" MaxLength="50" />
|
<Property Name="FkEntityName" Type="nvarchar" MaxLength="50" />
|
<Property Name="FkColumnName" Type="nvarchar" MaxLength="50" />
|
<Property Name="FkColumnNetType" Type="nvarchar" MaxLength="50" />
|
<Property Name="DictTypeCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WhetherRetract" Type="nvarchar" MaxLength="5" />
|
<Property Name="WhetherRequired" Type="nvarchar" MaxLength="5" />
|
<Property Name="QueryWhether" Type="nvarchar" MaxLength="5" />
|
<Property Name="QueryType" Type="nvarchar" MaxLength="10" />
|
<Property Name="WhetherTable" Type="nvarchar" MaxLength="5" />
|
<Property Name="WhetherOrderBy" Type="nvarchar" MaxLength="5" />
|
<Property Name="WhetherAddUpdate" Type="nvarchar" MaxLength="5" />
|
<Property Name="ColumnKey" Type="nvarchar" MaxLength="5" />
|
<Property Name="DataType" Type="nvarchar" MaxLength="128" />
|
<Property Name="WhetherCommon" Type="nvarchar" MaxLength="5" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_code_modular">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="AuthorName" Type="nvarchar" MaxLength="20" />
|
<Property Name="DatabaseName" Type="nvarchar" MaxLength="100" />
|
<Property Name="NameSpace" Type="nvarchar" MaxLength="100" />
|
<Property Name="BusName" Type="nvarchar" MaxLength="100" />
|
<Property Name="MenuApplication" Type="nvarchar" MaxLength="50" />
|
<Property Name="MenuPid" Type="bigint" Nullable="false" />
|
<Property Name="FormDesignJson" Type="nvarchar(max)" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_config">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Value" Type="nvarchar(max)" />
|
<Property Name="SysFlag" Type="nvarchar" MaxLength="5" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="GroupCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_dict_data">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="TypeId" Type="bigint" Nullable="false" />
|
<Property Name="Value" Type="nvarchar" MaxLength="100" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_dict_type">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_emp">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="JobNum" Type="nvarchar" MaxLength="30" />
|
<Property Name="OrgId" Type="bigint" Nullable="false" />
|
<Property Name="OrgName" Type="nvarchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="sys_emp_ext_org_pos">
|
<Key>
|
<PropertyRef Name="SysEmpId" />
|
<PropertyRef Name="SysOrgId" />
|
<PropertyRef Name="SysPosId" />
|
</Key>
|
<Property Name="SysEmpId" Type="bigint" Nullable="false" />
|
<Property Name="SysOrgId" Type="bigint" Nullable="false" />
|
<Property Name="SysPosId" Type="bigint" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_emp_pos">
|
<Key>
|
<PropertyRef Name="SysEmpId" />
|
<PropertyRef Name="SysPosId" />
|
</Key>
|
<Property Name="SysEmpId" Type="bigint" Nullable="false" />
|
<Property Name="SysPosId" Type="bigint" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_file">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="FileLocation" Type="int" Nullable="false" />
|
<Property Name="FileBucket" Type="nvarchar" MaxLength="100" />
|
<Property Name="FileOriginName" Type="nvarchar" MaxLength="100" />
|
<Property Name="FileSuffix" Type="nvarchar" MaxLength="50" />
|
<Property Name="FileSizeKb" Type="nvarchar" MaxLength="10" />
|
<Property Name="FileSizeInfo" Type="nvarchar" MaxLength="50" />
|
<Property Name="FileObjectName" Type="nvarchar" MaxLength="100" />
|
<Property Name="FilePath" Type="nvarchar" MaxLength="100" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_forms">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Title" Type="nvarchar(max)" Nullable="false" />
|
<Property Name="FormJson" Type="nvarchar(max)" Nullable="false" />
|
<Property Name="Publish" Type="bit" Nullable="false" />
|
<Property Name="TypeId" Type="bigint" Nullable="false" />
|
<Property Name="Version" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_log_audit">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
|
<Property Name="TableName" Type="nvarchar" MaxLength="50" />
|
<Property Name="ColumnName" Type="nvarchar" MaxLength="50" />
|
<Property Name="NewValue" Type="nvarchar(max)" />
|
<Property Name="OldValue" Type="nvarchar(max)" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UserId" Type="bigint" Nullable="false" />
|
<Property Name="UserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="Operate" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_log_ex">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
|
<Property Name="Account" Type="nvarchar" MaxLength="50" />
|
<Property Name="Name" Type="nvarchar" MaxLength="100" />
|
<Property Name="ClassName" Type="nvarchar" MaxLength="100" />
|
<Property Name="MethodName" Type="nvarchar" MaxLength="100" />
|
<Property Name="ExceptionName" Type="nvarchar(max)" />
|
<Property Name="ExceptionMsg" Type="nvarchar(max)" />
|
<Property Name="ExceptionSource" Type="nvarchar(max)" />
|
<Property Name="StackTrace" Type="nvarchar(max)" />
|
<Property Name="ParamsObj" Type="nvarchar(max)" />
|
<Property Name="ExceptionTime" Type="datetimeoffset" />
|
</EntityType>
|
<EntityType Name="sys_log_op">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
|
<Property Name="Name" Type="nvarchar" MaxLength="100" />
|
<Property Name="Success" Type="int" Nullable="false" />
|
<Property Name="Message" Type="nvarchar(max)" />
|
<Property Name="Ip" Type="nvarchar" MaxLength="20" />
|
<Property Name="Location" Type="nvarchar" MaxLength="1024" />
|
<Property Name="Browser" Type="nvarchar" MaxLength="100" />
|
<Property Name="Os" Type="nvarchar" MaxLength="100" />
|
<Property Name="Url" Type="nvarchar" MaxLength="100" />
|
<Property Name="ClassName" Type="nvarchar" MaxLength="100" />
|
<Property Name="MethodName" Type="nvarchar" MaxLength="100" />
|
<Property Name="ReqMethod" Type="nvarchar" MaxLength="10" />
|
<Property Name="Param" Type="nvarchar(max)" />
|
<Property Name="Result" Type="nvarchar(max)" />
|
<Property Name="ElapsedTime" Type="bigint" Nullable="false" />
|
<Property Name="OpTime" Type="datetimeoffset" />
|
<Property Name="Account" Type="nvarchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="sys_log_vis">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
|
<Property Name="Name" Type="nvarchar" MaxLength="100" />
|
<Property Name="Success" Type="int" Nullable="false" />
|
<Property Name="Message" Type="nvarchar(max)" />
|
<Property Name="Ip" Type="nvarchar" MaxLength="20" />
|
<Property Name="Location" Type="nvarchar" MaxLength="1024" />
|
<Property Name="Browser" Type="nvarchar" MaxLength="100" />
|
<Property Name="Os" Type="nvarchar" MaxLength="100" />
|
<Property Name="VisType" Type="int" Nullable="false" />
|
<Property Name="VisTime" Type="datetimeoffset" />
|
<Property Name="Account" Type="nvarchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="sys_low_code_module">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="AuthorName" Type="nvarchar" MaxLength="20" />
|
<Property Name="GenerateType" Type="nvarchar" MaxLength="20" />
|
<Property Name="DatabaseName" Type="nvarchar" MaxLength="100" />
|
<Property Name="NameSpace" Type="nvarchar" MaxLength="100" />
|
<Property Name="BusName" Type="nvarchar" MaxLength="100" />
|
<Property Name="MenuApplication" Type="nvarchar" MaxLength="50" />
|
<Property Name="MenuPid" Type="bigint" Nullable="false" />
|
<Property Name="FormDesignType" Type="int" Nullable="false" />
|
<Property Name="FormDesign" Type="text" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_low_code_module_database">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="uniqueidentifier" Nullable="false" />
|
<Property Name="SysLowCodeId" Type="bigint" Nullable="false" />
|
<Property Name="Control_Key" Type="nvarchar" MaxLength="200" />
|
<Property Name="Control_Label" Type="nvarchar" MaxLength="200" />
|
<Property Name="Control_Model" Type="nvarchar" MaxLength="200" />
|
<Property Name="Control_Type" Type="nvarchar" MaxLength="200" />
|
<Property Name="TableName" Type="nvarchar" MaxLength="200" />
|
<Property Name="ClassName" Type="nvarchar" MaxLength="200" />
|
<Property Name="TableDesc" Type="nvarchar" MaxLength="200" />
|
<Property Name="FieldName" Type="nvarchar" MaxLength="200" />
|
<Property Name="DbTypeName" Type="nvarchar" MaxLength="200" />
|
<Property Name="DtoTypeName" Type="nvarchar" MaxLength="200" />
|
<Property Name="DbParam" Type="nvarchar" MaxLength="200" />
|
<Property Name="IsRequired" Type="bit" />
|
<Property Name="WhetherTable" Type="bit" />
|
<Property Name="WhetherOrderBy" Type="bit" />
|
<Property Name="WhetherAddUpdate" Type="bit" />
|
<Property Name="QueryWhether" Type="bit" />
|
<Property Name="QueryType" Type="nvarchar(max)" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_menu">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Pid" Type="bigint" Nullable="false" />
|
<Property Name="Pids" Type="nvarchar(max)" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="20" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Type" Type="int" Nullable="false" />
|
<Property Name="Icon" Type="nvarchar" MaxLength="20" />
|
<Property Name="Router" Type="nvarchar" MaxLength="100" />
|
<Property Name="Component" Type="nvarchar" MaxLength="100" />
|
<Property Name="Permission" Type="nvarchar" MaxLength="100" />
|
<Property Name="Application" Type="nvarchar" MaxLength="50" />
|
<Property Name="OpenType" Type="int" Nullable="false" />
|
<Property Name="Visible" Type="nvarchar" MaxLength="5" />
|
<Property Name="Link" Type="nvarchar" MaxLength="100" />
|
<Property Name="Redirect" Type="nvarchar" MaxLength="100" />
|
<Property Name="Weight" Type="int" Nullable="false" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_notice">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Title" Type="nvarchar" Nullable="false" MaxLength="20" />
|
<Property Name="Content" Type="nvarchar(max)" Nullable="false" />
|
<Property Name="Type" Type="int" Nullable="false" />
|
<Property Name="PublicUserId" Type="bigint" Nullable="false" />
|
<Property Name="PublicUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="PublicOrgId" Type="bigint" Nullable="false" />
|
<Property Name="PublicOrgName" Type="nvarchar" MaxLength="50" />
|
<Property Name="PublicTime" Type="datetimeoffset" />
|
<Property Name="CancelTime" Type="datetimeoffset" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_notice_user">
|
<Key>
|
<PropertyRef Name="NoticeId" />
|
<PropertyRef Name="UserId" />
|
</Key>
|
<Property Name="NoticeId" Type="bigint" Nullable="false" />
|
<Property Name="UserId" Type="bigint" Nullable="false" />
|
<Property Name="ReadTime" Type="datetimeoffset" />
|
<Property Name="ReadStatus" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_org">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Pid" Type="bigint" Nullable="false" />
|
<Property Name="Pids" Type="nvarchar(max)" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="100" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Contacts" Type="nvarchar" MaxLength="20" />
|
<Property Name="Tel" Type="nvarchar" MaxLength="20" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="OrgType" Type="nvarchar(max)" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_pos">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="20" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_role">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="20" />
|
<Property Name="Code" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Sort" Type="int" Nullable="false" />
|
<Property Name="DataScopeType" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="RoleType" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_role_data_scope">
|
<Key>
|
<PropertyRef Name="SysRoleId" />
|
<PropertyRef Name="SysOrgId" />
|
</Key>
|
<Property Name="SysRoleId" Type="bigint" Nullable="false" />
|
<Property Name="SysOrgId" Type="bigint" Nullable="false" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.sys_role_menu”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="sys_role_menu">
|
<Key>
|
<PropertyRef Name="SysRoleId" />
|
<PropertyRef Name="SysMenuId" />
|
</Key>
|
<Property Name="SysRoleId" Type="bigint" Nullable="false" />
|
<Property Name="SysMenuId" Type="bigint" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_timer">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="JobName" Type="nvarchar" Nullable="false" MaxLength="20" />
|
<Property Name="DoOnce" Type="bit" Nullable="false" />
|
<Property Name="StartNow" Type="bit" Nullable="false" />
|
<Property Name="ExecuteType" Type="int" Nullable="false" />
|
<Property Name="Interval" Type="int" />
|
<Property Name="Cron" Type="nvarchar" MaxLength="200" />
|
<Property Name="TimerType" Type="int" Nullable="false" />
|
<Property Name="RequestUrl" Type="nvarchar" MaxLength="200" />
|
<Property Name="RequestParameters" Type="nvarchar(max)" />
|
<Property Name="Headers" Type="nvarchar(max)" />
|
<Property Name="RequestType" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar" MaxLength="100" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_user">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Account" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Password" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="NickName" Type="nvarchar" MaxLength="20" />
|
<Property Name="Name" Type="nvarchar" MaxLength="20" />
|
<Property Name="Avatar" Type="nvarchar(max)" />
|
<Property Name="Birthday" Type="datetimeoffset" />
|
<Property Name="Sex" Type="int" Nullable="false" />
|
<Property Name="Email" Type="nvarchar" MaxLength="50" />
|
<Property Name="Phone" Type="nvarchar" MaxLength="20" />
|
<Property Name="Tel" Type="nvarchar" MaxLength="20" />
|
<Property Name="LastLoginIp" Type="nvarchar" MaxLength="20" />
|
<Property Name="LastLoginTime" Type="datetimeoffset" />
|
<Property Name="AdminType" Type="int" Nullable="false" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="LineType" Type="int" />
|
</EntityType>
|
<EntityType Name="sys_user_data_scope">
|
<Key>
|
<PropertyRef Name="SysUserId" />
|
<PropertyRef Name="SysOrgId" />
|
</Key>
|
<Property Name="SysUserId" Type="bigint" Nullable="false" />
|
<Property Name="SysOrgId" Type="bigint" Nullable="false" />
|
</EntityType>
|
<EntityType Name="sys_user_role">
|
<Key>
|
<PropertyRef Name="SysUserId" />
|
<PropertyRef Name="SysRoleId" />
|
</Key>
|
<Property Name="SysUserId" Type="bigint" Nullable="false" />
|
<Property Name="SysRoleId" Type="bigint" Nullable="false" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.ware_container_vs_material”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="ware_container_vs_material">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="WareContainerCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareMaterialCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="Quantity" Type="decimal" Precision="27" Scale="6" />
|
<Property Name="PurchaseNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="DeliveryNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="CollectNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="OrdersNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="IsLocked" Type="bit" />
|
<Property Name="IsDeleted" Type="bit" />
|
<Property Name="Remarks" Type="nvarchar" MaxLength="500" />
|
<Property Name="StockStatus" Type="int" />
|
<Property Name="Price" Type="decimal" Scale="2" />
|
<Property Name="BarNo" Type="nvarchar" MaxLength="100" />
|
<Property Name="OrderType" Type="nvarchar" MaxLength="5" />
|
<Property Name="Unit" Type="varchar" MaxLength="50" />
|
<Property Name="WareMaterialName" Type="varchar" MaxLength="500" />
|
</EntityType>
|
<EntityType Name="ware_device_wareing">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
|
<Property Name="WarningTime" Type="datetime2" Nullable="false" />
|
<Property Name="DeviceCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="DeviceName" Type="nvarchar" MaxLength="500" />
|
<Property Name="WarningCode" Type="nvarchar" MaxLength="255" />
|
<Property Name="WarningDbAddress" Type="nvarchar" MaxLength="255" />
|
<Property Name="WarningContent" Type="nvarchar" MaxLength="255" />
|
<Property Name="Status" Type="int" />
|
<Property Name="StatusName" Type="nvarchar" MaxLength="255" />
|
<Property Name="CloseContent" Type="nvarchar" MaxLength="255" />
|
<Property Name="FinishTime" Type="datetime2" />
|
<Property Name="DurationTime" Type="nvarchar" MaxLength="255" />
|
<Property Name="OperationRemark" Type="nvarchar" MaxLength="500" />
|
<Property Name="DeviceType" Type="int" />
|
<Property Name="DeviceTypeName" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.ware_flow_record”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="ware_flow_record">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="RecordType" Type="int" />
|
<Property Name="ReservoirArea" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareHousingNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="PurchaseNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="DeliveryNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="CollectNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="SourceWareLocationCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="ToWareLocationCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareContainerCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareContainerName" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareMaterialCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareMaterialName" Type="nvarchar" MaxLength="50" />
|
<Property Name="Quantity" Type="decimal" Scale="2" />
|
<Property Name="BarCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="BasicSupplierInfoCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WarehousingType" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareGoodsshelvesCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="Status" Type="int" />
|
<Property Name="TenantId" Type="bigint" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="IsDeleted" Type="bit" />
|
<Property Name="Remarks" Type="nvarchar" MaxLength="500" />
|
<Property Name="OutInFlag" Type="int" />
|
<Property Name="SpecificationModel" Type="varchar" MaxLength="500" />
|
<Property Name="U8Warehouse" Type="varchar" MaxLength="500" />
|
<Property Name="U8DepName" Type="varchar" MaxLength="500" />
|
<Property Name="cWhName" Type="varchar" MaxLength="500" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.ware_location_vs_container”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="ware_location_vs_container">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="WareStorehouseCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareRegionCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareLocationCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareContainerCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsEmptyContainer" Type="bit" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="IsDeleted" Type="bit" />
|
<Property Name="Remarks" Type="nvarchar" MaxLength="500" />
|
<Property Name="Row" Type="int" />
|
<Property Name="Lane" Type="int" />
|
<Property Name="LocTypeCode" Type="varchar" MaxLength="500" />
|
<Property Name="DeepcellNo" Type="int" />
|
<Property Name="UnionCode" Type="varchar" MaxLength="50" />
|
<Property Name="WareContainerName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.ware_site”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="ware_site">
|
<Key>
|
<PropertyRef Name="Id" />
|
<PropertyRef Name="Xcoordinate" />
|
<PropertyRef Name="Ycoordinate" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" />
|
<Property Name="Describe" Type="nvarchar" MaxLength="50" />
|
<Property Name="Xcoordinate" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Ycoordinate" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="TenantId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="IsDeleted" Type="bit" />
|
<Property Name="Name" Type="nvarchar" MaxLength="50" />
|
<Property Name="SiteType" Type="int" />
|
<Property Name="Lane" Type="int" />
|
<Property Name="OperationRemarks" Type="nvarchar" MaxLength="500" />
|
<Property Name="LineType" Type="int" />
|
</EntityType>
|
<EntityType Name="ware_task">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="OrderNo" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskNo" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskName" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskCategory" Type="int" />
|
<Property Name="TaskType" Type="int" />
|
<Property Name="TaskState" Type="int" />
|
<Property Name="TaskDescribe" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskPriority" Type="int" />
|
<Property Name="ContainerCode" Type="nvarchar" MaxLength="255" />
|
<Property Name="FromLocationCode" Type="nvarchar" MaxLength="255" />
|
<Property Name="ToLocationCode" Type="nvarchar" MaxLength="255" />
|
<Property Name="FinishedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="Lane" Type="int" />
|
<Property Name="MoveFlag" Type="int" />
|
<Property Name="MoveFromLocation" Type="nvarchar" MaxLength="255" />
|
<Property Name="MoveToLocation" Type="nvarchar" MaxLength="255" />
|
<Property Name="MoveContainerCode" Type="nvarchar" MaxLength="255" />
|
<Property Name="ContainerType" Type="int" />
|
<Property Name="OperationRemark" Type="varchar" MaxLength="500" />
|
</EntityType>
|
<EntityType Name="ware_task_bak">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="OrderNo" Type="nvarchar(max)" />
|
<Property Name="TaskNo" Type="nvarchar(max)" />
|
<Property Name="TaskName" Type="nvarchar(max)" />
|
<Property Name="TaskCategory" Type="int" Nullable="false" />
|
<Property Name="TaskType" Type="int" Nullable="false" />
|
<Property Name="TaskState" Type="int" Nullable="false" />
|
<Property Name="TaskDescribe" Type="nvarchar(max)" />
|
<Property Name="TaskPriority" Type="int" Nullable="false" />
|
<Property Name="ContainerCode" Type="nvarchar(max)" />
|
<Property Name="FromLocationCode" Type="nvarchar(max)" />
|
<Property Name="ToLocationCode" Type="nvarchar(max)" />
|
<Property Name="FinishedTime" Type="datetimeoffset" />
|
<Property Name="Lane" Type="int" />
|
<Property Name="MoveFlag" Type="int" />
|
<Property Name="MoveFromLocation" Type="nvarchar(max)" />
|
<Property Name="MoveToLocation" Type="nvarchar(max)" />
|
<Property Name="MoveContainerCode" Type="nvarchar(max)" />
|
<Property Name="ContainerType" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="OperationRemark" Type="varchar" MaxLength="500" />
|
</EntityType>
|
<EntityType Name="ware_task_sub">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
|
<Property Name="OrderNo" Type="nvarchar" MaxLength="255" />
|
<Property Name="WCSTaskId" Type="int" />
|
<Property Name="TaskId" Type="bigint" />
|
<Property Name="TaskNo" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskSequence" Type="int" />
|
<Property Name="TaskDescribe" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskState" Type="int" />
|
<Property Name="DeviceType" Type="nvarchar" MaxLength="255" />
|
<Property Name="DeviceId" Type="int" />
|
<Property Name="ContainerCode" Type="nvarchar" MaxLength="255" />
|
<Property Name="TaskType" Type="int" />
|
<Property Name="SourcePlace" Type="varchar" MaxLength="50" />
|
<Property Name="FromLane" Type="int" />
|
<Property Name="FromLayer" Type="int" />
|
<Property Name="FromRow" Type="int" />
|
<Property Name="FromCol" Type="int" />
|
<Property Name="ToPlace" Type="varchar" MaxLength="50" />
|
<Property Name="ToLane" Type="int" />
|
<Property Name="ToLayer" Type="int" />
|
<Property Name="ToCol" Type="int" />
|
<Property Name="ToRow" Type="int" />
|
<Property Name="FinishedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="OperationRemark" Type="nvarchar" MaxLength="255" />
|
<Property Name="ContainerType" Type="int" />
|
<Property Name="AgvTaskCode" Type="varchar" MaxLength="64" />
|
<Property Name="AgvCode" Type="varchar" MaxLength="5" />
|
</EntityType>
|
<EntityType Name="ware_task_sub_bak">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="OrderNo" Type="nvarchar(max)" />
|
<Property Name="TaskId" Type="bigint" Nullable="false" />
|
<Property Name="TaskNo" Type="nvarchar(max)" />
|
<Property Name="TaskSequence" Type="int" Nullable="false" />
|
<Property Name="TaskState" Type="int" Nullable="false" />
|
<Property Name="TaskDescribe" Type="nvarchar(max)" />
|
<Property Name="DeviceType" Type="nvarchar(max)" />
|
<Property Name="DeviceId" Type="int" Nullable="false" />
|
<Property Name="ContainerCode" Type="nvarchar(max)" />
|
<Property Name="FromLane" Type="int" />
|
<Property Name="FromLayer" Type="int" />
|
<Property Name="FromCol" Type="int" />
|
<Property Name="FromRow" Type="int" />
|
<Property Name="ToLane" Type="int" />
|
<Property Name="ToLayer" Type="int" />
|
<Property Name="ToCol" Type="int" />
|
<Property Name="ToRow" Type="int" />
|
<Property Name="FinishedTime" Type="datetimeoffset" />
|
<Property Name="ContainerType" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="SourcePlace" Type="varchar" MaxLength="50" />
|
<Property Name="ToPlace" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="wms_area">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="AreaName" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="AreaDesc" Type="nvarchar" MaxLength="250" />
|
<Property Name="AreaStatus" Type="int" Nullable="false" />
|
<Property Name="AreaType" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="wms_container">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="ContainerCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="ContainerType" Type="int" />
|
<Property Name="ContainerStatus" Type="int" />
|
<Property Name="SpecLength" Type="decimal" Scale="2" />
|
<Property Name="SpecWidth" Type="decimal" Scale="2" />
|
<Property Name="SpecHeight" Type="decimal" Scale="2" />
|
<Property Name="LimitLength" Type="decimal" Scale="2" />
|
<Property Name="LimitWidth" Type="decimal" Scale="2" />
|
<Property Name="LimitHeight" Type="decimal" Scale="2" />
|
<Property Name="MaxWeight" Type="decimal" Scale="2" />
|
<Property Name="ParentContainerId" Type="bigint" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="ContainerTypeCode" Type="varchar" MaxLength="50" />
|
<Property Name="RealLocationCode" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="wms_container_type">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="WareContainerTypeCode" Type="nvarchar(max)" />
|
<Property Name="WareContainerTypeName" Type="nvarchar(max)" />
|
<Property Name="Length" Type="decimal" Scale="2" />
|
<Property Name="Height" Type="decimal" Scale="2" />
|
<Property Name="Width" Type="decimal" Scale="2" />
|
<Property Name="LocationType" Type="nvarchar(max)" />
|
<Property Name="Remarks" Type="nvarchar(max)" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="PLCTypeId" Type="int" />
|
</EntityType>
|
<EntityType Name="wms_location_type">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="WareLocationTypeCode" Type="nvarchar(max)" />
|
<Property Name="WareLocationTypeName" Type="nvarchar(max)" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
<Property Name="Length" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Width" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Height" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="MaxWeight" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="wms_material">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="MaterialName" Type="nvarchar" MaxLength="50" />
|
<Property Name="MaterialNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="MaterialBatch" Type="nvarchar" MaxLength="50" />
|
<Property Name="Description" Type="nvarchar" MaxLength="500" />
|
<Property Name="InspectionMethod" Type="int" />
|
<Property Name="MaterialType" Type="int" />
|
<Property Name="MaterialSpec" Type="nvarchar" MaxLength="50" />
|
<Property Name="UnitType" Type="int" />
|
<Property Name="UnitNo" Type="int" />
|
<Property Name="Safeqty" Type="decimal" Scale="2" />
|
<Property Name="Keymaterials" Type="int" />
|
<Property Name="ErpNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="GraphNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="Qccategory" Type="nvarchar" MaxLength="50" />
|
<Property Name="Warranty" Type="decimal" Scale="2" />
|
<Property Name="MaxImumqty" Type="decimal" Scale="2" />
|
<Property Name="MinstorageAge" Type="decimal" Scale="2" />
|
<Property Name="MaxstorageAge" Type="decimal" Scale="2" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="Height" Type="decimal" Scale="2" />
|
<Property Name="Length" Type="decimal" Scale="2" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
<Property Name="Width" Type="decimal" Scale="2" />
|
<Property Name="WareContainerTypeCode" Type="nvarchar(max)" />
|
<Property Name="CarType" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="wms_materialcontainer">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="ContainerId" Type="bigint" Nullable="false" />
|
<Property Name="ContainerCode" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialName" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialNo" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialBatch" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialSpec" Type="nvarchar" MaxLength="50" />
|
<Property Name="MaterialId" Type="bigint" Nullable="false" />
|
<Property Name="BindQuantity" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="BindStatus" Type="int" Nullable="false" />
|
<Property Name="SampleQty" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="OrderNo" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="wms_materialstock">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="MaterialNo" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialType" Type="int" Nullable="false" />
|
<Property Name="MaterialBatch" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialName" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="MaterialSpec" Type="nvarchar" MaxLength="50" />
|
<Property Name="InspectionMethod" Type="int" Nullable="false" />
|
<Property Name="UnitType" Type="int" Nullable="false" />
|
<Property Name="UnitNo" Type="int" Nullable="false" />
|
<Property Name="StockNumber" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="PlaceCode" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="ContainerCode" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="AreaId" Type="bigint" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="wms_part">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="PartCode" Type="nvarchar(max)" />
|
<Property Name="PartName" Type="nvarchar(max)" />
|
<Property Name="MaterialCode" Type="nvarchar(max)" />
|
<Property Name="Length" Type="decimal" Scale="2" />
|
<Property Name="Width" Type="decimal" Scale="2" />
|
<Property Name="Height" Type="decimal" Scale="2" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="LineType" Type="int" />
|
<Property Name="CarType" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="wms_place">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="PlaceCode" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="PlaceStatus" Type="int" Nullable="false" />
|
<Property Name="AreaId" Type="bigint" Nullable="false" />
|
<Property Name="RowNo" Type="int" Nullable="false" />
|
<Property Name="ColumnNo" Type="int" Nullable="false" />
|
<Property Name="LayerNo" Type="int" Nullable="false" />
|
<Property Name="DeepcellNo" Type="int" Nullable="false" />
|
<Property Name="Aisle" Type="int" Nullable="false" />
|
<Property Name="Line" Type="int" Nullable="false" />
|
<Property Name="Islock" Type="int" Nullable="false" />
|
<Property Name="EmptyContainer" Type="int" Nullable="false" />
|
<Property Name="PositionnoForSrm" Type="nvarchar" MaxLength="50" />
|
<Property Name="Xzb" Type="nvarchar" MaxLength="50" />
|
<Property Name="Yzb" Type="nvarchar" MaxLength="50" />
|
<Property Name="Zzb" Type="nvarchar" MaxLength="50" />
|
<Property Name="Length" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Width" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Height" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="MaxWeight" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="HeightLevel" Type="int" Nullable="false" />
|
<Property Name="Priority" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="WareLocationTypeCode" Type="nvarchar(max)" />
|
<Property Name="UnionCode" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="wms_task">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="TaskNo" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="TaskModel" Type="int" Nullable="false" />
|
<Property Name="TaskType" Type="int" Nullable="false" />
|
<Property Name="TaskLevel" Type="int" Nullable="false" />
|
<Property Name="TaskStatus" Type="int" Nullable="false" />
|
<Property Name="ContainerCode" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="SourcePlace" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="ToPlace" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="Aisle" Type="int" Nullable="false" />
|
<Property Name="AreaName" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="OrderNo" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="SendTimes" Type="int" Nullable="false" />
|
<Property Name="DodeviceId" Type="int" Nullable="false" />
|
<Property Name="DodevicenodeId" Type="nvarchar" MaxLength="50" />
|
<Property Name="Dodevicetype" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.v_empty_location”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="v_empty_location">
|
<Key>
|
<PropertyRef Name="Id" />
|
<PropertyRef Name="PlaceCode" />
|
<PropertyRef Name="PlaceStatus" />
|
<PropertyRef Name="AreaId" />
|
<PropertyRef Name="RowNo" />
|
<PropertyRef Name="ColumnNo" />
|
<PropertyRef Name="LayerNo" />
|
<PropertyRef Name="DeepcellNo" />
|
<PropertyRef Name="Aisle" />
|
<PropertyRef Name="Line" />
|
<PropertyRef Name="Islock" />
|
<PropertyRef Name="EmptyContainer" />
|
<PropertyRef Name="Length" />
|
<PropertyRef Name="Width" />
|
<PropertyRef Name="Height" />
|
<PropertyRef Name="MaxWeight" />
|
<PropertyRef Name="HeightLevel" />
|
<PropertyRef Name="Priority" />
|
<PropertyRef Name="IsDeleted" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="PlaceCode" Type="nvarchar" Nullable="false" MaxLength="50" />
|
<Property Name="PlaceStatus" Type="int" Nullable="false" />
|
<Property Name="AreaId" Type="bigint" Nullable="false" />
|
<Property Name="RowNo" Type="int" Nullable="false" />
|
<Property Name="ColumnNo" Type="int" Nullable="false" />
|
<Property Name="LayerNo" Type="int" Nullable="false" />
|
<Property Name="DeepcellNo" Type="int" Nullable="false" />
|
<Property Name="Aisle" Type="int" Nullable="false" />
|
<Property Name="Line" Type="int" Nullable="false" />
|
<Property Name="Islock" Type="int" Nullable="false" />
|
<Property Name="EmptyContainer" Type="int" Nullable="false" />
|
<Property Name="PositionnoForSrm" Type="nvarchar" MaxLength="50" />
|
<Property Name="Xzb" Type="nvarchar" MaxLength="50" />
|
<Property Name="Yzb" Type="nvarchar" MaxLength="50" />
|
<Property Name="Zzb" Type="nvarchar" MaxLength="50" />
|
<Property Name="Length" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Width" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="Height" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="MaxWeight" Type="decimal" Nullable="false" Scale="2" />
|
<Property Name="HeightLevel" Type="int" Nullable="false" />
|
<Property Name="Priority" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="IsDeleted" Type="bit" Nullable="false" />
|
<Property Name="WareLocationTypeCode" Type="nvarchar(max)" />
|
<Property Name="UnionCode" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<!--生成过程中发现错误:
|
警告 6002: 表/视图“LA22A07_QY.dbo.v_ware_inventory_by_container”未定义主键。已推断出该键，并将定义创建为只读的表/视图。
|
-->
|
<EntityType Name="v_ware_inventory_by_container">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="WareLocationCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="LocTypeCode" Type="varchar" MaxLength="500" />
|
<Property Name="LocTypeName" Type="nvarchar(max)" />
|
<Property Name="Row" Type="int" />
|
<Property Name="Lane" Type="int" />
|
<Property Name="WareContainerCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareMaterialCode" Type="nvarchar" MaxLength="50" />
|
<Property Name="WareMaterialName" Type="varchar" MaxLength="500" />
|
<Property Name="OrdersNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="OrderType" Type="nvarchar" MaxLength="5" />
|
<Property Name="PurchaseNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="DeliveryNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="CollectNo" Type="nvarchar" MaxLength="50" />
|
<Property Name="Quantity" Type="decimal" Precision="27" Scale="6" />
|
<Property Name="ItemBatchNo" Type="nvarchar" MaxLength="100" />
|
<Property Name="Unit" Type="varchar" MaxLength="50" />
|
<Property Name="Remarks" Type="nvarchar" MaxLength="500" />
|
<Property Name="IsLocked" Type="bit" />
|
<Property Name="IsDeleted" Type="bit" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="20" />
|
<Property Name="CreatedTime" Type="datetimeoffset" />
|
<Property Name="BatchNo" Type="nvarchar" MaxLength="100" />
|
<Property Name="ContainerType" Type="nvarchar(max)" />
|
<Property Name="StockStatus" Type="int" />
|
<Property Name="IsEmptyContainer" Type="bit" />
|
<Property Name="DeepcellNo" Type="int" />
|
<Property Name="UnionCode" Type="varchar" MaxLength="50" />
|
<Property Name="PartCode" Type="nvarchar(max)" />
|
<Property Name="PartName" Type="nvarchar(max)" />
|
<Property Name="RealLocationCode" Type="varchar" MaxLength="50" />
|
<Property Name="LineType" Type="int" />
|
</EntityType>
|
<Association Name="FK_sys_dict_data_sys_dict_type_TypeId">
|
<End Role="sys_dict_type" Type="TEST.Store.sys_dict_type" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_dict_data" Type="TEST.Store.sys_dict_data" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_dict_type">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_dict_data">
|
<PropertyRef Name="TypeId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_emp_ext_org_pos_sys_emp_SysEmpId">
|
<End Role="sys_emp" Type="TEST.Store.sys_emp" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="TEST.Store.sys_emp_ext_org_pos" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_emp">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_emp_ext_org_pos">
|
<PropertyRef Name="SysEmpId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_emp_ext_org_pos_sys_org_SysOrgId">
|
<End Role="sys_org" Type="TEST.Store.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="TEST.Store.sys_emp_ext_org_pos" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_org">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_emp_ext_org_pos">
|
<PropertyRef Name="SysOrgId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_emp_ext_org_pos_sys_pos_SysPosId">
|
<End Role="sys_pos" Type="TEST.Store.sys_pos" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="TEST.Store.sys_emp_ext_org_pos" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_pos">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_emp_ext_org_pos">
|
<PropertyRef Name="SysPosId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_emp_pos_sys_emp_SysEmpId">
|
<End Role="sys_emp" Type="TEST.Store.sys_emp" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_pos" Type="TEST.Store.sys_emp_pos" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_emp">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_emp_pos">
|
<PropertyRef Name="SysEmpId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_emp_pos_sys_pos_SysPosId">
|
<End Role="sys_pos" Type="TEST.Store.sys_pos" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_pos" Type="TEST.Store.sys_emp_pos" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_pos">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_emp_pos">
|
<PropertyRef Name="SysPosId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_low_code_module_database_sys_low_code_module_SysLowCodeId">
|
<End Role="sys_low_code_module" Type="TEST.Store.sys_low_code_module" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_low_code_module_database" Type="TEST.Store.sys_low_code_module_database" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_low_code_module">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_low_code_module_database">
|
<PropertyRef Name="SysLowCodeId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_role_data_scope_sys_org_SysOrgId">
|
<End Role="sys_org" Type="TEST.Store.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_data_scope" Type="TEST.Store.sys_role_data_scope" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_org">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_role_data_scope">
|
<PropertyRef Name="SysOrgId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_role_data_scope_sys_role_SysRoleId">
|
<End Role="sys_role" Type="TEST.Store.sys_role" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_data_scope" Type="TEST.Store.sys_role_data_scope" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_role">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_role_data_scope">
|
<PropertyRef Name="SysRoleId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_role_menu_sys_menu_SysMenuId">
|
<End Role="sys_menu" Type="TEST.Store.sys_menu" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_menu" Type="TEST.Store.sys_role_menu" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_menu">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_role_menu">
|
<PropertyRef Name="SysMenuId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_role_menu_sys_role_SysRoleId">
|
<End Role="sys_role" Type="TEST.Store.sys_role" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_menu" Type="TEST.Store.sys_role_menu" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_role">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_role_menu">
|
<PropertyRef Name="SysRoleId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_user_data_scope_sys_org_SysOrgId">
|
<End Role="sys_org" Type="TEST.Store.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_data_scope" Type="TEST.Store.sys_user_data_scope" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_org">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_user_data_scope">
|
<PropertyRef Name="SysOrgId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_user_data_scope_sys_user_SysUserId">
|
<End Role="sys_user" Type="TEST.Store.sys_user" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_data_scope" Type="TEST.Store.sys_user_data_scope" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_user">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_user_data_scope">
|
<PropertyRef Name="SysUserId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_user_role_sys_role_SysRoleId">
|
<End Role="sys_role" Type="TEST.Store.sys_role" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_role" Type="TEST.Store.sys_user_role" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_role">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_user_role">
|
<PropertyRef Name="SysRoleId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_sys_user_role_sys_user_SysUserId">
|
<End Role="sys_user" Type="TEST.Store.sys_user" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_role" Type="TEST.Store.sys_user_role" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="sys_user">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="sys_user_role">
|
<PropertyRef Name="SysUserId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_wms_materialcontainer_wms_container_ContainerId">
|
<End Role="wms_container" Type="TEST.Store.wms_container" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="wms_materialcontainer" Type="TEST.Store.wms_materialcontainer" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="wms_container">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="wms_materialcontainer">
|
<PropertyRef Name="ContainerId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_wms_materialcontainer_wms_material_MaterialId">
|
<End Role="wms_material" Type="TEST.Store.wms_material" Multiplicity="1" />
|
<End Role="wms_materialcontainer" Type="TEST.Store.wms_materialcontainer" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="wms_material">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="wms_materialcontainer">
|
<PropertyRef Name="MaterialId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_wms_place_wms_area_AreaId">
|
<End Role="wms_area" Type="TEST.Store.wms_area" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="wms_place" Type="TEST.Store.wms_place" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="wms_area">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="wms_place">
|
<PropertyRef Name="AreaId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
</Schema>
|
