﻿<?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="NewAssociationModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityContainer Name="NewAssociationModelStoreContainer">
          <EntitySet Name="NewAssociationRequestDetails" EntityType="NewAssociationModel.Store.NewAssociationRequestDetails" store:Type="Tables" Schema="App" />
          <EntitySet Name="NewAssociationRequestTypes" EntityType="NewAssociationModel.Store.NewAssociationRequestTypes" store:Type="Tables" Schema="App" />
          <AssociationSet Name="FK_NewAssociationRequestDetails_NewAssociationRequestTypes" Association="NewAssociationModel.Store.FK_NewAssociationRequestDetails_NewAssociationRequestTypes">
            <End Role="NewAssociationRequestTypes" EntitySet="NewAssociationRequestTypes" />
            <End Role="NewAssociationRequestDetails" EntitySet="NewAssociationRequestDetails" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="NewAssociationRequestDetails">
          <Key>
            <PropertyRef Name="NewAssociationRequestDetailID" />
          </Key>
          <Property Name="NewAssociationRequestDetailID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="WorkflowInstanceID" Type="bigint" />
          <Property Name="CreatedByID" Type="bigint" Nullable="false" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="UpdatedByID" Type="bigint" Nullable="false" />
          <Property Name="UpdatedDate" Type="datetime" Nullable="false" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
          <Property Name="NewAssociationRequestTypeID" Type="smallint" Nullable="false" />
          <Property Name="AssociationModeID" Type="int" />
          <Property Name="AssociationTypeID" Type="smallint" />
          <Property Name="RegionID" Type="bigint" />
          <Property Name="AssociationName" Type="varchar" MaxLength="255" />
          <Property Name="AssociationNameAbbrev" Type="varchar" MaxLength="50" />
          <Property Name="RegistrationNumber" Type="varchar" MaxLength="50" />
          <Property Name="PostalAddress" Type="varchar" MaxLength="400" />
          <Property Name="PostalAddressCode" Type="varchar" MaxLength="4" />
          <Property Name="PhysicalAddress" Type="varchar" MaxLength="400" />
          <Property Name="PhysicalAddressCode" Type="varchar" MaxLength="4" />
          <Property Name="BusRegNumber" Type="varchar" MaxLength="50" />
          <Property Name="TaxNumber" Type="varchar" MaxLength="50" />
          <Property Name="MemberCount" Type="int" />
          <Property Name="TelNumber" Type="varchar" MaxLength="50" />
          <Property Name="FaxNumber" Type="varchar" MaxLength="50" />
          <Property Name="CellNumber" Type="varchar" MaxLength="50" />
          <Property Name="EmailAddress" Type="varchar" MaxLength="255" />
          <Property Name="OlasID" Type="bigint" />
          <Property Name="LtpsID" Type="bigint" />
          <Property Name="VerifiedAssociationID" Type="bigint" />
        </EntityType>
        <EntityType Name="NewAssociationRequestTypes">
          <Key>
            <PropertyRef Name="NewAssociationRequestTypeID" />
          </Key>
          <Property Name="NewAssociationRequestTypeID" Type="smallint" Nullable="false" />
          <Property Name="Title" Type="varchar" Nullable="false" MaxLength="255" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <Association Name="FK_NewAssociationRequestDetails_NewAssociationRequestTypes">
          <End Role="NewAssociationRequestTypes" Type="NewAssociationModel.Store.NewAssociationRequestTypes" Multiplicity="1" />
          <End Role="NewAssociationRequestDetails" Type="NewAssociationModel.Store.NewAssociationRequestDetails" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="NewAssociationRequestTypes">
              <PropertyRef Name="NewAssociationRequestTypeID" />
            </Principal>
            <Dependent Role="NewAssociationRequestDetails">
              <PropertyRef Name="NewAssociationRequestTypeID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Model" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="NewAssociationContext" annotation:LazyLoadingEnabled="false">
          <FunctionImport Name="Pr_NewAssociationRequestDetailsSearch">
            <Parameter Name="NewAssociationRequestDetailID" Mode="In" Type="Int64" />
            <Parameter Name="WorkflowInstanceStatusID" Mode="In" Type="Int16" />
          </FunctionImport>
          <EntitySet Name="NewAssociationRequestDetails" EntityType="Model.NewAssociationRequestDetail" />
          <EntitySet Name="NewAssociationRequestTypes" EntityType="Model.NewAssociationRequestType" />
          <AssociationSet Name="FK_NewAssociationRequestDetails_NewAssociationRequestTypes" Association="Model.FK_NewAssociationRequestDetails_NewAssociationRequestTypes">
            <End Role="NewAssociationRequestType" EntitySet="NewAssociationRequestTypes" />
            <End Role="NewAssociationRequestDetail" EntitySet="NewAssociationRequestDetails" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="NewAssociationRequestDetail">
          <Key>
            <PropertyRef Name="NewAssociationRequestDetailID" />
          </Key>
          <Property Type="Int64" Name="NewAssociationRequestDetailID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="Int64" Name="WorkflowInstanceID" />
          <Property Type="Int64" Name="CreatedByID" Nullable="false" />
          <Property Type="DateTime" Name="CreatedDate" Nullable="false" Precision="3" />
          <Property Type="Int64" Name="UpdatedByID" Nullable="false" />
          <Property Type="DateTime" Name="UpdatedDate" Nullable="false" Precision="3" />
          <Property Type="Boolean" Name="IsCancelled" Nullable="false" />
          <Property Type="Int32" Name="AssociationModeID" />
          <Property Type="Int16" Name="AssociationTypeID" />
          <Property Type="Int64" Name="RegionID" />
          <Property Type="String" Name="AssociationName" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="AssociationNameAbbrev" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="RegistrationNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="PostalAddress" MaxLength="400" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="PostalAddressCode" MaxLength="4" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="PhysicalAddress" MaxLength="400" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="PhysicalAddressCode" MaxLength="4" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="BusRegNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="TaxNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="Int32" Name="MemberCount" />
          <Property Type="String" Name="TelNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="FaxNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="CellNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="EmailAddress" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Type="Int64" Name="OlasID" />
          <Property Type="Int64" Name="LtpsID" />
          <Property Type="Int16" Name="NewAssociationRequestTypeID" Nullable="false" />
          <NavigationProperty Name="RequestType" Relationship="Model.FK_NewAssociationRequestDetails_NewAssociationRequestTypes" FromRole="NewAssociationRequestDetail" ToRole="NewAssociationRequestType" />
          <Property Type="Int64" Name="VerifiedAssociationID" />
        </EntityType>
        <EntityType Name="NewAssociationRequestType">
          <Key>
            <PropertyRef Name="NewAssociationRequestTypeID" />
          </Key>
          <Property Type="Int16" Name="NewAssociationRequestTypeID" Nullable="false" />
          <Property Type="String" Name="Title" Nullable="false" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Type="Boolean" Name="IsCancelled" Nullable="false" />
          <NavigationProperty Name="NewAssociationRequestDetails" Relationship="Model.FK_NewAssociationRequestDetails_NewAssociationRequestTypes" FromRole="NewAssociationRequestType" ToRole="NewAssociationRequestDetail" >
            <Documentation>
              <LongDescription>[ScriptIgnore]</LongDescription>
            </Documentation>
          </NavigationProperty>
        </EntityType>
        <Association Name="FK_NewAssociationRequestDetails_NewAssociationRequestTypes">
          <End Type="Model.NewAssociationRequestType" Role="NewAssociationRequestType" Multiplicity="1" />
          <End Type="Model.NewAssociationRequestDetail" Role="NewAssociationRequestDetail" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="NewAssociationRequestType">
              <PropertyRef Name="NewAssociationRequestTypeID" />
            </Principal>
            <Dependent Role="NewAssociationRequestDetail">
              <PropertyRef Name="NewAssociationRequestTypeID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </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="NewAssociationModelStoreContainer" CdmEntityContainer="NewAssociationContext">
        <EntitySetMapping Name="NewAssociationRequestDetails">
            <EntityTypeMapping TypeName="Model.NewAssociationRequestDetail">
              <MappingFragment StoreEntitySet="NewAssociationRequestDetails">
                <ScalarProperty Name="VerifiedAssociationID" ColumnName="VerifiedAssociationID" />
                <ScalarProperty Name="NewAssociationRequestTypeID" ColumnName="NewAssociationRequestTypeID" />
                <ScalarProperty Name="LtpsID" ColumnName="LtpsID" />
                <ScalarProperty Name="OlasID" ColumnName="OlasID" />
                <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
                <ScalarProperty Name="CellNumber" ColumnName="CellNumber" />
                <ScalarProperty Name="FaxNumber" ColumnName="FaxNumber" />
                <ScalarProperty Name="TelNumber" ColumnName="TelNumber" />
                <ScalarProperty Name="MemberCount" ColumnName="MemberCount" />
                <ScalarProperty Name="TaxNumber" ColumnName="TaxNumber" />
                <ScalarProperty Name="BusRegNumber" ColumnName="BusRegNumber" />
                <ScalarProperty Name="PhysicalAddressCode" ColumnName="PhysicalAddressCode" />
                <ScalarProperty Name="PhysicalAddress" ColumnName="PhysicalAddress" />
                <ScalarProperty Name="PostalAddressCode" ColumnName="PostalAddressCode" />
                <ScalarProperty Name="PostalAddress" ColumnName="PostalAddress" />
                <ScalarProperty Name="RegistrationNumber" ColumnName="RegistrationNumber" />
                <ScalarProperty Name="AssociationNameAbbrev" ColumnName="AssociationNameAbbrev" />
                <ScalarProperty Name="AssociationName" ColumnName="AssociationName" />
                <ScalarProperty Name="RegionID" ColumnName="RegionID" />
                <ScalarProperty Name="AssociationTypeID" ColumnName="AssociationTypeID" />
                <ScalarProperty Name="AssociationModeID" ColumnName="AssociationModeID" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
                <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
                <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
                <ScalarProperty Name="WorkflowInstanceID" ColumnName="WorkflowInstanceID" />
                <ScalarProperty Name="NewAssociationRequestDetailID" ColumnName="NewAssociationRequestDetailID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="NewAssociationRequestTypes">
            <EntityTypeMapping TypeName="Model.NewAssociationRequestType">
              <MappingFragment StoreEntitySet="NewAssociationRequestTypes">
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="NewAssociationRequestTypeID" ColumnName="NewAssociationRequestTypeID" />
              </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="True" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams>
      <Diagram Name="NewAssociationModel" ZoomLevel="85">
        <EntityTypeShape EntityType="Model.NewAssociationRequestDetail" Width="1.5" PointX="6.7437844084314" PointY="18.016069569632442" />
        <EntityTypeShape EntityType="Model.NewAssociationRequestType" Width="1.5" PointX="11.431150059882157" PointY="1.043046594151783" />
        <AssociationConnector Association="Model.FK_NewAssociationRequestDetails_NewAssociationRequestTypes" />
      </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>