<?xml version="1.0" encoding="utf-8"?>
|
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
|
<!-- EF Runtime content -->
|
<edmx:Runtime>
|
<!-- SSDL content -->
|
<edmx:StorageModels>
|
<Schema Namespace="LA22A07_QYModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
|
<EntityType Name="__EFMigrationsHistory">
|
<Key>
|
<PropertyRef Name="MigrationId" />
|
</Key>
|
<Property Name="MigrationId" Type="nvarchar" MaxLength="150" Nullable="false" />
|
<Property Name="ProductVersion" Type="nvarchar" MaxLength="32" Nullable="false" />
|
</EntityType>
|
<EntityType Name="Base_SysExceptionInfo">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="varchar" MaxLength="255" Nullable="false" />
|
<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" MaxLength="20" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="100" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" 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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" StoreGeneratedPattern="Identity" Nullable="false" />
|
<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" Precision="7" />
|
<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" StoreGeneratedPattern="Identity" Nullable="false" />
|
<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" Precision="7" />
|
</EntityType>
|
<EntityType Name="sys_log_op">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="Account" Type="nvarchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="sys_log_vis">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<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" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="20" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="20" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="CancelTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<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" MaxLength="100" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="20" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" 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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="20" Nullable="false" />
|
<Property Name="Code" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="20" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<Property Name="Password" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="AdminType" Type="int" Nullable="false" />
|
<Property Name="Status" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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>
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="18" 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="IDD" />
|
</Key>
|
<Property Name="IDD" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="WarningTime" Type="datetime2" Precision="7" />
|
<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" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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="ware_equipment">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" Nullable="false" />
|
<Property Name="CoordinateX" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" />
|
</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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Ycoordinate" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<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" />
|
<Property Name="PartCode" Type="varchar" MaxLength="50" />
|
</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" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" />
|
<Property Name="PartCode" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="ware_task_sub">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedUserId" Type="bigint" />
|
<Property Name="UpdatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="bigint" />
|
<Property Name="CreatedUserName" Type="nvarchar" MaxLength="50" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="7" />
|
<Property Name="ContainerType" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" 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="bigint" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" 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="nvarchar(max)" />
|
<Property Name="Remarks" Type="nvarchar(max)" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Width" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Height" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="MaxWeight" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="18" 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" 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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" Precision="18" Scale="2" />
|
<Property Name="Length" Type="decimal" Precision="18" Scale="2" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
<Property Name="Width" Type="decimal" Precision="18" 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" MaxLength="50" Nullable="false" />
|
<Property Name="MaterialName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="MaterialNo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="MaterialBatch" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="MaterialSpec" Type="nvarchar" MaxLength="50" />
|
<Property Name="MaterialId" Type="bigint" Nullable="false" />
|
<Property Name="BindQuantity" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="BindStatus" Type="int" Nullable="false" />
|
<Property Name="SampleQty" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="OrderNo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<Property Name="MaterialType" Type="int" Nullable="false" />
|
<Property Name="MaterialBatch" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="MaterialName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="PlaceCode" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="ContainerCode" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="AreaId" Type="bigint" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" 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="nvarchar(max)" />
|
<Property Name="Status" Type="int" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<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" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Width" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Height" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="MaxWeight" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="HeightLevel" Type="int" Nullable="false" />
|
<Property Name="Priority" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<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" MaxLength="50" Nullable="false" />
|
<Property Name="SourcePlace" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="ToPlace" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="Aisle" Type="int" Nullable="false" />
|
<Property Name="AreaName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<Property Name="OrderNo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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" MaxLength="50" Nullable="false" />
|
<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" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Width" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Height" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="MaxWeight" Type="decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="HeightLevel" Type="int" Nullable="false" />
|
<Property Name="Priority" Type="int" Nullable="false" />
|
<Property Name="CreatedTime" Type="datetimeoffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="datetimeoffset" Precision="7" />
|
<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>
|
<Association Name="FK_sys_dict_data_sys_dict_type_TypeId">
|
<End Role="sys_dict_type" Type="Self.sys_dict_type" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_dict_data" Type="Self.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="Self.sys_emp" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="Self.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="Self.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="Self.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="Self.sys_pos" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="Self.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="Self.sys_emp" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_pos" Type="Self.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="Self.sys_pos" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_pos" Type="Self.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="Self.sys_low_code_module" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_low_code_module_database" Type="Self.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="Self.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_data_scope" Type="Self.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="Self.sys_role" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_data_scope" Type="Self.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="Self.sys_menu" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_menu" Type="Self.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="Self.sys_role" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_role_menu" Type="Self.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="Self.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_data_scope" Type="Self.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="Self.sys_user" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_data_scope" Type="Self.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="Self.sys_role" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_role" Type="Self.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="Self.sys_user" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_user_role" Type="Self.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="Self.wms_container" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="wms_materialcontainer" Type="Self.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="Self.wms_material" Multiplicity="1" />
|
<End Role="wms_materialcontainer" Type="Self.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="Self.wms_area" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="wms_place" Type="Self.wms_place" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="wms_area">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="wms_place">
|
<PropertyRef Name="AreaId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<EntityContainer Name="LA22A07_QYModelStoreContainer">
|
<EntitySet Name="__EFMigrationsHistory" EntityType="Self.__EFMigrationsHistory" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_SysExceptionInfo" EntityType="Self.Base_SysExceptionInfo" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_app" EntityType="Self.sys_app" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_code_gen" EntityType="Self.sys_code_gen" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_code_gen_config" EntityType="Self.sys_code_gen_config" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_code_modular" EntityType="Self.sys_code_modular" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_config" EntityType="Self.sys_config" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_dict_data" EntityType="Self.sys_dict_data" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_dict_type" EntityType="Self.sys_dict_type" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_emp" EntityType="Self.sys_emp" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_emp_ext_org_pos" EntityType="Self.sys_emp_ext_org_pos" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_emp_pos" EntityType="Self.sys_emp_pos" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_file" EntityType="Self.sys_file" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_forms" EntityType="Self.sys_forms" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_log_audit" EntityType="Self.sys_log_audit" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_log_ex" EntityType="Self.sys_log_ex" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_log_op" EntityType="Self.sys_log_op" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_log_vis" EntityType="Self.sys_log_vis" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_low_code_module" EntityType="Self.sys_low_code_module" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_low_code_module_database" EntityType="Self.sys_low_code_module_database" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_menu" EntityType="Self.sys_menu" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_notice" EntityType="Self.sys_notice" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_notice_user" EntityType="Self.sys_notice_user" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_org" EntityType="Self.sys_org" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_pos" EntityType="Self.sys_pos" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_role" EntityType="Self.sys_role" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_role_data_scope" EntityType="Self.sys_role_data_scope" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_timer" EntityType="Self.sys_timer" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_user" EntityType="Self.sys_user" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_user_data_scope" EntityType="Self.sys_user_data_scope" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_user_role" EntityType="Self.sys_user_role" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_container_vs_material" EntityType="Self.ware_container_vs_material" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_device_wareing" EntityType="Self.ware_device_wareing" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_equipment" EntityType="Self.ware_equipment" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_task" EntityType="Self.ware_task" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_task_bak" EntityType="Self.ware_task_bak" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_task_sub" EntityType="Self.ware_task_sub" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ware_task_sub_bak" EntityType="Self.ware_task_sub_bak" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_area" EntityType="Self.wms_area" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_container" EntityType="Self.wms_container" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_container_type" EntityType="Self.wms_container_type" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_location_type" EntityType="Self.wms_location_type" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_material" EntityType="Self.wms_material" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_materialcontainer" EntityType="Self.wms_materialcontainer" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_materialstock" EntityType="Self.wms_materialstock" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_part" EntityType="Self.wms_part" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_place" EntityType="Self.wms_place" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="wms_task" EntityType="Self.wms_task" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sys_role_menu" EntityType="Self.sys_role_menu" store:Type="Tables" store:Schema="dbo">
|
<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="ware_location_vs_container" EntityType="Self.ware_location_vs_container" store:Type="Tables" store:Schema="dbo">
|
<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="Self.ware_site" store:Type="Tables" store:Schema="dbo">
|
<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="v_empty_location" EntityType="Self.v_empty_location" store:Type="Views" store:Schema="dbo">
|
<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>
|
<AssociationSet Name="FK_sys_dict_data_sys_dict_type_TypeId" Association="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.FK_wms_place_wms_area_AreaId">
|
<End Role="wms_area" EntitySet="wms_area" />
|
<End Role="wms_place" EntitySet="wms_place" />
|
</AssociationSet>
|
</EntityContainer>
|
</Schema></edmx:StorageModels>
|
<!-- CSDL content -->
|
<edmx:ConceptualModels>
|
<Schema Namespace="LA22A07_QYModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
<EntityType Name="C__EFMigrationsHistory">
|
<Key>
|
<PropertyRef Name="MigrationId" />
|
</Key>
|
<Property Name="MigrationId" Type="String" MaxLength="150" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="ProductVersion" Type="String" MaxLength="32" FixedLength="false" Unicode="true" Nullable="false" />
|
</EntityType>
|
<EntityType Name="Base_SysExceptionInfo">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="String" MaxLength="255" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="module" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="exceptionLevel" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="exceptionSource" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="exceptionFun" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="sourceData" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="exceptionMsg" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="exceptionData" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="host" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="key1" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="key2" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="key3" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="creator" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="createTime" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="sys_app">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
<Property Name="Name" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Active" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="TablePrefix" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="GenerateType" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="DatabaseName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="TableName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="NameSpace" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="BusName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="MenuApplication" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="MenuPid" Type="Int64" Nullable="false" />
|
<Property Name="LowCodeId" Type="Int64" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="ColumnComment" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="NetType" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="DtoNetType" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="EffectType" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="FkEntityName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="FkColumnName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="FkColumnNetType" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="DictTypeCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="WhetherRetract" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="WhetherRequired" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="QueryWhether" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="QueryType" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
|
<Property Name="WhetherTable" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="WhetherOrderBy" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="WhetherAddUpdate" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="ColumnKey" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="DataType" Type="String" MaxLength="128" FixedLength="false" Unicode="true" />
|
<Property Name="WhetherCommon" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="DatabaseName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="NameSpace" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="BusName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="MenuApplication" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="MenuPid" Type="Int64" Nullable="false" />
|
<Property Name="FormDesignJson" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Value" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="SysFlag" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="GroupCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_dict_type" Relationship="Self.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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_dict_data" Relationship="Self.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" FixedLength="false" Unicode="true" />
|
<Property Name="OrgId" Type="Int64" Nullable="false" />
|
<Property Name="OrgName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<NavigationProperty Name="sys_emp_ext_org_pos" Relationship="Self.FK_sys_emp_ext_org_pos_sys_emp_SysEmpId" FromRole="sys_emp" ToRole="sys_emp_ext_org_pos" />
|
<NavigationProperty Name="sys_pos" Relationship="Self.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="Self.FK_sys_emp_ext_org_pos_sys_emp_SysEmpId" FromRole="sys_emp_ext_org_pos" ToRole="sys_emp" />
|
<NavigationProperty Name="sys_org" Relationship="Self.FK_sys_emp_ext_org_pos_sys_org_SysOrgId" FromRole="sys_emp_ext_org_pos" ToRole="sys_org" />
|
<NavigationProperty Name="sys_pos" Relationship="Self.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" FixedLength="false" Unicode="true" />
|
<Property Name="FileOriginName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="FileSuffix" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="FileSizeKb" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
|
<Property Name="FileSizeInfo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="FileObjectName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="FilePath" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="FormJson" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="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" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="ColumnName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="NewValue" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="OldValue" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UserId" Type="Int64" Nullable="false" />
|
<Property Name="UserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="ClassName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="MethodName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="ExceptionName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ExceptionMsg" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ExceptionSource" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="StackTrace" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ParamsObj" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ExceptionTime" Type="DateTimeOffset" Precision="7" />
|
</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" FixedLength="false" Unicode="true" />
|
<Property Name="Success" Type="Int32" Nullable="false" />
|
<Property Name="Message" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Ip" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Location" Type="String" MaxLength="1024" FixedLength="false" Unicode="true" />
|
<Property Name="Browser" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Os" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Url" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="ClassName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="MethodName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="ReqMethod" Type="String" MaxLength="10" FixedLength="false" Unicode="true" />
|
<Property Name="Param" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Result" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ElapsedTime" Type="Int64" Nullable="false" />
|
<Property Name="OpTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="Account" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
</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" FixedLength="false" Unicode="true" />
|
<Property Name="Success" Type="Int32" Nullable="false" />
|
<Property Name="Message" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Ip" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Location" Type="String" MaxLength="1024" FixedLength="false" Unicode="true" />
|
<Property Name="Browser" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Os" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="VisType" Type="Int32" Nullable="false" />
|
<Property Name="VisTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="Account" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
</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" FixedLength="false" Unicode="true" />
|
<Property Name="GenerateType" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="DatabaseName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="NameSpace" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="BusName" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="MenuApplication" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="MenuPid" Type="Int64" Nullable="false" />
|
<Property Name="FormDesignType" Type="Int32" Nullable="false" />
|
<Property Name="FormDesign" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_low_code_module_database" Relationship="Self.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" FixedLength="false" Unicode="true" />
|
<Property Name="Control_Label" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="Control_Model" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="Control_Type" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="TableName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="ClassName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="TableDesc" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="FieldName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="DbTypeName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="DtoTypeName" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="DbParam" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_low_code_module" Relationship="Self.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" FixedLength="false" Unicode="true" />
|
<Property Name="Name" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Type" Type="Int32" Nullable="false" />
|
<Property Name="Icon" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Router" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Component" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Permission" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Application" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="OpenType" Type="Int32" Nullable="false" />
|
<Property Name="Visible" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="Link" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Redirect" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Weight" Type="Int32" Nullable="false" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_role" Relationship="Self.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" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Content" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Type" Type="Int32" Nullable="false" />
|
<Property Name="PublicUserId" Type="Int64" Nullable="false" />
|
<Property Name="PublicUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="PublicOrgId" Type="Int64" Nullable="false" />
|
<Property Name="PublicOrgName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="PublicTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CancelTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" Precision="7" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="Name" Type="String" MaxLength="100" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Contacts" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Tel" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="OrgType" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_emp_ext_org_pos" Relationship="Self.FK_sys_emp_ext_org_pos_sys_org_SysOrgId" FromRole="sys_org" ToRole="sys_emp_ext_org_pos" />
|
<NavigationProperty Name="sys_role" Relationship="Self.sys_role_data_scope" FromRole="sys_org" ToRole="sys_role" />
|
<NavigationProperty Name="sys_user" Relationship="Self.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" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_emp_ext_org_pos" Relationship="Self.FK_sys_emp_ext_org_pos_sys_pos_SysPosId" FromRole="sys_pos" ToRole="sys_emp_ext_org_pos" />
|
<NavigationProperty Name="sys_emp" Relationship="Self.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" MaxLength="20" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Code" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Sort" Type="Int32" Nullable="false" />
|
<Property Name="DataScopeType" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="RoleType" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="sys_org" Relationship="Self.sys_role_data_scope" FromRole="sys_role" ToRole="sys_org" />
|
<NavigationProperty Name="sys_user" Relationship="Self.sys_user_role" FromRole="sys_role" ToRole="sys_user" />
|
<NavigationProperty Name="sys_menu" Relationship="Self.sys_role_menu" FromRole="sys_role" ToRole="sys_menu" />
|
</EntityType>
|
<EntityType Name="sys_timer">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
<Property Name="JobName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" Nullable="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" FixedLength="false" Unicode="true" />
|
<Property Name="TimerType" Type="Int32" Nullable="false" />
|
<Property Name="RequestUrl" Type="String" MaxLength="200" FixedLength="false" Unicode="true" />
|
<Property Name="RequestParameters" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Headers" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="RequestType" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="NickName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Name" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Avatar" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Birthday" Type="DateTimeOffset" Precision="7" />
|
<Property Name="Sex" Type="Int32" Nullable="false" />
|
<Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Phone" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="Tel" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="LastLoginIp" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="LastLoginTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="AdminType" Type="Int32" Nullable="false" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="LineType" Type="Int32" />
|
<NavigationProperty Name="sys_org" Relationship="Self.sys_user_data_scope" FromRole="sys_user" ToRole="sys_org" />
|
<NavigationProperty Name="sys_role" Relationship="Self.sys_user_role" FromRole="sys_user" ToRole="sys_role" />
|
</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" FixedLength="false" Unicode="true" />
|
<Property Name="TaskNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="TaskName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="TaskPriority" Type="Int32" Nullable="false" />
|
<Property Name="ContainerCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="FromLocationCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ToLocationCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="FinishedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="Lane" Type="Int32" />
|
<Property Name="MoveFlag" Type="Int32" />
|
<Property Name="MoveFromLocation" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="MoveToLocation" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="MoveContainerCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ContainerType" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="OperationRemark" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="PartCode" Type="String" MaxLength="50" FixedLength="false" Unicode="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" FixedLength="false" Unicode="true" />
|
<Property Name="WCSTaskId" Type="Int32" />
|
<Property Name="TaskId" Type="Int64" />
|
<Property Name="TaskNo" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="TaskSequence" Type="Int32" />
|
<Property Name="TaskDescribe" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="TaskState" Type="Int32" />
|
<Property Name="DeviceType" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="DeviceId" Type="Int32" />
|
<Property Name="ContainerCode" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="TaskType" Type="Int32" />
|
<Property Name="SourcePlace" Type="String" MaxLength="50" FixedLength="false" Unicode="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" FixedLength="false" Unicode="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" Precision="7" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="OperationRemark" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="ContainerType" Type="Int32" />
|
<Property Name="AgvTaskCode" Type="String" MaxLength="64" FixedLength="false" Unicode="false" />
|
<Property Name="AgvCode" Type="String" MaxLength="5" FixedLength="false" Unicode="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" FixedLength="false" Unicode="true" />
|
<Property Name="TaskId" Type="Int64" Nullable="false" />
|
<Property Name="TaskNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="TaskSequence" Type="Int32" Nullable="false" />
|
<Property Name="TaskState" Type="Int32" Nullable="false" />
|
<Property Name="TaskDescribe" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="DeviceType" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="DeviceId" Type="Int32" Nullable="false" />
|
<Property Name="ContainerCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<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" Precision="7" />
|
<Property Name="ContainerType" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="SourcePlace" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ToPlace" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="wms_area">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
<Property Name="AreaName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="AreaDesc" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
|
<Property Name="AreaStatus" Type="Int32" Nullable="false" />
|
<Property Name="AreaType" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="wms_place" Relationship="Self.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" FixedLength="false" Unicode="true" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="ContainerTypeCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="wms_materialcontainer" Relationship="Self.FK_wms_materialcontainer_wms_container_ContainerId" FromRole="wms_container" ToRole="wms_materialcontainer" />
|
<Property Name="RealLocationCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</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" FixedLength="false" Unicode="true" />
|
<Property Name="WareContainerTypeName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="Remarks" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="WareLocationTypeName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" Nullable="false" />
|
<Property Name="Remark" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Length" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Width" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Height" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="MaxWeight" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="MaterialNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="MaterialBatch" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Description" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<Property Name="InspectionMethod" Type="Int32" />
|
<Property Name="MaterialType" Type="Int32" />
|
<Property Name="MaterialSpec" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="GraphNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Qccategory" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="Width" Type="Decimal" Precision="18" Scale="2" />
|
<Property Name="WareContainerTypeCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="CarType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="wms_materialcontainer" Relationship="Self.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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialBatch" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialSpec" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="MaterialId" Type="Int64" Nullable="false" />
|
<Property Name="BindQuantity" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="BindStatus" Type="Int32" Nullable="false" />
|
<Property Name="SampleQty" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="OrderNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<NavigationProperty Name="wms_container" Relationship="Self.FK_wms_materialcontainer_wms_container_ContainerId" FromRole="wms_materialcontainer" ToRole="wms_container" />
|
<NavigationProperty Name="wms_material" Relationship="Self.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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialType" Type="Int32" Nullable="false" />
|
<Property Name="MaterialBatch" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="MaterialSpec" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="PlaceCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="ContainerCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="AreaId" Type="Int64" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="PartName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="MaterialCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="LineType" Type="Int32" />
|
<Property Name="CarType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="wms_place">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
<Property Name="PlaceCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="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" FixedLength="false" Unicode="true" />
|
<Property Name="Xzb" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Yzb" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Zzb" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Length" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Width" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Height" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="MaxWeight" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="HeightLevel" Type="Int32" Nullable="false" />
|
<Property Name="Priority" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="WareLocationTypeCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="UnionCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="wms_area" Relationship="Self.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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="SourcePlace" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="ToPlace" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Aisle" Type="Int32" Nullable="false" />
|
<Property Name="AreaName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="OrderNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="SendTimes" Type="Int32" Nullable="false" />
|
<Property Name="DodeviceId" Type="Int32" Nullable="false" />
|
<Property Name="DodevicenodeId" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Dodevicetype" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
</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" FixedLength="false" Unicode="true" />
|
<Property Name="WareMaterialCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Quantity" Type="Decimal" Precision="27" Scale="6" />
|
<Property Name="PurchaseNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="DeliveryNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="CollectNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="OrdersNo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="IsLocked" Type="Boolean" />
|
<Property Name="IsDeleted" Type="Boolean" />
|
<Property Name="Remarks" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<Property Name="StockStatus" Type="Int32" />
|
<Property Name="Price" Type="Decimal" Precision="18" Scale="2" />
|
<Property Name="BarNo" Type="String" MaxLength="100" FixedLength="false" Unicode="true" />
|
<Property Name="OrderType" Type="String" MaxLength="5" FixedLength="false" Unicode="true" />
|
<Property Name="Unit" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="WareMaterialName" Type="String" MaxLength="500" FixedLength="false" Unicode="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" FixedLength="false" Unicode="true" />
|
<Property Name="WareRegionCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="WareLocationCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="WareContainerCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsEmptyContainer" Type="Boolean" />
|
<Property Name="Status" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="IsDeleted" Type="Boolean" />
|
<Property Name="Remarks" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<Property Name="Row" Type="Int32" />
|
<Property Name="Lane" Type="Int32" />
|
<Property Name="LocTypeCode" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="DeepcellNo" Type="Int32" />
|
<Property Name="UnionCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="WareContainerName" Type="String" MaxLength="50" FixedLength="false" Unicode="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" FixedLength="false" Unicode="true" />
|
<Property Name="Describe" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Xcoordinate" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Ycoordinate" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Status" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="TenantId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" />
|
<Property Name="Name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="SiteType" Type="Int32" />
|
<Property Name="Lane" Type="Int32" />
|
<Property Name="OperationRemarks" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<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" FixedLength="false" Unicode="true" />
|
<Property Name="TaskNo" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="TaskName" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="TaskCategory" Type="Int32" />
|
<Property Name="TaskType" Type="Int32" />
|
<Property Name="TaskState" Type="Int32" />
|
<Property Name="TaskDescribe" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="TaskPriority" Type="Int32" />
|
<Property Name="ContainerCode" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="FromLocationCode" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="ToLocationCode" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="FinishedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="Lane" Type="Int32" />
|
<Property Name="MoveFlag" Type="Int32" />
|
<Property Name="MoveFromLocation" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="MoveToLocation" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="MoveContainerCode" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="ContainerType" Type="Int32" />
|
<Property Name="OperationRemark" Type="String" MaxLength="500" FixedLength="false" Unicode="false" />
|
<Property Name="PartCode" Type="String" MaxLength="50" FixedLength="false" Unicode="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" MaxLength="50" FixedLength="false" Unicode="true" Nullable="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" FixedLength="false" Unicode="true" />
|
<Property Name="Xzb" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Yzb" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Zzb" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="Length" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Width" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="Height" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="MaxWeight" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
|
<Property Name="HeightLevel" Type="Int32" Nullable="false" />
|
<Property Name="Priority" Type="Int32" Nullable="false" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="WareLocationTypeCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="UnionCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<Association Name="FK_sys_dict_data_sys_dict_type_TypeId">
|
<End Role="sys_dict_type" Type="Self.sys_dict_type" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_dict_data" Type="Self.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="Self.sys_emp" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="Self.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="Self.sys_org" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="Self.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="Self.sys_pos" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_emp_ext_org_pos" Type="Self.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="Self.sys_low_code_module" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="sys_low_code_module_database" Type="Self.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="Self.wms_area" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="wms_place" Type="Self.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="Self.wms_container" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="wms_materialcontainer" Type="Self.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="Self.wms_material" Multiplicity="1" />
|
<End Role="wms_materialcontainer" Type="Self.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="Self.sys_emp" Multiplicity="*" />
|
<End Role="sys_pos" Type="Self.sys_pos" Multiplicity="*" />
|
</Association>
|
<Association Name="sys_role_data_scope">
|
<End Role="sys_org" Type="Self.sys_org" Multiplicity="*" />
|
<End Role="sys_role" Type="Self.sys_role" Multiplicity="*" />
|
</Association>
|
<Association Name="sys_user_data_scope">
|
<End Role="sys_org" Type="Self.sys_org" Multiplicity="*" />
|
<End Role="sys_user" Type="Self.sys_user" Multiplicity="*" />
|
</Association>
|
<Association Name="sys_user_role">
|
<End Role="sys_role" Type="Self.sys_role" Multiplicity="*" />
|
<End Role="sys_user" Type="Self.sys_user" Multiplicity="*" />
|
</Association>
|
<Association Name="sys_role_menu">
|
<End Role="sys_menu" Type="Self.sys_menu" Multiplicity="*" />
|
<End Role="sys_role" Type="Self.sys_role" Multiplicity="*" />
|
</Association>
|
<EntityContainer Name="DbOrm" annotation:LazyLoadingEnabled="true">
|
<EntitySet Name="C__EFMigrationsHistory" EntityType="Self.C__EFMigrationsHistory" />
|
<EntitySet Name="Base_SysExceptionInfo" EntityType="Self.Base_SysExceptionInfo" />
|
<EntitySet Name="sys_app" EntityType="Self.sys_app" />
|
<EntitySet Name="sys_code_gen" EntityType="Self.sys_code_gen" />
|
<EntitySet Name="sys_code_gen_config" EntityType="Self.sys_code_gen_config" />
|
<EntitySet Name="sys_code_modular" EntityType="Self.sys_code_modular" />
|
<EntitySet Name="sys_config" EntityType="Self.sys_config" />
|
<EntitySet Name="sys_dict_data" EntityType="Self.sys_dict_data" />
|
<EntitySet Name="sys_dict_type" EntityType="Self.sys_dict_type" />
|
<EntitySet Name="sys_emp" EntityType="Self.sys_emp" />
|
<EntitySet Name="sys_emp_ext_org_pos" EntityType="Self.sys_emp_ext_org_pos" />
|
<EntitySet Name="sys_file" EntityType="Self.sys_file" />
|
<EntitySet Name="sys_forms" EntityType="Self.sys_forms" />
|
<EntitySet Name="sys_log_audit" EntityType="Self.sys_log_audit" />
|
<EntitySet Name="sys_log_ex" EntityType="Self.sys_log_ex" />
|
<EntitySet Name="sys_log_op" EntityType="Self.sys_log_op" />
|
<EntitySet Name="sys_log_vis" EntityType="Self.sys_log_vis" />
|
<EntitySet Name="sys_low_code_module" EntityType="Self.sys_low_code_module" />
|
<EntitySet Name="sys_low_code_module_database" EntityType="Self.sys_low_code_module_database" />
|
<EntitySet Name="sys_menu" EntityType="Self.sys_menu" />
|
<EntitySet Name="sys_notice" EntityType="Self.sys_notice" />
|
<EntitySet Name="sys_notice_user" EntityType="Self.sys_notice_user" />
|
<EntitySet Name="sys_org" EntityType="Self.sys_org" />
|
<EntitySet Name="sys_pos" EntityType="Self.sys_pos" />
|
<EntitySet Name="sys_role" EntityType="Self.sys_role" />
|
<EntitySet Name="sys_timer" EntityType="Self.sys_timer" />
|
<EntitySet Name="sys_user" EntityType="Self.sys_user" />
|
<EntitySet Name="ware_task_bak" EntityType="Self.ware_task_bak" />
|
<EntitySet Name="ware_task_sub" EntityType="Self.ware_task_sub" />
|
<EntitySet Name="ware_task_sub_bak" EntityType="Self.ware_task_sub_bak" />
|
<EntitySet Name="wms_area" EntityType="Self.wms_area" />
|
<EntitySet Name="wms_container" EntityType="Self.wms_container" />
|
<EntitySet Name="wms_container_type" EntityType="Self.wms_container_type" />
|
<EntitySet Name="wms_location_type" EntityType="Self.wms_location_type" />
|
<EntitySet Name="wms_material" EntityType="Self.wms_material" />
|
<EntitySet Name="wms_materialcontainer" EntityType="Self.wms_materialcontainer" />
|
<EntitySet Name="wms_materialstock" EntityType="Self.wms_materialstock" />
|
<EntitySet Name="wms_part" EntityType="Self.wms_part" />
|
<EntitySet Name="wms_place" EntityType="Self.wms_place" />
|
<EntitySet Name="wms_task" EntityType="Self.wms_task" />
|
<EntitySet Name="ware_container_vs_material" EntityType="Self.ware_container_vs_material" />
|
<EntitySet Name="ware_location_vs_container" EntityType="Self.ware_location_vs_container" />
|
<EntitySet Name="ware_site" EntityType="Self.ware_site" />
|
<EntitySet Name="ware_task" EntityType="Self.ware_task" />
|
<EntitySet Name="v_empty_location" EntityType="Self.v_empty_location" />
|
<AssociationSet Name="FK_sys_dict_data_sys_dict_type_TypeId" Association="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.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="Self.sys_role_data_scope">
|
<End Role="sys_org" EntitySet="sys_org" />
|
<End Role="sys_role" EntitySet="sys_role" />
|
</AssociationSet>
|
<AssociationSet Name="sys_user_data_scope" Association="Self.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="Self.sys_user_role">
|
<End Role="sys_role" EntitySet="sys_role" />
|
<End Role="sys_user" EntitySet="sys_user" />
|
</AssociationSet>
|
<AssociationSet Name="sys_role_menu" Association="Self.sys_role_menu">
|
<End Role="sys_menu" EntitySet="sys_menu" />
|
<End Role="sys_role" EntitySet="sys_role" />
|
</AssociationSet>
|
<EntitySet Name="ware_device_wareing" EntityType="LA22A07_QYModel.ware_device_wareing" />
|
<EntitySet Name="ware_equipment" EntityType="LA22A07_QYModel.ware_equipment" />
|
</EntityContainer>
|
<EntityType Name="ware_device_wareing">
|
<Key>
|
<PropertyRef Name="IDD" />
|
</Key>
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
<Property Name="WarningTime" Type="DateTime" Precision="7" />
|
<Property Name="DeviceCode" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="DeviceName" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<Property Name="WarningCode" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="WarningDbAddress" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="WarningContent" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="Status" Type="Int32" />
|
<Property Name="StatusName" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="CloseContent" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="FinishTime" Type="DateTime" Precision="7" />
|
<Property Name="DurationTime" Type="String" MaxLength="255" FixedLength="false" Unicode="true" />
|
<Property Name="OperationRemark" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<Property Name="DeviceType" Type="Int32" />
|
<Property Name="DeviceTypeName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
<Property Name="IsDeleted" Type="Boolean" Nullable="false" />
|
<Property Name="IDD" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
</EntityType>
|
<EntityType Name="ware_equipment">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int64" Nullable="false" />
|
<Property Name="CoordinateX" Type="Int32" />
|
<Property Name="CreatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="UpdatedTime" Type="DateTimeOffset" Precision="7" />
|
<Property Name="CreatedUserId" Type="Int64" />
|
<Property Name="CreatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserName" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
<Property Name="UpdatedUserId" Type="Int64" />
|
<Property Name="IsDeleted" Type="Boolean" />
|
</EntityType>
|
</Schema>
|
</edmx:ConceptualModels>
|
<!-- C-S mapping content -->
|
<edmx:Mappings>
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
|
<EntityContainerMapping StorageEntityContainer="LA22A07_QYModelStoreContainer" CdmEntityContainer="DbOrm">
|
<EntitySetMapping Name="C__EFMigrationsHistory">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.C__EFMigrationsHistory">
|
<MappingFragment StoreEntitySet="__EFMigrationsHistory">
|
<ScalarProperty Name="MigrationId" ColumnName="MigrationId" />
|
<ScalarProperty Name="ProductVersion" ColumnName="ProductVersion" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="Base_SysExceptionInfo">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.Base_SysExceptionInfo">
|
<MappingFragment StoreEntitySet="Base_SysExceptionInfo">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="module" ColumnName="module" />
|
<ScalarProperty Name="exceptionLevel" ColumnName="exceptionLevel" />
|
<ScalarProperty Name="exceptionSource" ColumnName="exceptionSource" />
|
<ScalarProperty Name="exceptionFun" ColumnName="exceptionFun" />
|
<ScalarProperty Name="sourceData" ColumnName="sourceData" />
|
<ScalarProperty Name="exceptionMsg" ColumnName="exceptionMsg" />
|
<ScalarProperty Name="exceptionData" ColumnName="exceptionData" />
|
<ScalarProperty Name="host" ColumnName="host" />
|
<ScalarProperty Name="key1" ColumnName="key1" />
|
<ScalarProperty Name="key2" ColumnName="key2" />
|
<ScalarProperty Name="key3" ColumnName="key3" />
|
<ScalarProperty Name="creator" ColumnName="creator" />
|
<ScalarProperty Name="createTime" ColumnName="createTime" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_app">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_app">
|
<MappingFragment StoreEntitySet="sys_app">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Active" ColumnName="Active" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_code_gen">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_code_gen">
|
<MappingFragment StoreEntitySet="sys_code_gen">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="AuthorName" ColumnName="AuthorName" />
|
<ScalarProperty Name="TablePrefix" ColumnName="TablePrefix" />
|
<ScalarProperty Name="GenerateType" ColumnName="GenerateType" />
|
<ScalarProperty Name="DatabaseName" ColumnName="DatabaseName" />
|
<ScalarProperty Name="TableName" ColumnName="TableName" />
|
<ScalarProperty Name="NameSpace" ColumnName="NameSpace" />
|
<ScalarProperty Name="BusName" ColumnName="BusName" />
|
<ScalarProperty Name="MenuApplication" ColumnName="MenuApplication" />
|
<ScalarProperty Name="MenuPid" ColumnName="MenuPid" />
|
<ScalarProperty Name="LowCodeId" ColumnName="LowCodeId" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_code_gen_config">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_code_gen_config">
|
<MappingFragment StoreEntitySet="sys_code_gen_config">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="CodeGenId" ColumnName="CodeGenId" />
|
<ScalarProperty Name="ColumnName" ColumnName="ColumnName" />
|
<ScalarProperty Name="ColumnComment" ColumnName="ColumnComment" />
|
<ScalarProperty Name="NetType" ColumnName="NetType" />
|
<ScalarProperty Name="DtoNetType" ColumnName="DtoNetType" />
|
<ScalarProperty Name="EffectType" ColumnName="EffectType" />
|
<ScalarProperty Name="FkEntityName" ColumnName="FkEntityName" />
|
<ScalarProperty Name="FkColumnName" ColumnName="FkColumnName" />
|
<ScalarProperty Name="FkColumnNetType" ColumnName="FkColumnNetType" />
|
<ScalarProperty Name="DictTypeCode" ColumnName="DictTypeCode" />
|
<ScalarProperty Name="WhetherRetract" ColumnName="WhetherRetract" />
|
<ScalarProperty Name="WhetherRequired" ColumnName="WhetherRequired" />
|
<ScalarProperty Name="QueryWhether" ColumnName="QueryWhether" />
|
<ScalarProperty Name="QueryType" ColumnName="QueryType" />
|
<ScalarProperty Name="WhetherTable" ColumnName="WhetherTable" />
|
<ScalarProperty Name="WhetherOrderBy" ColumnName="WhetherOrderBy" />
|
<ScalarProperty Name="WhetherAddUpdate" ColumnName="WhetherAddUpdate" />
|
<ScalarProperty Name="ColumnKey" ColumnName="ColumnKey" />
|
<ScalarProperty Name="DataType" ColumnName="DataType" />
|
<ScalarProperty Name="WhetherCommon" ColumnName="WhetherCommon" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_code_modular">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_code_modular">
|
<MappingFragment StoreEntitySet="sys_code_modular">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="AuthorName" ColumnName="AuthorName" />
|
<ScalarProperty Name="DatabaseName" ColumnName="DatabaseName" />
|
<ScalarProperty Name="NameSpace" ColumnName="NameSpace" />
|
<ScalarProperty Name="BusName" ColumnName="BusName" />
|
<ScalarProperty Name="MenuApplication" ColumnName="MenuApplication" />
|
<ScalarProperty Name="MenuPid" ColumnName="MenuPid" />
|
<ScalarProperty Name="FormDesignJson" ColumnName="FormDesignJson" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_config">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_config">
|
<MappingFragment StoreEntitySet="sys_config">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Value" ColumnName="Value" />
|
<ScalarProperty Name="SysFlag" ColumnName="SysFlag" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="GroupCode" ColumnName="GroupCode" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_dict_data">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_dict_data">
|
<MappingFragment StoreEntitySet="sys_dict_data">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="TypeId" ColumnName="TypeId" />
|
<ScalarProperty Name="Value" ColumnName="Value" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_dict_type">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_dict_type">
|
<MappingFragment StoreEntitySet="sys_dict_type">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_emp">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_emp">
|
<MappingFragment StoreEntitySet="sys_emp">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="JobNum" ColumnName="JobNum" />
|
<ScalarProperty Name="OrgId" ColumnName="OrgId" />
|
<ScalarProperty Name="OrgName" ColumnName="OrgName" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_emp_ext_org_pos">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_emp_ext_org_pos">
|
<MappingFragment StoreEntitySet="sys_emp_ext_org_pos">
|
<ScalarProperty Name="SysEmpId" ColumnName="SysEmpId" />
|
<ScalarProperty Name="SysOrgId" ColumnName="SysOrgId" />
|
<ScalarProperty Name="SysPosId" ColumnName="SysPosId" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_file">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_file">
|
<MappingFragment StoreEntitySet="sys_file">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="FileLocation" ColumnName="FileLocation" />
|
<ScalarProperty Name="FileBucket" ColumnName="FileBucket" />
|
<ScalarProperty Name="FileOriginName" ColumnName="FileOriginName" />
|
<ScalarProperty Name="FileSuffix" ColumnName="FileSuffix" />
|
<ScalarProperty Name="FileSizeKb" ColumnName="FileSizeKb" />
|
<ScalarProperty Name="FileSizeInfo" ColumnName="FileSizeInfo" />
|
<ScalarProperty Name="FileObjectName" ColumnName="FileObjectName" />
|
<ScalarProperty Name="FilePath" ColumnName="FilePath" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_forms">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_forms">
|
<MappingFragment StoreEntitySet="sys_forms">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Title" ColumnName="Title" />
|
<ScalarProperty Name="FormJson" ColumnName="FormJson" />
|
<ScalarProperty Name="Publish" ColumnName="Publish" />
|
<ScalarProperty Name="TypeId" ColumnName="TypeId" />
|
<ScalarProperty Name="Version" ColumnName="Version" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_log_audit">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_log_audit">
|
<MappingFragment StoreEntitySet="sys_log_audit">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="TableName" ColumnName="TableName" />
|
<ScalarProperty Name="ColumnName" ColumnName="ColumnName" />
|
<ScalarProperty Name="NewValue" ColumnName="NewValue" />
|
<ScalarProperty Name="OldValue" ColumnName="OldValue" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
<ScalarProperty Name="UserName" ColumnName="UserName" />
|
<ScalarProperty Name="Operate" ColumnName="Operate" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_log_ex">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_log_ex">
|
<MappingFragment StoreEntitySet="sys_log_ex">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Account" ColumnName="Account" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="ClassName" ColumnName="ClassName" />
|
<ScalarProperty Name="MethodName" ColumnName="MethodName" />
|
<ScalarProperty Name="ExceptionName" ColumnName="ExceptionName" />
|
<ScalarProperty Name="ExceptionMsg" ColumnName="ExceptionMsg" />
|
<ScalarProperty Name="ExceptionSource" ColumnName="ExceptionSource" />
|
<ScalarProperty Name="StackTrace" ColumnName="StackTrace" />
|
<ScalarProperty Name="ParamsObj" ColumnName="ParamsObj" />
|
<ScalarProperty Name="ExceptionTime" ColumnName="ExceptionTime" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_log_op">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_log_op">
|
<MappingFragment StoreEntitySet="sys_log_op">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Success" ColumnName="Success" />
|
<ScalarProperty Name="Message" ColumnName="Message" />
|
<ScalarProperty Name="Ip" ColumnName="Ip" />
|
<ScalarProperty Name="Location" ColumnName="Location" />
|
<ScalarProperty Name="Browser" ColumnName="Browser" />
|
<ScalarProperty Name="Os" ColumnName="Os" />
|
<ScalarProperty Name="Url" ColumnName="Url" />
|
<ScalarProperty Name="ClassName" ColumnName="ClassName" />
|
<ScalarProperty Name="MethodName" ColumnName="MethodName" />
|
<ScalarProperty Name="ReqMethod" ColumnName="ReqMethod" />
|
<ScalarProperty Name="Param" ColumnName="Param" />
|
<ScalarProperty Name="Result" ColumnName="Result" />
|
<ScalarProperty Name="ElapsedTime" ColumnName="ElapsedTime" />
|
<ScalarProperty Name="OpTime" ColumnName="OpTime" />
|
<ScalarProperty Name="Account" ColumnName="Account" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_log_vis">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_log_vis">
|
<MappingFragment StoreEntitySet="sys_log_vis">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Success" ColumnName="Success" />
|
<ScalarProperty Name="Message" ColumnName="Message" />
|
<ScalarProperty Name="Ip" ColumnName="Ip" />
|
<ScalarProperty Name="Location" ColumnName="Location" />
|
<ScalarProperty Name="Browser" ColumnName="Browser" />
|
<ScalarProperty Name="Os" ColumnName="Os" />
|
<ScalarProperty Name="VisType" ColumnName="VisType" />
|
<ScalarProperty Name="VisTime" ColumnName="VisTime" />
|
<ScalarProperty Name="Account" ColumnName="Account" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_low_code_module">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_low_code_module">
|
<MappingFragment StoreEntitySet="sys_low_code_module">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="AuthorName" ColumnName="AuthorName" />
|
<ScalarProperty Name="GenerateType" ColumnName="GenerateType" />
|
<ScalarProperty Name="DatabaseName" ColumnName="DatabaseName" />
|
<ScalarProperty Name="NameSpace" ColumnName="NameSpace" />
|
<ScalarProperty Name="BusName" ColumnName="BusName" />
|
<ScalarProperty Name="MenuApplication" ColumnName="MenuApplication" />
|
<ScalarProperty Name="MenuPid" ColumnName="MenuPid" />
|
<ScalarProperty Name="FormDesignType" ColumnName="FormDesignType" />
|
<ScalarProperty Name="FormDesign" ColumnName="FormDesign" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_low_code_module_database">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_low_code_module_database">
|
<MappingFragment StoreEntitySet="sys_low_code_module_database">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="SysLowCodeId" ColumnName="SysLowCodeId" />
|
<ScalarProperty Name="Control_Key" ColumnName="Control_Key" />
|
<ScalarProperty Name="Control_Label" ColumnName="Control_Label" />
|
<ScalarProperty Name="Control_Model" ColumnName="Control_Model" />
|
<ScalarProperty Name="Control_Type" ColumnName="Control_Type" />
|
<ScalarProperty Name="TableName" ColumnName="TableName" />
|
<ScalarProperty Name="ClassName" ColumnName="ClassName" />
|
<ScalarProperty Name="TableDesc" ColumnName="TableDesc" />
|
<ScalarProperty Name="FieldName" ColumnName="FieldName" />
|
<ScalarProperty Name="DbTypeName" ColumnName="DbTypeName" />
|
<ScalarProperty Name="DtoTypeName" ColumnName="DtoTypeName" />
|
<ScalarProperty Name="DbParam" ColumnName="DbParam" />
|
<ScalarProperty Name="IsRequired" ColumnName="IsRequired" />
|
<ScalarProperty Name="WhetherTable" ColumnName="WhetherTable" />
|
<ScalarProperty Name="WhetherOrderBy" ColumnName="WhetherOrderBy" />
|
<ScalarProperty Name="WhetherAddUpdate" ColumnName="WhetherAddUpdate" />
|
<ScalarProperty Name="QueryWhether" ColumnName="QueryWhether" />
|
<ScalarProperty Name="QueryType" ColumnName="QueryType" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_menu">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_menu">
|
<MappingFragment StoreEntitySet="sys_menu">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Pid" ColumnName="Pid" />
|
<ScalarProperty Name="Pids" ColumnName="Pids" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
<ScalarProperty Name="Icon" ColumnName="Icon" />
|
<ScalarProperty Name="Router" ColumnName="Router" />
|
<ScalarProperty Name="Component" ColumnName="Component" />
|
<ScalarProperty Name="Permission" ColumnName="Permission" />
|
<ScalarProperty Name="Application" ColumnName="Application" />
|
<ScalarProperty Name="OpenType" ColumnName="OpenType" />
|
<ScalarProperty Name="Visible" ColumnName="Visible" />
|
<ScalarProperty Name="Link" ColumnName="Link" />
|
<ScalarProperty Name="Redirect" ColumnName="Redirect" />
|
<ScalarProperty Name="Weight" ColumnName="Weight" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_notice">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_notice">
|
<MappingFragment StoreEntitySet="sys_notice">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Title" ColumnName="Title" />
|
<ScalarProperty Name="Content" ColumnName="Content" />
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
<ScalarProperty Name="PublicUserId" ColumnName="PublicUserId" />
|
<ScalarProperty Name="PublicUserName" ColumnName="PublicUserName" />
|
<ScalarProperty Name="PublicOrgId" ColumnName="PublicOrgId" />
|
<ScalarProperty Name="PublicOrgName" ColumnName="PublicOrgName" />
|
<ScalarProperty Name="PublicTime" ColumnName="PublicTime" />
|
<ScalarProperty Name="CancelTime" ColumnName="CancelTime" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_notice_user">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_notice_user">
|
<MappingFragment StoreEntitySet="sys_notice_user">
|
<ScalarProperty Name="NoticeId" ColumnName="NoticeId" />
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
<ScalarProperty Name="ReadTime" ColumnName="ReadTime" />
|
<ScalarProperty Name="ReadStatus" ColumnName="ReadStatus" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_org">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_org">
|
<MappingFragment StoreEntitySet="sys_org">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Pid" ColumnName="Pid" />
|
<ScalarProperty Name="Pids" ColumnName="Pids" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Contacts" ColumnName="Contacts" />
|
<ScalarProperty Name="Tel" ColumnName="Tel" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="OrgType" ColumnName="OrgType" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_pos">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_pos">
|
<MappingFragment StoreEntitySet="sys_pos">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_role">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_role">
|
<MappingFragment StoreEntitySet="sys_role">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Sort" ColumnName="Sort" />
|
<ScalarProperty Name="DataScopeType" ColumnName="DataScopeType" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="RoleType" ColumnName="RoleType" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_timer">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_timer">
|
<MappingFragment StoreEntitySet="sys_timer">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="JobName" ColumnName="JobName" />
|
<ScalarProperty Name="DoOnce" ColumnName="DoOnce" />
|
<ScalarProperty Name="StartNow" ColumnName="StartNow" />
|
<ScalarProperty Name="ExecuteType" ColumnName="ExecuteType" />
|
<ScalarProperty Name="Interval" ColumnName="Interval" />
|
<ScalarProperty Name="Cron" ColumnName="Cron" />
|
<ScalarProperty Name="TimerType" ColumnName="TimerType" />
|
<ScalarProperty Name="RequestUrl" ColumnName="RequestUrl" />
|
<ScalarProperty Name="RequestParameters" ColumnName="RequestParameters" />
|
<ScalarProperty Name="Headers" ColumnName="Headers" />
|
<ScalarProperty Name="RequestType" ColumnName="RequestType" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="sys_user">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.sys_user">
|
<MappingFragment StoreEntitySet="sys_user">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Account" ColumnName="Account" />
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
<ScalarProperty Name="NickName" ColumnName="NickName" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Avatar" ColumnName="Avatar" />
|
<ScalarProperty Name="Birthday" ColumnName="Birthday" />
|
<ScalarProperty Name="Sex" ColumnName="Sex" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="Phone" ColumnName="Phone" />
|
<ScalarProperty Name="Tel" ColumnName="Tel" />
|
<ScalarProperty Name="LastLoginIp" ColumnName="LastLoginIp" />
|
<ScalarProperty Name="LastLoginTime" ColumnName="LastLoginTime" />
|
<ScalarProperty Name="AdminType" ColumnName="AdminType" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="LineType" ColumnName="LineType" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_task_bak">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_task_bak">
|
<MappingFragment StoreEntitySet="ware_task_bak">
|
<ScalarProperty Name="PartCode" ColumnName="PartCode" />
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="OrderNo" ColumnName="OrderNo" />
|
<ScalarProperty Name="TaskNo" ColumnName="TaskNo" />
|
<ScalarProperty Name="TaskName" ColumnName="TaskName" />
|
<ScalarProperty Name="TaskCategory" ColumnName="TaskCategory" />
|
<ScalarProperty Name="TaskType" ColumnName="TaskType" />
|
<ScalarProperty Name="TaskState" ColumnName="TaskState" />
|
<ScalarProperty Name="TaskDescribe" ColumnName="TaskDescribe" />
|
<ScalarProperty Name="TaskPriority" ColumnName="TaskPriority" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="FromLocationCode" ColumnName="FromLocationCode" />
|
<ScalarProperty Name="ToLocationCode" ColumnName="ToLocationCode" />
|
<ScalarProperty Name="FinishedTime" ColumnName="FinishedTime" />
|
<ScalarProperty Name="Lane" ColumnName="Lane" />
|
<ScalarProperty Name="MoveFlag" ColumnName="MoveFlag" />
|
<ScalarProperty Name="MoveFromLocation" ColumnName="MoveFromLocation" />
|
<ScalarProperty Name="MoveToLocation" ColumnName="MoveToLocation" />
|
<ScalarProperty Name="MoveContainerCode" ColumnName="MoveContainerCode" />
|
<ScalarProperty Name="ContainerType" ColumnName="ContainerType" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="OperationRemark" ColumnName="OperationRemark" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_task_sub">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_task_sub">
|
<MappingFragment StoreEntitySet="ware_task_sub">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="OrderNo" ColumnName="OrderNo" />
|
<ScalarProperty Name="WCSTaskId" ColumnName="WCSTaskId" />
|
<ScalarProperty Name="TaskId" ColumnName="TaskId" />
|
<ScalarProperty Name="TaskNo" ColumnName="TaskNo" />
|
<ScalarProperty Name="TaskSequence" ColumnName="TaskSequence" />
|
<ScalarProperty Name="TaskDescribe" ColumnName="TaskDescribe" />
|
<ScalarProperty Name="TaskState" ColumnName="TaskState" />
|
<ScalarProperty Name="DeviceType" ColumnName="DeviceType" />
|
<ScalarProperty Name="DeviceId" ColumnName="DeviceId" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="TaskType" ColumnName="TaskType" />
|
<ScalarProperty Name="SourcePlace" ColumnName="SourcePlace" />
|
<ScalarProperty Name="FromLane" ColumnName="FromLane" />
|
<ScalarProperty Name="FromLayer" ColumnName="FromLayer" />
|
<ScalarProperty Name="FromRow" ColumnName="FromRow" />
|
<ScalarProperty Name="FromCol" ColumnName="FromCol" />
|
<ScalarProperty Name="ToPlace" ColumnName="ToPlace" />
|
<ScalarProperty Name="ToLane" ColumnName="ToLane" />
|
<ScalarProperty Name="ToLayer" ColumnName="ToLayer" />
|
<ScalarProperty Name="ToCol" ColumnName="ToCol" />
|
<ScalarProperty Name="ToRow" ColumnName="ToRow" />
|
<ScalarProperty Name="FinishedTime" ColumnName="FinishedTime" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="OperationRemark" ColumnName="OperationRemark" />
|
<ScalarProperty Name="ContainerType" ColumnName="ContainerType" />
|
<ScalarProperty Name="AgvTaskCode" ColumnName="AgvTaskCode" />
|
<ScalarProperty Name="AgvCode" ColumnName="AgvCode" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_task_sub_bak">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_task_sub_bak">
|
<MappingFragment StoreEntitySet="ware_task_sub_bak">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="OrderNo" ColumnName="OrderNo" />
|
<ScalarProperty Name="TaskId" ColumnName="TaskId" />
|
<ScalarProperty Name="TaskNo" ColumnName="TaskNo" />
|
<ScalarProperty Name="TaskSequence" ColumnName="TaskSequence" />
|
<ScalarProperty Name="TaskState" ColumnName="TaskState" />
|
<ScalarProperty Name="TaskDescribe" ColumnName="TaskDescribe" />
|
<ScalarProperty Name="DeviceType" ColumnName="DeviceType" />
|
<ScalarProperty Name="DeviceId" ColumnName="DeviceId" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="FromLane" ColumnName="FromLane" />
|
<ScalarProperty Name="FromLayer" ColumnName="FromLayer" />
|
<ScalarProperty Name="FromCol" ColumnName="FromCol" />
|
<ScalarProperty Name="FromRow" ColumnName="FromRow" />
|
<ScalarProperty Name="ToLane" ColumnName="ToLane" />
|
<ScalarProperty Name="ToLayer" ColumnName="ToLayer" />
|
<ScalarProperty Name="ToCol" ColumnName="ToCol" />
|
<ScalarProperty Name="ToRow" ColumnName="ToRow" />
|
<ScalarProperty Name="FinishedTime" ColumnName="FinishedTime" />
|
<ScalarProperty Name="ContainerType" ColumnName="ContainerType" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="SourcePlace" ColumnName="SourcePlace" />
|
<ScalarProperty Name="ToPlace" ColumnName="ToPlace" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_area">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_area">
|
<MappingFragment StoreEntitySet="wms_area">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="AreaName" ColumnName="AreaName" />
|
<ScalarProperty Name="AreaDesc" ColumnName="AreaDesc" />
|
<ScalarProperty Name="AreaStatus" ColumnName="AreaStatus" />
|
<ScalarProperty Name="AreaType" ColumnName="AreaType" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_container">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_container">
|
<MappingFragment StoreEntitySet="wms_container">
|
<ScalarProperty Name="RealLocationCode" ColumnName="RealLocationCode" />
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="ContainerType" ColumnName="ContainerType" />
|
<ScalarProperty Name="ContainerStatus" ColumnName="ContainerStatus" />
|
<ScalarProperty Name="SpecLength" ColumnName="SpecLength" />
|
<ScalarProperty Name="SpecWidth" ColumnName="SpecWidth" />
|
<ScalarProperty Name="SpecHeight" ColumnName="SpecHeight" />
|
<ScalarProperty Name="LimitLength" ColumnName="LimitLength" />
|
<ScalarProperty Name="LimitWidth" ColumnName="LimitWidth" />
|
<ScalarProperty Name="LimitHeight" ColumnName="LimitHeight" />
|
<ScalarProperty Name="MaxWeight" ColumnName="MaxWeight" />
|
<ScalarProperty Name="ParentContainerId" ColumnName="ParentContainerId" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="ContainerTypeCode" ColumnName="ContainerTypeCode" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_container_type">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_container_type">
|
<MappingFragment StoreEntitySet="wms_container_type">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="WareContainerTypeCode" ColumnName="WareContainerTypeCode" />
|
<ScalarProperty Name="WareContainerTypeName" ColumnName="WareContainerTypeName" />
|
<ScalarProperty Name="Length" ColumnName="Length" />
|
<ScalarProperty Name="Height" ColumnName="Height" />
|
<ScalarProperty Name="Width" ColumnName="Width" />
|
<ScalarProperty Name="LocationType" ColumnName="LocationType" />
|
<ScalarProperty Name="Remarks" ColumnName="Remarks" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="PLCTypeId" ColumnName="PLCTypeId" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_location_type">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_location_type">
|
<MappingFragment StoreEntitySet="wms_location_type">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="WareLocationTypeCode" ColumnName="WareLocationTypeCode" />
|
<ScalarProperty Name="WareLocationTypeName" ColumnName="WareLocationTypeName" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Length" ColumnName="Length" />
|
<ScalarProperty Name="Width" ColumnName="Width" />
|
<ScalarProperty Name="Height" ColumnName="Height" />
|
<ScalarProperty Name="MaxWeight" ColumnName="MaxWeight" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_material">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_material">
|
<MappingFragment StoreEntitySet="wms_material">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="MaterialName" ColumnName="MaterialName" />
|
<ScalarProperty Name="MaterialNo" ColumnName="MaterialNo" />
|
<ScalarProperty Name="MaterialBatch" ColumnName="MaterialBatch" />
|
<ScalarProperty Name="Description" ColumnName="Description" />
|
<ScalarProperty Name="InspectionMethod" ColumnName="InspectionMethod" />
|
<ScalarProperty Name="MaterialType" ColumnName="MaterialType" />
|
<ScalarProperty Name="MaterialSpec" ColumnName="MaterialSpec" />
|
<ScalarProperty Name="UnitType" ColumnName="UnitType" />
|
<ScalarProperty Name="UnitNo" ColumnName="UnitNo" />
|
<ScalarProperty Name="Safeqty" ColumnName="Safeqty" />
|
<ScalarProperty Name="Keymaterials" ColumnName="Keymaterials" />
|
<ScalarProperty Name="ErpNo" ColumnName="ErpNo" />
|
<ScalarProperty Name="GraphNo" ColumnName="GraphNo" />
|
<ScalarProperty Name="Qccategory" ColumnName="Qccategory" />
|
<ScalarProperty Name="Warranty" ColumnName="Warranty" />
|
<ScalarProperty Name="MaxImumqty" ColumnName="MaxImumqty" />
|
<ScalarProperty Name="MinstorageAge" ColumnName="MinstorageAge" />
|
<ScalarProperty Name="MaxstorageAge" ColumnName="MaxstorageAge" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="Height" ColumnName="Height" />
|
<ScalarProperty Name="Length" ColumnName="Length" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Width" ColumnName="Width" />
|
<ScalarProperty Name="WareContainerTypeCode" ColumnName="WareContainerTypeCode" />
|
<ScalarProperty Name="CarType" ColumnName="CarType" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_materialcontainer">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_materialcontainer">
|
<MappingFragment StoreEntitySet="wms_materialcontainer">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="ContainerId" ColumnName="ContainerId" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="MaterialName" ColumnName="MaterialName" />
|
<ScalarProperty Name="MaterialNo" ColumnName="MaterialNo" />
|
<ScalarProperty Name="MaterialBatch" ColumnName="MaterialBatch" />
|
<ScalarProperty Name="MaterialSpec" ColumnName="MaterialSpec" />
|
<ScalarProperty Name="MaterialId" ColumnName="MaterialId" />
|
<ScalarProperty Name="BindQuantity" ColumnName="BindQuantity" />
|
<ScalarProperty Name="BindStatus" ColumnName="BindStatus" />
|
<ScalarProperty Name="SampleQty" ColumnName="SampleQty" />
|
<ScalarProperty Name="OrderNo" ColumnName="OrderNo" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_materialstock">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_materialstock">
|
<MappingFragment StoreEntitySet="wms_materialstock">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="MaterialNo" ColumnName="MaterialNo" />
|
<ScalarProperty Name="MaterialType" ColumnName="MaterialType" />
|
<ScalarProperty Name="MaterialBatch" ColumnName="MaterialBatch" />
|
<ScalarProperty Name="MaterialName" ColumnName="MaterialName" />
|
<ScalarProperty Name="MaterialSpec" ColumnName="MaterialSpec" />
|
<ScalarProperty Name="InspectionMethod" ColumnName="InspectionMethod" />
|
<ScalarProperty Name="UnitType" ColumnName="UnitType" />
|
<ScalarProperty Name="UnitNo" ColumnName="UnitNo" />
|
<ScalarProperty Name="StockNumber" ColumnName="StockNumber" />
|
<ScalarProperty Name="PlaceCode" ColumnName="PlaceCode" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="AreaId" ColumnName="AreaId" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_part">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_part">
|
<MappingFragment StoreEntitySet="wms_part">
|
<ScalarProperty Name="CarType" ColumnName="CarType" />
|
<ScalarProperty Name="LineType" ColumnName="LineType" />
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="PartCode" ColumnName="PartCode" />
|
<ScalarProperty Name="PartName" ColumnName="PartName" />
|
<ScalarProperty Name="MaterialCode" ColumnName="MaterialCode" />
|
<ScalarProperty Name="Length" ColumnName="Length" />
|
<ScalarProperty Name="Width" ColumnName="Width" />
|
<ScalarProperty Name="Height" ColumnName="Height" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_place">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_place">
|
<MappingFragment StoreEntitySet="wms_place">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="PlaceCode" ColumnName="PlaceCode" />
|
<ScalarProperty Name="PlaceStatus" ColumnName="PlaceStatus" />
|
<ScalarProperty Name="AreaId" ColumnName="AreaId" />
|
<ScalarProperty Name="RowNo" ColumnName="RowNo" />
|
<ScalarProperty Name="ColumnNo" ColumnName="ColumnNo" />
|
<ScalarProperty Name="LayerNo" ColumnName="LayerNo" />
|
<ScalarProperty Name="DeepcellNo" ColumnName="DeepcellNo" />
|
<ScalarProperty Name="Aisle" ColumnName="Aisle" />
|
<ScalarProperty Name="Line" ColumnName="Line" />
|
<ScalarProperty Name="Islock" ColumnName="Islock" />
|
<ScalarProperty Name="EmptyContainer" ColumnName="EmptyContainer" />
|
<ScalarProperty Name="PositionnoForSrm" ColumnName="PositionnoForSrm" />
|
<ScalarProperty Name="Xzb" ColumnName="Xzb" />
|
<ScalarProperty Name="Yzb" ColumnName="Yzb" />
|
<ScalarProperty Name="Zzb" ColumnName="Zzb" />
|
<ScalarProperty Name="Length" ColumnName="Length" />
|
<ScalarProperty Name="Width" ColumnName="Width" />
|
<ScalarProperty Name="Height" ColumnName="Height" />
|
<ScalarProperty Name="MaxWeight" ColumnName="MaxWeight" />
|
<ScalarProperty Name="HeightLevel" ColumnName="HeightLevel" />
|
<ScalarProperty Name="Priority" ColumnName="Priority" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="WareLocationTypeCode" ColumnName="WareLocationTypeCode" />
|
<ScalarProperty Name="UnionCode" ColumnName="UnionCode" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="wms_task">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.wms_task">
|
<MappingFragment StoreEntitySet="wms_task">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="TaskNo" ColumnName="TaskNo" />
|
<ScalarProperty Name="TaskModel" ColumnName="TaskModel" />
|
<ScalarProperty Name="TaskType" ColumnName="TaskType" />
|
<ScalarProperty Name="TaskLevel" ColumnName="TaskLevel" />
|
<ScalarProperty Name="TaskStatus" ColumnName="TaskStatus" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="SourcePlace" ColumnName="SourcePlace" />
|
<ScalarProperty Name="ToPlace" ColumnName="ToPlace" />
|
<ScalarProperty Name="Aisle" ColumnName="Aisle" />
|
<ScalarProperty Name="AreaName" ColumnName="AreaName" />
|
<ScalarProperty Name="OrderNo" ColumnName="OrderNo" />
|
<ScalarProperty Name="SendTimes" ColumnName="SendTimes" />
|
<ScalarProperty Name="DodeviceId" ColumnName="DodeviceId" />
|
<ScalarProperty Name="DodevicenodeId" ColumnName="DodevicenodeId" />
|
<ScalarProperty Name="Dodevicetype" ColumnName="Dodevicetype" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_container_vs_material">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_container_vs_material">
|
<MappingFragment StoreEntitySet="ware_container_vs_material">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="WareContainerCode" ColumnName="WareContainerCode" />
|
<ScalarProperty Name="WareMaterialCode" ColumnName="WareMaterialCode" />
|
<ScalarProperty Name="Quantity" ColumnName="Quantity" />
|
<ScalarProperty Name="PurchaseNo" ColumnName="PurchaseNo" />
|
<ScalarProperty Name="DeliveryNo" ColumnName="DeliveryNo" />
|
<ScalarProperty Name="CollectNo" ColumnName="CollectNo" />
|
<ScalarProperty Name="OrdersNo" ColumnName="OrdersNo" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="IsLocked" ColumnName="IsLocked" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="Remarks" ColumnName="Remarks" />
|
<ScalarProperty Name="StockStatus" ColumnName="StockStatus" />
|
<ScalarProperty Name="Price" ColumnName="Price" />
|
<ScalarProperty Name="BarNo" ColumnName="BarNo" />
|
<ScalarProperty Name="OrderType" ColumnName="OrderType" />
|
<ScalarProperty Name="Unit" ColumnName="Unit" />
|
<ScalarProperty Name="WareMaterialName" ColumnName="WareMaterialName" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_location_vs_container">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_location_vs_container">
|
<MappingFragment StoreEntitySet="ware_location_vs_container">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="WareStorehouseCode" ColumnName="WareStorehouseCode" />
|
<ScalarProperty Name="WareRegionCode" ColumnName="WareRegionCode" />
|
<ScalarProperty Name="WareLocationCode" ColumnName="WareLocationCode" />
|
<ScalarProperty Name="WareContainerCode" ColumnName="WareContainerCode" />
|
<ScalarProperty Name="IsEmptyContainer" ColumnName="IsEmptyContainer" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="Remarks" ColumnName="Remarks" />
|
<ScalarProperty Name="Row" ColumnName="Row" />
|
<ScalarProperty Name="Lane" ColumnName="Lane" />
|
<ScalarProperty Name="LocTypeCode" ColumnName="LocTypeCode" />
|
<ScalarProperty Name="DeepcellNo" ColumnName="DeepcellNo" />
|
<ScalarProperty Name="UnionCode" ColumnName="UnionCode" />
|
<ScalarProperty Name="WareContainerName" ColumnName="WareContainerName" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_site">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_site">
|
<MappingFragment StoreEntitySet="ware_site">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Code" ColumnName="Code" />
|
<ScalarProperty Name="Describe" ColumnName="Describe" />
|
<ScalarProperty Name="Xcoordinate" ColumnName="Xcoordinate" />
|
<ScalarProperty Name="Ycoordinate" ColumnName="Ycoordinate" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="TenantId" ColumnName="TenantId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="SiteType" ColumnName="SiteType" />
|
<ScalarProperty Name="Lane" ColumnName="Lane" />
|
<ScalarProperty Name="OperationRemarks" ColumnName="OperationRemarks" />
|
<ScalarProperty Name="LineType" ColumnName="LineType" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_task">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_task">
|
<MappingFragment StoreEntitySet="ware_task">
|
<ScalarProperty Name="PartCode" ColumnName="PartCode" />
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="OrderNo" ColumnName="OrderNo" />
|
<ScalarProperty Name="TaskNo" ColumnName="TaskNo" />
|
<ScalarProperty Name="TaskName" ColumnName="TaskName" />
|
<ScalarProperty Name="TaskCategory" ColumnName="TaskCategory" />
|
<ScalarProperty Name="TaskType" ColumnName="TaskType" />
|
<ScalarProperty Name="TaskState" ColumnName="TaskState" />
|
<ScalarProperty Name="TaskDescribe" ColumnName="TaskDescribe" />
|
<ScalarProperty Name="TaskPriority" ColumnName="TaskPriority" />
|
<ScalarProperty Name="ContainerCode" ColumnName="ContainerCode" />
|
<ScalarProperty Name="FromLocationCode" ColumnName="FromLocationCode" />
|
<ScalarProperty Name="ToLocationCode" ColumnName="ToLocationCode" />
|
<ScalarProperty Name="FinishedTime" ColumnName="FinishedTime" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="Lane" ColumnName="Lane" />
|
<ScalarProperty Name="MoveFlag" ColumnName="MoveFlag" />
|
<ScalarProperty Name="MoveFromLocation" ColumnName="MoveFromLocation" />
|
<ScalarProperty Name="MoveToLocation" ColumnName="MoveToLocation" />
|
<ScalarProperty Name="MoveContainerCode" ColumnName="MoveContainerCode" />
|
<ScalarProperty Name="ContainerType" ColumnName="ContainerType" />
|
<ScalarProperty Name="OperationRemark" ColumnName="OperationRemark" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="v_empty_location">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.v_empty_location">
|
<MappingFragment StoreEntitySet="v_empty_location">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="PlaceCode" ColumnName="PlaceCode" />
|
<ScalarProperty Name="PlaceStatus" ColumnName="PlaceStatus" />
|
<ScalarProperty Name="AreaId" ColumnName="AreaId" />
|
<ScalarProperty Name="RowNo" ColumnName="RowNo" />
|
<ScalarProperty Name="ColumnNo" ColumnName="ColumnNo" />
|
<ScalarProperty Name="LayerNo" ColumnName="LayerNo" />
|
<ScalarProperty Name="DeepcellNo" ColumnName="DeepcellNo" />
|
<ScalarProperty Name="Aisle" ColumnName="Aisle" />
|
<ScalarProperty Name="Line" ColumnName="Line" />
|
<ScalarProperty Name="Islock" ColumnName="Islock" />
|
<ScalarProperty Name="EmptyContainer" ColumnName="EmptyContainer" />
|
<ScalarProperty Name="PositionnoForSrm" ColumnName="PositionnoForSrm" />
|
<ScalarProperty Name="Xzb" ColumnName="Xzb" />
|
<ScalarProperty Name="Yzb" ColumnName="Yzb" />
|
<ScalarProperty Name="Zzb" ColumnName="Zzb" />
|
<ScalarProperty Name="Length" ColumnName="Length" />
|
<ScalarProperty Name="Width" ColumnName="Width" />
|
<ScalarProperty Name="Height" ColumnName="Height" />
|
<ScalarProperty Name="MaxWeight" ColumnName="MaxWeight" />
|
<ScalarProperty Name="HeightLevel" ColumnName="HeightLevel" />
|
<ScalarProperty Name="Priority" ColumnName="Priority" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="WareLocationTypeCode" ColumnName="WareLocationTypeCode" />
|
<ScalarProperty Name="UnionCode" ColumnName="UnionCode" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<AssociationSetMapping Name="sys_emp_pos" TypeName="LA22A07_QYModel.sys_emp_pos" StoreEntitySet="sys_emp_pos">
|
<EndProperty Name="sys_emp">
|
<ScalarProperty Name="Id" ColumnName="SysEmpId" />
|
</EndProperty>
|
<EndProperty Name="sys_pos">
|
<ScalarProperty Name="Id" ColumnName="SysPosId" />
|
</EndProperty>
|
</AssociationSetMapping>
|
<AssociationSetMapping Name="sys_role_data_scope" TypeName="LA22A07_QYModel.sys_role_data_scope" StoreEntitySet="sys_role_data_scope">
|
<EndProperty Name="sys_org">
|
<ScalarProperty Name="Id" ColumnName="SysOrgId" />
|
</EndProperty>
|
<EndProperty Name="sys_role">
|
<ScalarProperty Name="Id" ColumnName="SysRoleId" />
|
</EndProperty>
|
</AssociationSetMapping>
|
<AssociationSetMapping Name="sys_user_data_scope" TypeName="LA22A07_QYModel.sys_user_data_scope" StoreEntitySet="sys_user_data_scope">
|
<EndProperty Name="sys_org">
|
<ScalarProperty Name="Id" ColumnName="SysOrgId" />
|
</EndProperty>
|
<EndProperty Name="sys_user">
|
<ScalarProperty Name="Id" ColumnName="SysUserId" />
|
</EndProperty>
|
</AssociationSetMapping>
|
<AssociationSetMapping Name="sys_user_role" TypeName="LA22A07_QYModel.sys_user_role" StoreEntitySet="sys_user_role">
|
<EndProperty Name="sys_role">
|
<ScalarProperty Name="Id" ColumnName="SysRoleId" />
|
</EndProperty>
|
<EndProperty Name="sys_user">
|
<ScalarProperty Name="Id" ColumnName="SysUserId" />
|
</EndProperty>
|
</AssociationSetMapping>
|
<AssociationSetMapping Name="sys_role_menu" TypeName="LA22A07_QYModel.sys_role_menu" StoreEntitySet="sys_role_menu">
|
<EndProperty Name="sys_menu">
|
<ScalarProperty Name="Id" ColumnName="SysMenuId" />
|
</EndProperty>
|
<EndProperty Name="sys_role">
|
<ScalarProperty Name="Id" ColumnName="SysRoleId" />
|
</EndProperty>
|
</AssociationSetMapping>
|
<EntitySetMapping Name="ware_device_wareing">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_device_wareing">
|
<MappingFragment StoreEntitySet="ware_device_wareing">
|
<ScalarProperty Name="IDD" ColumnName="IDD" />
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="DeviceTypeName" ColumnName="DeviceTypeName" />
|
<ScalarProperty Name="DeviceType" ColumnName="DeviceType" />
|
<ScalarProperty Name="OperationRemark" ColumnName="OperationRemark" />
|
<ScalarProperty Name="DurationTime" ColumnName="DurationTime" />
|
<ScalarProperty Name="FinishTime" ColumnName="FinishTime" />
|
<ScalarProperty Name="CloseContent" ColumnName="CloseContent" />
|
<ScalarProperty Name="StatusName" ColumnName="StatusName" />
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
<ScalarProperty Name="WarningContent" ColumnName="WarningContent" />
|
<ScalarProperty Name="WarningDbAddress" ColumnName="WarningDbAddress" />
|
<ScalarProperty Name="WarningCode" ColumnName="WarningCode" />
|
<ScalarProperty Name="DeviceName" ColumnName="DeviceName" />
|
<ScalarProperty Name="DeviceCode" ColumnName="DeviceCode" />
|
<ScalarProperty Name="WarningTime" ColumnName="WarningTime" />
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ware_equipment">
|
<EntityTypeMapping TypeName="LA22A07_QYModel.ware_equipment">
|
<MappingFragment StoreEntitySet="ware_equipment">
|
<ScalarProperty Name="IsDeleted" ColumnName="IsDeleted" />
|
<ScalarProperty Name="UpdatedUserId" ColumnName="UpdatedUserId" />
|
<ScalarProperty Name="UpdatedUserName" ColumnName="UpdatedUserName" />
|
<ScalarProperty Name="CreatedUserName" ColumnName="CreatedUserName" />
|
<ScalarProperty Name="CreatedUserId" ColumnName="CreatedUserId" />
|
<ScalarProperty Name="UpdatedTime" ColumnName="UpdatedTime" />
|
<ScalarProperty Name="CreatedTime" ColumnName="CreatedTime" />
|
<ScalarProperty Name="CoordinateX" ColumnName="CoordinateX" />
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
</EntityContainerMapping>
|
</Mapping>
|
</edmx:Mappings>
|
</edmx:Runtime>
|
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
|
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
|
<Connection>
|
<DesignerInfoPropertySet>
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
</DesignerInfoPropertySet>
|
</Connection>
|
<Options>
|
<DesignerInfoPropertySet>
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
<DesignerProperty Name="EnablePluralization" Value="false" />
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
|
<DesignerProperty Name="UseLegacyProvider" Value="false" />
|
<DesignerProperty Name="CodeGenerationStrategy" Value="无" />
|
</DesignerInfoPropertySet>
|
</Options>
|
<!-- Diagram content (shape and connector positions) -->
|
<Diagrams></Diagrams>
|
</Designer>
|
</edmx:Edmx>
|
