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