﻿<?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="Neo.LegitimateLicences.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="MDApprovalDetails">
          <Key>
            <PropertyRef Name="MDApprovalDetailID" />
          </Key>
          <Property Name="MDApprovalDetailID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="WorkflowInstanceID" Type="bigint" />
          <Property Name="Description" Type="varchar(max)" />
          <Property Name="EntityID" Type="bigint" />
          <Property Name="ItemID" Type="bigint" />
          <Property Name="JSONData" Type="varchar(max)" />
          <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="RequestAction" Type="varchar" MaxLength="20" />
        </EntityType>
        <!--Errors Found During Generation:
warning 6002: The table/view 'LegitimateNATIONAL.App.Vw_MDApprovalDetails' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
        <EntityType Name="Vw_MDApprovalDetails">
          <Key>
            <PropertyRef Name="MDApprovalDetailID" />
            <PropertyRef Name="WorkflowReference" />
            <PropertyRef Name="WorkflowStatus" />
            <PropertyRef Name="EntityName" />
            <PropertyRef Name="IsCancelled" />
            <PropertyRef Name="CreatedByID" />
          </Key>
          <Property Name="MDApprovalDetailID" Type="bigint" Nullable="false" />
          <Property Name="WorkflowInstanceID" Type="bigint" />
          <Property Name="WorkflowReference" Type="varchar" MaxLength="20" Nullable="false" />
          <Property Name="WorkflowStatus" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="Description" Type="varchar(max)" />
          <Property Name="EntityID" Type="bigint" />
          <Property Name="EntityName" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="ItemID" Type="bigint" />
          <Property Name="JSONData" Type="varchar(max)" />
          <Property Name="RequestAction" Type="varchar" MaxLength="20" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
          <Property Name="CreatedByID" Type="bigint" Nullable="false" />
          <Property Name="WorkflowInstanceCreatedByName" Type="varchar" MaxLength="101" />
          <Property Name="WorkflowDescription" Type="varchar" MaxLength="255" />
        </EntityType>
        <EntityContainer Name="NeoLegitimateLicencesStoreContainer">
          <EntitySet Name="MDApprovalDetails" EntityType="Self.MDApprovalDetails" Schema="App" store:Type="Tables" />
          <EntitySet Name="Vw_MDApprovalDetails" EntityType="Self.Vw_MDApprovalDetails" store:Type="Views" store:Schema="App">
            <DefiningQuery>SELECT 
    [Vw_MDApprovalDetails].[MDApprovalDetailID] AS [MDApprovalDetailID], 
    [Vw_MDApprovalDetails].[WorkflowInstanceID] AS [WorkflowInstanceID], 
    [Vw_MDApprovalDetails].[WorkflowReference] AS [WorkflowReference], 
    [Vw_MDApprovalDetails].[WorkflowStatus] AS [WorkflowStatus], 
    [Vw_MDApprovalDetails].[Description] AS [Description], 
    [Vw_MDApprovalDetails].[EntityID] AS [EntityID], 
    [Vw_MDApprovalDetails].[EntityName] AS [EntityName], 
    [Vw_MDApprovalDetails].[ItemID] AS [ItemID], 
    [Vw_MDApprovalDetails].[JSONData] AS [JSONData], 
    [Vw_MDApprovalDetails].[RequestAction] AS [RequestAction], 
    [Vw_MDApprovalDetails].[IsCancelled] AS [IsCancelled], 
    [Vw_MDApprovalDetails].[CreatedByID] AS [CreatedByID], 
    [Vw_MDApprovalDetails].[WorkflowInstanceCreatedByName] AS [WorkflowInstanceCreatedByName], 
    [Vw_MDApprovalDetails].[WorkflowDescription] AS [WorkflowDescription]
    FROM [App].[Vw_MDApprovalDetails] AS [Vw_MDApprovalDetails]</DefiningQuery>
          </EntitySet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Neo.LegitimateLicences" 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="MDApprovalDetail">
          <Key>
            <PropertyRef Name="MDApprovalDetailID" />
          </Key>
          <Property Name="MDApprovalDetailID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="WorkflowInstanceID" Type="Int64" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="EntityID" Type="Int64" />
          <Property Name="ItemID" Type="Int64" />
          <Property Name="JSONData" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="CreatedByID" Type="Int64" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="UpdatedByID" Type="Int64" Nullable="false" />
          <Property Name="UpdatedDate" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <Property Name="RequestAction" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
        </EntityType>
        <EntityContainer Name="MDApprovalRequestContext" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="MDApprovalDetails" EntityType="Self.MDApprovalDetail" />
          <EntitySet Name="Vw_MDApprovalDetails" EntityType="Neo.LegitimateLicences.Vw_MDApprovalDetails" />
        </EntityContainer>
        <EntityType Name="Vw_MDApprovalDetails">
          <Key>
            <PropertyRef Name="MDApprovalDetailID" />
            <PropertyRef Name="WorkflowReference" />
            <PropertyRef Name="WorkflowStatus" />
            <PropertyRef Name="EntityName" />
            <PropertyRef Name="IsCancelled" />
            <PropertyRef Name="CreatedByID" />
          </Key>
          <Property Name="MDApprovalDetailID" Type="Int64" Nullable="false" />
          <Property Name="WorkflowInstanceID" Type="Int64" />
          <Property Name="WorkflowReference" Type="String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="false" />
          <Property Name="WorkflowStatus" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="EntityID" Type="Int64" />
          <Property Name="EntityName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ItemID" Type="Int64" />
          <Property Name="JSONData" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
          <Property Name="RequestAction" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <Property Name="CreatedByID" Type="Int64" Nullable="false" />
          <Property Name="WorkflowInstanceCreatedByName" Type="String" MaxLength="101" FixedLength="false" Unicode="false" />
          <Property Name="WorkflowDescription" Type="String" MaxLength="255" FixedLength="false" Unicode="false" />
        </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="NeoLegitimateLicencesStoreContainer" CdmEntityContainer="MDApprovalRequestContext">
          <EntitySetMapping Name="MDApprovalDetails">
            <EntityTypeMapping TypeName="Neo.LegitimateLicences.MDApprovalDetail">
              <MappingFragment StoreEntitySet="MDApprovalDetails">
                <ScalarProperty Name="MDApprovalDetailID" ColumnName="MDApprovalDetailID" />
                <ScalarProperty Name="WorkflowInstanceID" ColumnName="WorkflowInstanceID" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="ItemID" ColumnName="ItemID" />
                <ScalarProperty Name="JSONData" ColumnName="JSONData" />
                <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
                <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
                <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
                <ScalarProperty Name="RequestAction" ColumnName="RequestAction" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Vw_MDApprovalDetails">
            <EntityTypeMapping TypeName="Neo.LegitimateLicences.Vw_MDApprovalDetails">
              <MappingFragment StoreEntitySet="Vw_MDApprovalDetails">
                <ScalarProperty Name="WorkflowDescription" ColumnName="WorkflowDescription" />
                <ScalarProperty Name="WorkflowInstanceCreatedByName" ColumnName="WorkflowInstanceCreatedByName" />
                <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
                <ScalarProperty Name="RequestAction" ColumnName="RequestAction" />
                <ScalarProperty Name="JSONData" ColumnName="JSONData" />
                <ScalarProperty Name="ItemID" ColumnName="ItemID" />
                <ScalarProperty Name="EntityName" ColumnName="EntityName" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="WorkflowStatus" ColumnName="WorkflowStatus" />
                <ScalarProperty Name="WorkflowReference" ColumnName="WorkflowReference" />
                <ScalarProperty Name="WorkflowInstanceID" ColumnName="WorkflowInstanceID" />
                <ScalarProperty Name="MDApprovalDetailID" ColumnName="MDApprovalDetailID" />
              </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="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>