<?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="sbcLabSystemModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
|
<EntityType Name="__MigrationHistory">
|
<Key>
|
<PropertyRef Name="MigrationId" />
|
<PropertyRef Name="ContextKey" />
|
</Key>
|
<Property Name="MigrationId" Type="nvarchar" MaxLength="150" Nullable="false" />
|
<Property Name="ContextKey" Type="nvarchar" MaxLength="300" Nullable="false" />
|
<Property Name="Model" Type="varbinary(max)" Nullable="false" />
|
<Property Name="ProductVersion" Type="nvarchar" MaxLength="32" Nullable="false" />
|
</EntityType>
|
<EntityType Name="ApprovalInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="FieldName" Type="nvarchar(max)" />
|
<Property Name="FieldValue" Type="nvarchar(max)" />
|
<Property Name="Score" Type="float" Nullable="false" />
|
<Property Name="QCDistributionID" Type="int" Nullable="false" />
|
<Property Name="FieldDescription" Type="nvarchar(max)" />
|
<Property Name="FieldPatient" Type="nvarchar(max)" />
|
<Property Name="IsComplex" Type="bit" Nullable="false" />
|
<Property Name="ElementNameInHtml" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="EmailSmtpInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Host" Type="nvarchar(max)" />
|
<Property Name="UserEmail" Type="nvarchar(max)" />
|
<Property Name="Password" Type="nvarchar(max)" />
|
<Property Name="IsEnableSSL" Type="bit" Nullable="false" />
|
<Property Name="SSLPort" Type="int" Nullable="false" />
|
<Property Name="ConfigureName" Type="nvarchar(max)" />
|
<Property Name="IsDefault" Type="bit" Nullable="false" />
|
</EntityType>
|
<EntityType Name="EmileInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Type" Type="int" Nullable="false" />
|
<Property Name="Explain" Type="nvarchar(max)" />
|
<Property Name="Title" Type="nvarchar(max)" />
|
<Property Name="Boody" Type="nvarchar(max)" />
|
<Property Name="EmileName" Type="nvarchar(max)" />
|
<Property Name="SendOutDatetime" Type="datetime" Nullable="false" />
|
<Property Name="Column1" Type="nvarchar(max)" />
|
<Property Name="Column2" Type="nvarchar(max)" />
|
<Property Name="Column3" Type="nvarchar(max)" />
|
<Property Name="EmileState" Type="int" Nullable="false" />
|
<Property Name="EmileNews" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="Menus">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Name" Type="nvarchar(max)" />
|
<Property Name="Url" Type="nvarchar(max)" />
|
<Property Name="Category" Type="nvarchar(max)" />
|
<Property Name="Contents" Type="nvarchar(max)" />
|
<Property Name="ParnetId" Type="nvarchar(max)" />
|
<Property Name="Time" Type="datetime" Nullable="false" />
|
<Property Name="Title" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="QCDistributionRegisterInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="IsCharged" Type="bit" Nullable="false" />
|
<Property Name="QCDistributionId" Type="int" Nullable="false" />
|
<Property Name="ProjectId" Type="int" Nullable="false" />
|
<Property Name="SampleNo" Type="nvarchar(max)" />
|
<Property Name="IsSendEMS" Type="bit" Nullable="false" />
|
<Property Name="EMSNo" Type="nvarchar(max)" />
|
<Property Name="PacketContent" Type="nvarchar(max)" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
<Property Name="ModifyUser" Type="nvarchar(max)" />
|
<Property Name="ModifyTime" Type="datetime" Nullable="false" />
|
<Property Name="LabId" Type="int" Nullable="false" />
|
<Property Name="IsModified" Type="bit" Nullable="false" />
|
<Property Name="IsSubmit" Type="bit" Nullable="false" />
|
<Property Name="IsEnding" Type="bit" Nullable="false" />
|
<Property Name="AnswerJSON" Type="nvarchar(max)" />
|
<Property Name="SubmitTime" Type="datetime" />
|
<Property Name="SubmitUserNo" Type="nvarchar(max)" />
|
<Property Name="FirstTimeSubmitTime" Type="datetime" />
|
<Property Name="LastPageModifyTime" Type="datetime" />
|
<Property Name="LetterNo" Type="nvarchar(max)" />
|
<Property Name="ChargeRemark" Type="nvarchar(max)" />
|
<Property Name="ChargeTime" Type="datetime" />
|
<Property Name="SendEMSTime" Type="datetime" />
|
<Property Name="Score_Detail" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="QCDistributions">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="DistNo" Type="nvarchar(max)" />
|
<Property Name="IssuedDate" Type="datetime" />
|
<Property Name="CloseDate" Type="datetime" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
<Property Name="ModifyDate" Type="datetime" />
|
<Property Name="AnswerJSON" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="ResourceInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="ResourceNo" Type="nvarchar(max)" />
|
<Property Name="ResourceName" Type="nvarchar(max)" />
|
<Property Name="ParentResourceNo" Type="nvarchar(max)" />
|
<Property Name="Url" Type="nvarchar(max)" />
|
<Property Name="Order" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="RoleInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="RoleName" Type="nvarchar(max)" />
|
<Property Name="RoleDescription" Type="nvarchar(max)" />
|
<Property Name="Privilege" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="RoleInfoResourceInfoes">
|
<Key>
|
<PropertyRef Name="RoleInfo_Id" />
|
<PropertyRef Name="ResourceInfo_Id" />
|
</Key>
|
<Property Name="RoleInfo_Id" Type="int" Nullable="false" />
|
<Property Name="ResourceInfo_Id" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="ScheduleTasks">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="Name" Type="nvarchar(max)" />
|
<Property Name="Seconds" Type="int" Nullable="false" />
|
<Property Name="Type" Type="nvarchar(max)" />
|
<Property Name="Enabled" Type="bit" Nullable="false" />
|
<Property Name="StopOnError" Type="bit" Nullable="false" />
|
<Property Name="LastStartUtc" Type="datetime" />
|
<Property Name="LastEndUtc" Type="datetime" />
|
<Property Name="LastSuccessUtc" Type="datetime" />
|
</EntityType>
|
<EntityType Name="StandAnswerInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="ProjectId" Type="int" Nullable="false" />
|
<Property Name="AnswerData" Type="nvarchar(max)" />
|
<Property Name="ABO_RhD_FirstPatient" Type="bit" Nullable="false" />
|
<Property Name="CrossMatch_W_FirstPatient" Type="bit" Nullable="false" />
|
<Property Name="AntibodyScreening_FirstPatient" Type="bit" Nullable="false" />
|
<Property Name="AntibodyIdentification_FirstPatient" Type="bit" Nullable="false" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="AdminID" Type="int" Nullable="false" />
|
<Property Name="UpdateDate" Type="datetime" />
|
<Property Name="IsRead" Type="bit" Nullable="false" />
|
<Property Name="ABO_RhD_SecPatient" Type="int" Nullable="false" />
|
<Property Name="ABO_RhD_ThdPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_W_SecPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_W_ThdPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_Y_FirstPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_Y_SecPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_Y_ThdPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_Z_FirstPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_Z_SecPatient" Type="int" Nullable="false" />
|
<Property Name="CrossMatch_Z_ThdPatient" Type="int" Nullable="false" />
|
<Property Name="AntibodyScreening_SecPatient" Type="int" Nullable="false" />
|
<Property Name="AntibodyScreening_ThdPatient" Type="int" Nullable="false" />
|
<Property Name="AntibodyIdentification_SecPatient" Type="int" Nullable="false" />
|
<Property Name="AntibodyIdentification_ThdPatient" Type="int" Nullable="false" />
|
<Property Name="QCDistInfoId" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="UserInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="UserNo" Type="nvarchar(max)" />
|
<Property Name="UserName" Type="nvarchar(max)" />
|
<Property Name="Email" Type="nvarchar(max)" />
|
<Property Name="IsUse" Type="int" Nullable="false" />
|
<Property Name="Password" Type="nvarchar(max)" />
|
<Property Name="CurrentEnvirnoment" Type="nvarchar(max)" />
|
<Property Name="ModifiedTime" Type="datetime" Nullable="false" />
|
<Property Name="Barcode" Type="nvarchar(max)" />
|
<Property Name="Remark" Type="nvarchar(max)" />
|
</EntityType>
|
<EntityType Name="UserInfoRoleInfoes">
|
<Key>
|
<PropertyRef Name="UserInfo_Id" />
|
<PropertyRef Name="RoleInfo_Id" />
|
</Key>
|
<Property Name="UserInfo_Id" Type="int" Nullable="false" />
|
<Property Name="RoleInfo_Id" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="UserRequestInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="CompanyName" Type="nvarchar(max)" />
|
<Property Name="LabName" Type="nvarchar(max)" />
|
<Property Name="Address" Type="nvarchar(max)" />
|
<Property Name="Province" Type="nvarchar(max)" />
|
<Property Name="City" Type="nvarchar(max)" />
|
<Property Name="District" Type="nvarchar(max)" />
|
<Property Name="PostCode" Type="nvarchar(max)" />
|
<Property Name="ManagerName" Type="nvarchar(max)" />
|
<Property Name="ManagerPhone" Type="nvarchar(max)" />
|
<Property Name="ManagerFax" Type="nvarchar(max)" />
|
<Property Name="ManagerMobile" Type="nvarchar(max)" />
|
<Property Name="ManagerEmail" Type="nvarchar(max)" />
|
<Property Name="OperatorName" Type="nvarchar(max)" />
|
<Property Name="OperatorPhone" Type="nvarchar(max)" />
|
<Property Name="OperatorFax" Type="nvarchar(max)" />
|
<Property Name="OperatorMobile" Type="nvarchar(max)" />
|
<Property Name="OperatorEmail" Type="nvarchar(max)" />
|
<Property Name="ProjectId" Type="int" Nullable="false" />
|
<Property Name="RequestTime" Type="datetime" Nullable="false" />
|
<Property Name="UpdateTime" Type="datetime" Nullable="false" />
|
<Property Name="State" Type="int" Nullable="false" />
|
<Property Name="LabCode" Type="nvarchar(max)" />
|
<Property Name="LabLoginName" Type="nvarchar(max)" />
|
<Property Name="LabPassword" Type="nvarchar(max)" />
|
<Property Name="Remarks" Type="nvarchar(max)" />
|
</EntityType>
|
<Association Name="FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId">
|
<End Role="QCDistributions" Type="Self.QCDistributions" Multiplicity="1" />
|
<End Role="QCDistributionRegisterInfoes" Type="Self.QCDistributionRegisterInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="QCDistributions">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="QCDistributionRegisterInfoes">
|
<PropertyRef Name="QCDistributionId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId">
|
<End Role="UserRequestInfoes" Type="Self.UserRequestInfoes" Multiplicity="1" />
|
<End Role="QCDistributionRegisterInfoes" Type="Self.QCDistributionRegisterInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="UserRequestInfoes">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="QCDistributionRegisterInfoes">
|
<PropertyRef Name="LabId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_RoleInfoResourceInfoes_dbo_ResourceInfoes_ResourceInfo_Id">
|
<End Role="ResourceInfoes" Type="Self.ResourceInfoes" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="RoleInfoResourceInfoes" Type="Self.RoleInfoResourceInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="ResourceInfoes">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="RoleInfoResourceInfoes">
|
<PropertyRef Name="ResourceInfo_Id" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_RoleInfoResourceInfoes_dbo_RoleInfoes_RoleInfo_Id">
|
<End Role="RoleInfoes" Type="Self.RoleInfoes" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="RoleInfoResourceInfoes" Type="Self.RoleInfoResourceInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="RoleInfoes">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="RoleInfoResourceInfoes">
|
<PropertyRef Name="RoleInfo_Id" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId">
|
<End Role="QCDistributions" Type="Self.QCDistributions" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="StandAnswerInfoes" Type="Self.StandAnswerInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="QCDistributions">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="StandAnswerInfoes">
|
<PropertyRef Name="QCDistInfoId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_UserInfoRoleInfoes_dbo_RoleInfoes_RoleInfo_Id">
|
<End Role="RoleInfoes" Type="Self.RoleInfoes" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="UserInfoRoleInfoes" Type="Self.UserInfoRoleInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="RoleInfoes">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="UserInfoRoleInfoes">
|
<PropertyRef Name="RoleInfo_Id" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_UserInfoRoleInfoes_dbo_UserInfoes_UserInfo_Id">
|
<End Role="UserInfoes" Type="Self.UserInfoes" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="UserInfoRoleInfoes" Type="Self.UserInfoRoleInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="UserInfoes">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="UserInfoRoleInfoes">
|
<PropertyRef Name="UserInfo_Id" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<EntityContainer Name="sbcLabSystemModelStoreContainer">
|
<EntitySet Name="__MigrationHistory" EntityType="Self.__MigrationHistory" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ApprovalInfoes" EntityType="Self.ApprovalInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="EmailSmtpInfoes" EntityType="Self.EmailSmtpInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="EmileInfoes" EntityType="Self.EmileInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Menus" EntityType="Self.Menus" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="QCDistributionRegisterInfoes" EntityType="Self.QCDistributionRegisterInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="QCDistributions" EntityType="Self.QCDistributions" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ResourceInfoes" EntityType="Self.ResourceInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="RoleInfoes" EntityType="Self.RoleInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="RoleInfoResourceInfoes" EntityType="Self.RoleInfoResourceInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="ScheduleTasks" EntityType="Self.ScheduleTasks" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="StandAnswerInfoes" EntityType="Self.StandAnswerInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="UserInfoes" EntityType="Self.UserInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="UserInfoRoleInfoes" EntityType="Self.UserInfoRoleInfoes" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="UserRequestInfoes" EntityType="Self.UserRequestInfoes" Schema="dbo" store:Type="Tables" />
|
<AssociationSet Name="FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId" Association="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId">
|
<End Role="QCDistributions" EntitySet="QCDistributions" />
|
<End Role="QCDistributionRegisterInfoes" EntitySet="QCDistributionRegisterInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId" Association="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId">
|
<End Role="UserRequestInfoes" EntitySet="UserRequestInfoes" />
|
<End Role="QCDistributionRegisterInfoes" EntitySet="QCDistributionRegisterInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_RoleInfoResourceInfoes_dbo_ResourceInfoes_ResourceInfo_Id" Association="Self.FK_dbo_RoleInfoResourceInfoes_dbo_ResourceInfoes_ResourceInfo_Id">
|
<End Role="ResourceInfoes" EntitySet="ResourceInfoes" />
|
<End Role="RoleInfoResourceInfoes" EntitySet="RoleInfoResourceInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_RoleInfoResourceInfoes_dbo_RoleInfoes_RoleInfo_Id" Association="Self.FK_dbo_RoleInfoResourceInfoes_dbo_RoleInfoes_RoleInfo_Id">
|
<End Role="RoleInfoes" EntitySet="RoleInfoes" />
|
<End Role="RoleInfoResourceInfoes" EntitySet="RoleInfoResourceInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId" Association="Self.FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId">
|
<End Role="QCDistributions" EntitySet="QCDistributions" />
|
<End Role="StandAnswerInfoes" EntitySet="StandAnswerInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_UserInfoRoleInfoes_dbo_RoleInfoes_RoleInfo_Id" Association="Self.FK_dbo_UserInfoRoleInfoes_dbo_RoleInfoes_RoleInfo_Id">
|
<End Role="RoleInfoes" EntitySet="RoleInfoes" />
|
<End Role="UserInfoRoleInfoes" EntitySet="UserInfoRoleInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_UserInfoRoleInfoes_dbo_UserInfoes_UserInfo_Id" Association="Self.FK_dbo_UserInfoRoleInfoes_dbo_UserInfoes_UserInfo_Id">
|
<End Role="UserInfoes" EntitySet="UserInfoes" />
|
<End Role="UserInfoRoleInfoes" EntitySet="UserInfoRoleInfoes" />
|
</AssociationSet>
|
</EntityContainer>
|
</Schema>
|
</edmx:StorageModels>
|
<!-- CSDL content -->
|
<edmx:ConceptualModels>
|
<Schema Namespace="sbcLabSystemModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
<EntityType Name="C__MigrationHistory">
|
<Key>
|
<PropertyRef Name="MigrationId" />
|
<PropertyRef Name="ContextKey" />
|
</Key>
|
<Property Name="MigrationId" Type="String" MaxLength="150" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="ContextKey" Type="String" MaxLength="300" FixedLength="false" Unicode="true" Nullable="false" />
|
<Property Name="Model" Type="Binary" MaxLength="Max" FixedLength="false" Nullable="false" />
|
<Property Name="ProductVersion" Type="String" MaxLength="32" FixedLength="false" Unicode="true" Nullable="false" />
|
</EntityType>
|
<EntityType Name="ApprovalInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="FieldName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="FieldValue" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Score" Type="Double" Nullable="false" />
|
<Property Name="QCDistributionID" Type="Int32" Nullable="false" />
|
<Property Name="FieldDescription" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="FieldPatient" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="IsComplex" Type="Boolean" Nullable="false" />
|
<Property Name="ElementNameInHtml" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
</EntityType>
|
<EntityType Name="EmailSmtpInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Host" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="UserEmail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Password" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="IsEnableSSL" Type="Boolean" Nullable="false" />
|
<Property Name="SSLPort" Type="Int32" Nullable="false" />
|
<Property Name="ConfigureName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="IsDefault" Type="Boolean" Nullable="false" />
|
</EntityType>
|
<EntityType Name="EmileInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Type" Type="Int32" Nullable="false" />
|
<Property Name="Explain" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Title" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Boody" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="EmileName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="SendOutDatetime" Type="DateTime" Nullable="false" Precision="3" />
|
<Property Name="Column1" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Column2" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Column3" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="EmileState" Type="Int32" Nullable="false" />
|
<Property Name="EmileNews" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
</EntityType>
|
<EntityType Name="Menus">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Name" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Url" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Category" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Contents" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ParnetId" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Time" Type="DateTime" Nullable="false" Precision="3" />
|
<Property Name="Title" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
</EntityType>
|
<EntityType Name="QCDistributionRegisterInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="IsCharged" Type="Boolean" Nullable="false" />
|
<Property Name="QCDistributionId" Type="Int32" Nullable="false" />
|
<Property Name="ProjectId" Type="Int32" Nullable="false" />
|
<Property Name="SampleNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="IsSendEMS" Type="Boolean" Nullable="false" />
|
<Property Name="EMSNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="PacketContent" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Remark" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ModifyUser" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ModifyTime" Type="DateTime" Nullable="false" Precision="3" />
|
<Property Name="LabId" Type="Int32" Nullable="false" />
|
<Property Name="IsModified" Type="Boolean" Nullable="false" />
|
<Property Name="IsSubmit" Type="Boolean" Nullable="false" />
|
<Property Name="IsEnding" Type="Boolean" Nullable="false" />
|
<Property Name="AnswerJSON" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="SubmitTime" Type="DateTime" Precision="3" />
|
<Property Name="SubmitUserNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="FirstTimeSubmitTime" Type="DateTime" Precision="3" />
|
<Property Name="LastPageModifyTime" Type="DateTime" Precision="3" />
|
<Property Name="LetterNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ChargeRemark" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ChargeTime" Type="DateTime" Precision="3" />
|
<Property Name="SendEMSTime" Type="DateTime" Precision="3" />
|
<Property Name="Score_Detail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<NavigationProperty Name="QCDistributions" Relationship="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId" FromRole="QCDistributionRegisterInfoes" ToRole="QCDistributions" />
|
<NavigationProperty Name="UserRequestInfoes" Relationship="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId" FromRole="QCDistributionRegisterInfoes" ToRole="UserRequestInfoes" />
|
</EntityType>
|
<EntityType Name="QCDistributions">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="DistNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="IssuedDate" Type="DateTime" Precision="3" />
|
<Property Name="CloseDate" Type="DateTime" Precision="3" />
|
<Property Name="Remark" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ModifyDate" Type="DateTime" Precision="3" />
|
<Property Name="AnswerJSON" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<NavigationProperty Name="QCDistributionRegisterInfoes" Relationship="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId" FromRole="QCDistributions" ToRole="QCDistributionRegisterInfoes" />
|
<NavigationProperty Name="StandAnswerInfoes" Relationship="Self.FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId" FromRole="QCDistributions" ToRole="StandAnswerInfoes" />
|
</EntityType>
|
<EntityType Name="ResourceInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="ResourceNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ResourceName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ParentResourceNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Url" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Order" Type="Int32" Nullable="false" />
|
<NavigationProperty Name="RoleInfoes" Relationship="Self.RoleInfoResourceInfoes" FromRole="ResourceInfoes" ToRole="RoleInfoes" />
|
</EntityType>
|
<EntityType Name="RoleInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="RoleName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="RoleDescription" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Privilege" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<NavigationProperty Name="ResourceInfoes" Relationship="Self.RoleInfoResourceInfoes" FromRole="RoleInfoes" ToRole="ResourceInfoes" />
|
<NavigationProperty Name="UserInfoes" Relationship="Self.UserInfoRoleInfoes" FromRole="RoleInfoes" ToRole="UserInfoes" />
|
</EntityType>
|
<EntityType Name="ScheduleTasks">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="Name" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Seconds" Type="Int32" Nullable="false" />
|
<Property Name="Type" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Enabled" Type="Boolean" Nullable="false" />
|
<Property Name="StopOnError" Type="Boolean" Nullable="false" />
|
<Property Name="LastStartUtc" Type="DateTime" Precision="3" />
|
<Property Name="LastEndUtc" Type="DateTime" Precision="3" />
|
<Property Name="LastSuccessUtc" Type="DateTime" Precision="3" />
|
</EntityType>
|
<EntityType Name="StandAnswerInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="ProjectId" Type="Int32" Nullable="false" />
|
<Property Name="AnswerData" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ABO_RhD_FirstPatient" Type="Boolean" Nullable="false" />
|
<Property Name="CrossMatch_W_FirstPatient" Type="Boolean" Nullable="false" />
|
<Property Name="AntibodyScreening_FirstPatient" Type="Boolean" Nullable="false" />
|
<Property Name="AntibodyIdentification_FirstPatient" Type="Boolean" Nullable="false" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="AdminID" Type="Int32" Nullable="false" />
|
<Property Name="UpdateDate" Type="DateTime" Precision="3" />
|
<Property Name="IsRead" Type="Boolean" Nullable="false" />
|
<Property Name="ABO_RhD_SecPatient" Type="Int32" Nullable="false" />
|
<Property Name="ABO_RhD_ThdPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_W_SecPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_W_ThdPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_Y_FirstPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_Y_SecPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_Y_ThdPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_Z_FirstPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_Z_SecPatient" Type="Int32" Nullable="false" />
|
<Property Name="CrossMatch_Z_ThdPatient" Type="Int32" Nullable="false" />
|
<Property Name="AntibodyScreening_SecPatient" Type="Int32" Nullable="false" />
|
<Property Name="AntibodyScreening_ThdPatient" Type="Int32" Nullable="false" />
|
<Property Name="AntibodyIdentification_SecPatient" Type="Int32" Nullable="false" />
|
<Property Name="AntibodyIdentification_ThdPatient" Type="Int32" Nullable="false" />
|
<Property Name="QCDistInfoId" Type="Int32" Nullable="false" />
|
<NavigationProperty Name="QCDistributions" Relationship="Self.FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId" FromRole="StandAnswerInfoes" ToRole="QCDistributions" />
|
</EntityType>
|
<EntityType Name="UserInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="UserNo" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="UserName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Email" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="IsUse" Type="Int32" Nullable="false" />
|
<Property Name="Password" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="CurrentEnvirnoment" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ModifiedTime" Type="DateTime" Nullable="false" Precision="3" />
|
<Property Name="Barcode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Remark" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<NavigationProperty Name="RoleInfoes" Relationship="Self.UserInfoRoleInfoes" FromRole="UserInfoes" ToRole="RoleInfoes" />
|
</EntityType>
|
<EntityType Name="UserRequestInfoes">
|
<Key>
|
<PropertyRef Name="Id" />
|
</Key>
|
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="CompanyName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="LabName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Address" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Province" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="City" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="District" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="PostCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ManagerName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ManagerPhone" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ManagerFax" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ManagerMobile" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ManagerEmail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="OperatorName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="OperatorPhone" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="OperatorFax" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="OperatorMobile" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="OperatorEmail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="ProjectId" Type="Int32" Nullable="false" />
|
<Property Name="RequestTime" Type="DateTime" Nullable="false" Precision="3" />
|
<Property Name="UpdateTime" Type="DateTime" Nullable="false" Precision="3" />
|
<Property Name="State" Type="Int32" Nullable="false" />
|
<Property Name="LabCode" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="LabLoginName" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="LabPassword" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<Property Name="Remarks" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
<NavigationProperty Name="QCDistributionRegisterInfoes" Relationship="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId" FromRole="UserRequestInfoes" ToRole="QCDistributionRegisterInfoes" />
|
</EntityType>
|
<Association Name="FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId">
|
<End Role="QCDistributions" Type="Self.QCDistributions" Multiplicity="1" />
|
<End Role="QCDistributionRegisterInfoes" Type="Self.QCDistributionRegisterInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="QCDistributions">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="QCDistributionRegisterInfoes">
|
<PropertyRef Name="QCDistributionId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId">
|
<End Role="UserRequestInfoes" Type="Self.UserRequestInfoes" Multiplicity="1" />
|
<End Role="QCDistributionRegisterInfoes" Type="Self.QCDistributionRegisterInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="UserRequestInfoes">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="QCDistributionRegisterInfoes">
|
<PropertyRef Name="LabId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId">
|
<End Role="QCDistributions" Type="Self.QCDistributions" Multiplicity="1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="StandAnswerInfoes" Type="Self.StandAnswerInfoes" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="QCDistributions">
|
<PropertyRef Name="Id" />
|
</Principal>
|
<Dependent Role="StandAnswerInfoes">
|
<PropertyRef Name="QCDistInfoId" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="RoleInfoResourceInfoes">
|
<End Role="ResourceInfoes" Type="Self.ResourceInfoes" Multiplicity="*" />
|
<End Role="RoleInfoes" Type="Self.RoleInfoes" Multiplicity="*" />
|
</Association>
|
<Association Name="UserInfoRoleInfoes">
|
<End Role="RoleInfoes" Type="Self.RoleInfoes" Multiplicity="*" />
|
<End Role="UserInfoes" Type="Self.UserInfoes" Multiplicity="*" />
|
</Association>
|
<EntityContainer Name="sbcLabSystemEntities" annotation:LazyLoadingEnabled="true">
|
<EntitySet Name="C__MigrationHistory" EntityType="Self.C__MigrationHistory" />
|
<EntitySet Name="ApprovalInfoes" EntityType="Self.ApprovalInfoes" />
|
<EntitySet Name="EmailSmtpInfoes" EntityType="Self.EmailSmtpInfoes" />
|
<EntitySet Name="EmileInfoes" EntityType="Self.EmileInfoes" />
|
<EntitySet Name="Menus" EntityType="Self.Menus" />
|
<EntitySet Name="QCDistributionRegisterInfoes" EntityType="Self.QCDistributionRegisterInfoes" />
|
<EntitySet Name="QCDistributions" EntityType="Self.QCDistributions" />
|
<EntitySet Name="ResourceInfoes" EntityType="Self.ResourceInfoes" />
|
<EntitySet Name="RoleInfoes" EntityType="Self.RoleInfoes" />
|
<EntitySet Name="ScheduleTasks" EntityType="Self.ScheduleTasks" />
|
<EntitySet Name="StandAnswerInfoes" EntityType="Self.StandAnswerInfoes" />
|
<EntitySet Name="UserInfoes" EntityType="Self.UserInfoes" />
|
<EntitySet Name="UserRequestInfoes" EntityType="Self.UserRequestInfoes" />
|
<AssociationSet Name="FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId" Association="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_QCDistributions_QCDistributionId">
|
<End Role="QCDistributions" EntitySet="QCDistributions" />
|
<End Role="QCDistributionRegisterInfoes" EntitySet="QCDistributionRegisterInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId" Association="Self.FK_dbo_QCDistributionRegisterInfoes_dbo_UserRequestInfoes_LabId">
|
<End Role="UserRequestInfoes" EntitySet="UserRequestInfoes" />
|
<End Role="QCDistributionRegisterInfoes" EntitySet="QCDistributionRegisterInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId" Association="Self.FK_dbo_StandAnswerInfoes_dbo_QCDistributions_QCDistInfoId">
|
<End Role="QCDistributions" EntitySet="QCDistributions" />
|
<End Role="StandAnswerInfoes" EntitySet="StandAnswerInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="RoleInfoResourceInfoes" Association="Self.RoleInfoResourceInfoes">
|
<End Role="ResourceInfoes" EntitySet="ResourceInfoes" />
|
<End Role="RoleInfoes" EntitySet="RoleInfoes" />
|
</AssociationSet>
|
<AssociationSet Name="UserInfoRoleInfoes" Association="Self.UserInfoRoleInfoes">
|
<End Role="RoleInfoes" EntitySet="RoleInfoes" />
|
<End Role="UserInfoes" EntitySet="UserInfoes" />
|
</AssociationSet>
|
</EntityContainer>
|
</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="sbcLabSystemModelStoreContainer" CdmEntityContainer="sbcLabSystemEntities">
|
<EntitySetMapping Name="C__MigrationHistory">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.C__MigrationHistory">
|
<MappingFragment StoreEntitySet="__MigrationHistory">
|
<ScalarProperty Name="MigrationId" ColumnName="MigrationId" />
|
<ScalarProperty Name="ContextKey" ColumnName="ContextKey" />
|
<ScalarProperty Name="Model" ColumnName="Model" />
|
<ScalarProperty Name="ProductVersion" ColumnName="ProductVersion" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ApprovalInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.ApprovalInfoes">
|
<MappingFragment StoreEntitySet="ApprovalInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="FieldName" ColumnName="FieldName" />
|
<ScalarProperty Name="FieldValue" ColumnName="FieldValue" />
|
<ScalarProperty Name="Score" ColumnName="Score" />
|
<ScalarProperty Name="QCDistributionID" ColumnName="QCDistributionID" />
|
<ScalarProperty Name="FieldDescription" ColumnName="FieldDescription" />
|
<ScalarProperty Name="FieldPatient" ColumnName="FieldPatient" />
|
<ScalarProperty Name="IsComplex" ColumnName="IsComplex" />
|
<ScalarProperty Name="ElementNameInHtml" ColumnName="ElementNameInHtml" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="EmailSmtpInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.EmailSmtpInfoes">
|
<MappingFragment StoreEntitySet="EmailSmtpInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Host" ColumnName="Host" />
|
<ScalarProperty Name="UserEmail" ColumnName="UserEmail" />
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
<ScalarProperty Name="IsEnableSSL" ColumnName="IsEnableSSL" />
|
<ScalarProperty Name="SSLPort" ColumnName="SSLPort" />
|
<ScalarProperty Name="ConfigureName" ColumnName="ConfigureName" />
|
<ScalarProperty Name="IsDefault" ColumnName="IsDefault" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="EmileInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.EmileInfoes">
|
<MappingFragment StoreEntitySet="EmileInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
<ScalarProperty Name="Explain" ColumnName="Explain" />
|
<ScalarProperty Name="Title" ColumnName="Title" />
|
<ScalarProperty Name="Boody" ColumnName="Boody" />
|
<ScalarProperty Name="EmileName" ColumnName="EmileName" />
|
<ScalarProperty Name="SendOutDatetime" ColumnName="SendOutDatetime" />
|
<ScalarProperty Name="Column1" ColumnName="Column1" />
|
<ScalarProperty Name="Column2" ColumnName="Column2" />
|
<ScalarProperty Name="Column3" ColumnName="Column3" />
|
<ScalarProperty Name="EmileState" ColumnName="EmileState" />
|
<ScalarProperty Name="EmileNews" ColumnName="EmileNews" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="Menus">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.Menus">
|
<MappingFragment StoreEntitySet="Menus">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Url" ColumnName="Url" />
|
<ScalarProperty Name="Category" ColumnName="Category" />
|
<ScalarProperty Name="Contents" ColumnName="Contents" />
|
<ScalarProperty Name="ParnetId" ColumnName="ParnetId" />
|
<ScalarProperty Name="Time" ColumnName="Time" />
|
<ScalarProperty Name="Title" ColumnName="Title" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="QCDistributionRegisterInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.QCDistributionRegisterInfoes">
|
<MappingFragment StoreEntitySet="QCDistributionRegisterInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="IsCharged" ColumnName="IsCharged" />
|
<ScalarProperty Name="QCDistributionId" ColumnName="QCDistributionId" />
|
<ScalarProperty Name="ProjectId" ColumnName="ProjectId" />
|
<ScalarProperty Name="SampleNo" ColumnName="SampleNo" />
|
<ScalarProperty Name="IsSendEMS" ColumnName="IsSendEMS" />
|
<ScalarProperty Name="EMSNo" ColumnName="EMSNo" />
|
<ScalarProperty Name="PacketContent" ColumnName="PacketContent" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="ModifyUser" ColumnName="ModifyUser" />
|
<ScalarProperty Name="ModifyTime" ColumnName="ModifyTime" />
|
<ScalarProperty Name="LabId" ColumnName="LabId" />
|
<ScalarProperty Name="IsModified" ColumnName="IsModified" />
|
<ScalarProperty Name="IsSubmit" ColumnName="IsSubmit" />
|
<ScalarProperty Name="IsEnding" ColumnName="IsEnding" />
|
<ScalarProperty Name="AnswerJSON" ColumnName="AnswerJSON" />
|
<ScalarProperty Name="SubmitTime" ColumnName="SubmitTime" />
|
<ScalarProperty Name="SubmitUserNo" ColumnName="SubmitUserNo" />
|
<ScalarProperty Name="FirstTimeSubmitTime" ColumnName="FirstTimeSubmitTime" />
|
<ScalarProperty Name="LastPageModifyTime" ColumnName="LastPageModifyTime" />
|
<ScalarProperty Name="LetterNo" ColumnName="LetterNo" />
|
<ScalarProperty Name="ChargeRemark" ColumnName="ChargeRemark" />
|
<ScalarProperty Name="ChargeTime" ColumnName="ChargeTime" />
|
<ScalarProperty Name="SendEMSTime" ColumnName="SendEMSTime" />
|
<ScalarProperty Name="Score_Detail" ColumnName="Score_Detail" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="QCDistributions">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.QCDistributions">
|
<MappingFragment StoreEntitySet="QCDistributions">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="DistNo" ColumnName="DistNo" />
|
<ScalarProperty Name="IssuedDate" ColumnName="IssuedDate" />
|
<ScalarProperty Name="CloseDate" ColumnName="CloseDate" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
<ScalarProperty Name="ModifyDate" ColumnName="ModifyDate" />
|
<ScalarProperty Name="AnswerJSON" ColumnName="AnswerJSON" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ResourceInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.ResourceInfoes">
|
<MappingFragment StoreEntitySet="ResourceInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="ResourceNo" ColumnName="ResourceNo" />
|
<ScalarProperty Name="ResourceName" ColumnName="ResourceName" />
|
<ScalarProperty Name="ParentResourceNo" ColumnName="ParentResourceNo" />
|
<ScalarProperty Name="Url" ColumnName="Url" />
|
<ScalarProperty Name="Order" ColumnName="Order" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="RoleInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.RoleInfoes">
|
<MappingFragment StoreEntitySet="RoleInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="RoleName" ColumnName="RoleName" />
|
<ScalarProperty Name="RoleDescription" ColumnName="RoleDescription" />
|
<ScalarProperty Name="Privilege" ColumnName="Privilege" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="ScheduleTasks">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.ScheduleTasks">
|
<MappingFragment StoreEntitySet="ScheduleTasks">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
<ScalarProperty Name="Seconds" ColumnName="Seconds" />
|
<ScalarProperty Name="Type" ColumnName="Type" />
|
<ScalarProperty Name="Enabled" ColumnName="Enabled" />
|
<ScalarProperty Name="StopOnError" ColumnName="StopOnError" />
|
<ScalarProperty Name="LastStartUtc" ColumnName="LastStartUtc" />
|
<ScalarProperty Name="LastEndUtc" ColumnName="LastEndUtc" />
|
<ScalarProperty Name="LastSuccessUtc" ColumnName="LastSuccessUtc" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="StandAnswerInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.StandAnswerInfoes">
|
<MappingFragment StoreEntitySet="StandAnswerInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="ProjectId" ColumnName="ProjectId" />
|
<ScalarProperty Name="AnswerData" ColumnName="AnswerData" />
|
<ScalarProperty Name="ABO_RhD_FirstPatient" ColumnName="ABO_RhD_FirstPatient" />
|
<ScalarProperty Name="CrossMatch_W_FirstPatient" ColumnName="CrossMatch_W_FirstPatient" />
|
<ScalarProperty Name="AntibodyScreening_FirstPatient" ColumnName="AntibodyScreening_FirstPatient" />
|
<ScalarProperty Name="AntibodyIdentification_FirstPatient" ColumnName="AntibodyIdentification_FirstPatient" />
|
<ScalarProperty Name="CreateDate" ColumnName="CreateDate" />
|
<ScalarProperty Name="AdminID" ColumnName="AdminID" />
|
<ScalarProperty Name="UpdateDate" ColumnName="UpdateDate" />
|
<ScalarProperty Name="IsRead" ColumnName="IsRead" />
|
<ScalarProperty Name="ABO_RhD_SecPatient" ColumnName="ABO_RhD_SecPatient" />
|
<ScalarProperty Name="ABO_RhD_ThdPatient" ColumnName="ABO_RhD_ThdPatient" />
|
<ScalarProperty Name="CrossMatch_W_SecPatient" ColumnName="CrossMatch_W_SecPatient" />
|
<ScalarProperty Name="CrossMatch_W_ThdPatient" ColumnName="CrossMatch_W_ThdPatient" />
|
<ScalarProperty Name="CrossMatch_Y_FirstPatient" ColumnName="CrossMatch_Y_FirstPatient" />
|
<ScalarProperty Name="CrossMatch_Y_SecPatient" ColumnName="CrossMatch_Y_SecPatient" />
|
<ScalarProperty Name="CrossMatch_Y_ThdPatient" ColumnName="CrossMatch_Y_ThdPatient" />
|
<ScalarProperty Name="CrossMatch_Z_FirstPatient" ColumnName="CrossMatch_Z_FirstPatient" />
|
<ScalarProperty Name="CrossMatch_Z_SecPatient" ColumnName="CrossMatch_Z_SecPatient" />
|
<ScalarProperty Name="CrossMatch_Z_ThdPatient" ColumnName="CrossMatch_Z_ThdPatient" />
|
<ScalarProperty Name="AntibodyScreening_SecPatient" ColumnName="AntibodyScreening_SecPatient" />
|
<ScalarProperty Name="AntibodyScreening_ThdPatient" ColumnName="AntibodyScreening_ThdPatient" />
|
<ScalarProperty Name="AntibodyIdentification_SecPatient" ColumnName="AntibodyIdentification_SecPatient" />
|
<ScalarProperty Name="AntibodyIdentification_ThdPatient" ColumnName="AntibodyIdentification_ThdPatient" />
|
<ScalarProperty Name="QCDistInfoId" ColumnName="QCDistInfoId" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="UserInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.UserInfoes">
|
<MappingFragment StoreEntitySet="UserInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="UserNo" ColumnName="UserNo" />
|
<ScalarProperty Name="UserName" ColumnName="UserName" />
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
<ScalarProperty Name="IsUse" ColumnName="IsUse" />
|
<ScalarProperty Name="Password" ColumnName="Password" />
|
<ScalarProperty Name="CurrentEnvirnoment" ColumnName="CurrentEnvirnoment" />
|
<ScalarProperty Name="ModifiedTime" ColumnName="ModifiedTime" />
|
<ScalarProperty Name="Barcode" ColumnName="Barcode" />
|
<ScalarProperty Name="Remark" ColumnName="Remark" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<EntitySetMapping Name="UserRequestInfoes">
|
<EntityTypeMapping TypeName="sbcLabSystemModel.UserRequestInfoes">
|
<MappingFragment StoreEntitySet="UserRequestInfoes">
|
<ScalarProperty Name="Id" ColumnName="Id" />
|
<ScalarProperty Name="CompanyName" ColumnName="CompanyName" />
|
<ScalarProperty Name="LabName" ColumnName="LabName" />
|
<ScalarProperty Name="Address" ColumnName="Address" />
|
<ScalarProperty Name="Province" ColumnName="Province" />
|
<ScalarProperty Name="City" ColumnName="City" />
|
<ScalarProperty Name="District" ColumnName="District" />
|
<ScalarProperty Name="PostCode" ColumnName="PostCode" />
|
<ScalarProperty Name="ManagerName" ColumnName="ManagerName" />
|
<ScalarProperty Name="ManagerPhone" ColumnName="ManagerPhone" />
|
<ScalarProperty Name="ManagerFax" ColumnName="ManagerFax" />
|
<ScalarProperty Name="ManagerMobile" ColumnName="ManagerMobile" />
|
<ScalarProperty Name="ManagerEmail" ColumnName="ManagerEmail" />
|
<ScalarProperty Name="OperatorName" ColumnName="OperatorName" />
|
<ScalarProperty Name="OperatorPhone" ColumnName="OperatorPhone" />
|
<ScalarProperty Name="OperatorFax" ColumnName="OperatorFax" />
|
<ScalarProperty Name="OperatorMobile" ColumnName="OperatorMobile" />
|
<ScalarProperty Name="OperatorEmail" ColumnName="OperatorEmail" />
|
<ScalarProperty Name="ProjectId" ColumnName="ProjectId" />
|
<ScalarProperty Name="RequestTime" ColumnName="RequestTime" />
|
<ScalarProperty Name="UpdateTime" ColumnName="UpdateTime" />
|
<ScalarProperty Name="State" ColumnName="State" />
|
<ScalarProperty Name="LabCode" ColumnName="LabCode" />
|
<ScalarProperty Name="LabLoginName" ColumnName="LabLoginName" />
|
<ScalarProperty Name="LabPassword" ColumnName="LabPassword" />
|
<ScalarProperty Name="Remarks" ColumnName="Remarks" />
|
</MappingFragment>
|
</EntityTypeMapping>
|
</EntitySetMapping>
|
<AssociationSetMapping Name="RoleInfoResourceInfoes" TypeName="sbcLabSystemModel.RoleInfoResourceInfoes" StoreEntitySet="RoleInfoResourceInfoes">
|
<EndProperty Name="ResourceInfoes">
|
<ScalarProperty Name="Id" ColumnName="ResourceInfo_Id" />
|
</EndProperty>
|
<EndProperty Name="RoleInfoes">
|
<ScalarProperty Name="Id" ColumnName="RoleInfo_Id" />
|
</EndProperty>
|
</AssociationSetMapping>
|
<AssociationSetMapping Name="UserInfoRoleInfoes" TypeName="sbcLabSystemModel.UserInfoRoleInfoes" StoreEntitySet="UserInfoRoleInfoes">
|
<EndProperty Name="RoleInfoes">
|
<ScalarProperty Name="Id" ColumnName="RoleInfo_Id" />
|
</EndProperty>
|
<EndProperty Name="UserInfoes">
|
<ScalarProperty Name="Id" ColumnName="UserInfo_Id" />
|
</EndProperty>
|
</AssociationSetMapping>
|
</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>
|
