﻿<?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="Workflows.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2005" 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="WorkflowInstanceTasks">
          <Key>
            <PropertyRef Name="WorkflowInstanceTaskID" />
          </Key>
          <Property Name="WorkflowInstanceTaskID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="WorkflowInstanceID" Type="bigint" Nullable="false" />
          <Property Name="WorkflowInstanceTaskStatusID" Type="smallint" Nullable="false" />
          <Property Name="WorkflowTemplateStepID" Type="bigint" Nullable="false" />
          <Property Name="DateCompleted" Type="datetime" />
          <Property Name="AssignedToID" Type="bigint" Nullable="false" />
          <Property Name="CompletedByID" Type="bigint" />
          <Property Name="Description" Type="varchar" MaxLength="255" Nullable="false" />
          <Property Name="Comments" Type="varchar" MaxLength="1000" />
          <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="EscalatedFromID" Type="bigint" />
        </EntityType>
        <EntityType Name="WorkflowTaskHandlers">
          <Key>
            <PropertyRef Name="WorkflowTaskHandlerID" />
          </Key>
          <Property Name="WorkflowTaskHandlerID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="WorkflowID" Type="bigint" Nullable="false" />
          <Property Name="HandlerTypeName" Type="varchar" MaxLength="255" Nullable="false" />
          <Property Name="MethodName" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
          <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" />
        </EntityType>
        <EntityType Name="WorkflowTaskHandlerSettings">
          <Key>
            <PropertyRef Name="WorkflowTaskHandlerSettingID" />
          </Key>
          <Property Name="WorkflowTaskHandlerSettingID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="WorkflowTaskHandlerID" Type="bigint" Nullable="false" />
          <Property Name="SettingKey" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="SettingValue" Type="varchar(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="WorkflowTemplateSteps">
          <Key>
            <PropertyRef Name="WorkflowTemplateStepID" />
          </Key>
          <Property Name="WorkflowTemplateStepID" Type="bigint" Nullable="false" />
          <Property Name="WorkflowTemplateID" Type="bigint" Nullable="false" />
          <Property Name="WorkflowTemplateStepTypeID" Type="smallint" Nullable="false" />
          <Property Name="Branch" Type="float" Nullable="false" />
          <Property Name="Step" Type="float" Nullable="false" />
          <Property Name="StepParent" Type="float" Nullable="false" />
          <Property Name="StepNext" Type="float" Nullable="false" />
          <Property Name="StepTitle" Type="varchar" MaxLength="255" Nullable="false" />
          <Property Name="StepDescription" Type="varchar" MaxLength="255" />
          <Property Name="StepDurationWarning" Type="int" Nullable="false" />
          <Property Name="StepDurationOvertime" Type="int" Nullable="false" />
          <Property Name="IsDefaultStep" Type="bit" Nullable="false" />
          <Property Name="WorkflowTaskHandlerID" Type="bigint" />
          <Property Name="IsRequiredScript" Type="varchar" MaxLength="1000" />
          <Property Name="IsEmailRequired" Type="bit" Nullable="false" />
          <Property Name="StepNextPossibles" Type="varchar" MaxLength="100" />
          <Property Name="StepApplicationRoles" Type="varchar" MaxLength="1000" />
          <Property Name="StepReassignRoles" Type="varchar" MaxLength="1000" />
          <Property Name="IsRequiredXml" Type="xml" />
          <Property Name="CanAutoExpire" Type="bit" Nullable="false" />
        </EntityType>
        <Association Name="FK_WorkflowInstanceTasks_WorkflowTemplateSteps">
          <End Role="WorkflowTemplateSteps" Type="Self.WorkflowTemplateSteps" Multiplicity="1" />
          <End Role="WorkflowInstanceTasks" Type="Self.WorkflowInstanceTasks" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkflowTemplateSteps">
              <PropertyRef Name="WorkflowTemplateStepID" />
            </Principal>
            <Dependent Role="WorkflowInstanceTasks">
              <PropertyRef Name="WorkflowTemplateStepID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers">
          <End Role="WorkflowTaskHandlers" Type="Self.WorkflowTaskHandlers" Multiplicity="1" />
          <End Role="WorkflowTaskHandlerSettings" Type="Self.WorkflowTaskHandlerSettings" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkflowTaskHandlers">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Principal>
            <Dependent Role="WorkflowTaskHandlerSettings">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkflowTemplateSteps_WorkflowTaskHandlers">
          <End Role="WorkflowTaskHandlers" Type="Self.WorkflowTaskHandlers" Multiplicity="0..1" />
          <End Role="WorkflowTemplateSteps" Type="Self.WorkflowTemplateSteps" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkflowTaskHandlers">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Principal>
            <Dependent Role="WorkflowTemplateSteps">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="Pr_WorkflowInstanceRaiseException" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Wf">
          <Parameter Name="WorkflowInstanceTaskID" Type="bigint" Mode="In" />
          <Parameter Name="CompletedByUserName" Type="varchar" Mode="In" />
          <Parameter Name="Comments" Type="varchar" Mode="In" />
          <Parameter Name="ErrorMessage" Type="varchar" Mode="InOut" />
        </Function>
        <Function Name="Pr_WorkflowInstanceTaskAction" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Wf">
          <Parameter Name="WorkflowInstanceTaskID" Type="bigint" Mode="In" />
          <Parameter Name="WorkflowInstanceTaskStatusID" Type="smallint" Mode="In" />
          <Parameter Name="CompletedByUserName" Type="varchar" Mode="In" />
          <Parameter Name="RequestCorrectionWorkflowTemplateStepID" Type="smallint" Mode="In" />
          <Parameter Name="Comments" Type="varchar" Mode="In" />
          <Parameter Name="ErrorMessage" Type="varchar" Mode="InOut" />
        </Function>
        <Function Name="Pr_WorkflowInstanceTaskActionFailover" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="Wf">
          <Parameter Name="WorkflowInstanceTaskID" Type="bigint" Mode="In" />
          <Parameter Name="ErrorMessage" Type="varchar(max)" Mode="In" />
          <Parameter Name="UpdatedByID" Type="bigint" Mode="In" />
        </Function>
        <EntityContainer Name="WorkflowsStoreContainer">
          <EntitySet Name="WorkflowInstanceTasks" EntityType="Self.WorkflowInstanceTasks" Schema="Wf" store:Type="Tables" />
          <EntitySet Name="WorkflowTaskHandlers" EntityType="Self.WorkflowTaskHandlers" Schema="Wf" store:Type="Tables" />
          <EntitySet Name="WorkflowTaskHandlerSettings" EntityType="Self.WorkflowTaskHandlerSettings" Schema="Wf" store:Type="Tables" />
          <EntitySet Name="WorkflowTemplateSteps" EntityType="Self.WorkflowTemplateSteps" Schema="Wf" store:Type="Tables" />
          <AssociationSet Name="FK_WorkflowInstanceTasks_WorkflowTemplateSteps" Association="Self.FK_WorkflowInstanceTasks_WorkflowTemplateSteps">
            <End Role="WorkflowTemplateSteps" EntitySet="WorkflowTemplateSteps" />
            <End Role="WorkflowInstanceTasks" EntitySet="WorkflowInstanceTasks" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers" Association="Self.FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers">
            <End Role="WorkflowTaskHandlers" EntitySet="WorkflowTaskHandlers" />
            <End Role="WorkflowTaskHandlerSettings" EntitySet="WorkflowTaskHandlerSettings" />
          </AssociationSet>
          <AssociationSet Name="FK_WorkflowTemplateSteps_WorkflowTaskHandlers" Association="Self.FK_WorkflowTemplateSteps_WorkflowTaskHandlers">
            <End Role="WorkflowTaskHandlers" EntitySet="WorkflowTaskHandlers" />
            <End Role="WorkflowTemplateSteps" EntitySet="WorkflowTemplateSteps" />
          </AssociationSet>
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="Workflows" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="WorkflowServiceContext" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="WorkflowInstanceTasks" EntityType="Workflows.WorkflowInstanceTask" />
          <EntitySet Name="WorkflowTaskHandlers" EntityType="Workflows.WorkflowTaskHandler" />
          <EntitySet Name="WorkflowTemplateSteps" EntityType="Workflows.WorkflowTemplateStep" />
          <AssociationSet Name="FK_WorkflowInstanceTasks_WorkflowTemplateSteps" Association="Workflows.FK_WorkflowInstanceTasks_WorkflowTemplateSteps">
            <End Role="WorkflowTemplateStep" EntitySet="WorkflowTemplateSteps" />
            <End Role="WorkflowInstanceTask" EntitySet="WorkflowInstanceTasks" />
          </AssociationSet>
          <FunctionImport Name="Pr_WorkflowInstanceTaskAction">
            <Parameter Name="WorkflowInstanceTaskID" Mode="In" Type="Int64" />
            <Parameter Name="WorkflowInstanceTaskStatusID" Mode="In" Type="Int16" />
            <Parameter Name="CompletedByUserName" Mode="In" Type="String" />
            <Parameter Name="RequestCorrectionWorkflowTemplateStepID" Mode="In" Type="Int16" />
            <Parameter Name="Comments" Mode="In" Type="String" />
            <Parameter Name="ErrorMessage" Mode="InOut" Type="String" />
          </FunctionImport>
          <AssociationSet Name="FK_WorkflowTemplateSteps_WorkflowTaskHandlers" Association="Workflows.FK_WorkflowTemplateSteps_WorkflowTaskHandlers">
            <End Role="WorkflowTaskHandler" EntitySet="WorkflowTaskHandlers" />
            <End Role="WorkflowTemplateStep" EntitySet="WorkflowTemplateSteps" />
          </AssociationSet>
          <FunctionImport Name="Pr_WorkflowInstanceTaskActionFailover">
            <Parameter Name="WorkflowInstanceTaskID" Mode="In" Type="Int64" />
            <Parameter Name="ErrorMessage" Mode="In" Type="String" />
            <Parameter Name="UpdatedByID" Mode="In" Type="Int64" />
          </FunctionImport>
          <EntitySet Name="WorkflowTaskHandlerSettings" EntityType="Workflows.WorkflowTaskHandlerSetting" />
          <AssociationSet Name="FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers" Association="Workflows.FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers">
            <End Role="WorkflowTaskHandler" EntitySet="WorkflowTaskHandlers" />
            <End Role="WorkflowTaskHandlerSetting" EntitySet="WorkflowTaskHandlerSettings" />
          </AssociationSet>
          <FunctionImport Name="Pr_WorkflowInstanceRaiseException">
            <Parameter Name="WorkflowInstanceTaskID" Mode="In" Type="Int64" />
            <Parameter Name="CompletedByUserName" Mode="In" Type="String" />
            <Parameter Name="Comments" Mode="In" Type="String" />
            <Parameter Name="ErrorMessage" Mode="InOut" Type="String" />
          </FunctionImport>
        </EntityContainer>
        <EntityType Name="WorkflowInstanceTask">
          <Key>
            <PropertyRef Name="WorkflowInstanceTaskID" />
          </Key>
          <Property Name="WorkflowInstanceTaskID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="WorkflowInstanceID" Type="Int64" Nullable="false" />
          <Property Name="WorkflowInstanceTaskStatusID" Type="Int16" Nullable="false" />
          <Property Name="WorkflowTemplateStepID" Type="Int64" Nullable="false" />
          <Property Name="DateCompleted" Type="DateTime" Precision="3" />
          <Property Name="AssignedToID" Type="Int64" Nullable="false" />
          <Property Name="CompletedByID" Type="Int64" />
          <Property Name="Description" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="Comments" Type="String" MaxLength="1000" Unicode="false" FixedLength="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" />
          <NavigationProperty Name="WorkflowTemplateStep" Relationship="Workflows.FK_WorkflowInstanceTasks_WorkflowTemplateSteps" FromRole="WorkflowInstanceTask" ToRole="WorkflowTemplateStep" />
          <Property Name="EscalatedFromID" Type="Int64" />
        </EntityType>
        <EntityType Name="WorkflowTaskHandler">
          <Key>
            <PropertyRef Name="WorkflowTaskHandlerID" />
          </Key>
          <Property Name="WorkflowTaskHandlerID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="WorkflowID" Type="Int64" Nullable="false" />
          <Property Name="HandlerTypeName" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="MethodName" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="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" />
          <NavigationProperty Name="WorkflowTemplateSteps" Relationship="Workflows.FK_WorkflowTemplateSteps_WorkflowTaskHandlers" FromRole="WorkflowTaskHandler" ToRole="WorkflowTemplateStep" />
          <NavigationProperty Name="WorkflowTaskHandlerSettings" Relationship="Workflows.FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers" FromRole="WorkflowTaskHandler" ToRole="WorkflowTaskHandlerSetting" />
        </EntityType>
        <EntityType Name="WorkflowTemplateStep">
          <Key>
            <PropertyRef Name="WorkflowTemplateStepID" />
          </Key>
          <Property Type="Int64" Name="WorkflowTemplateStepID" Nullable="false" />
          <Property Type="Int64" Name="WorkflowTemplateID" Nullable="false" />
          <Property Type="Int16" Name="WorkflowTemplateStepTypeID" Nullable="false" />
          <Property Type="Double" Name="Branch" Nullable="false" />
          <Property Type="Double" Name="Step" Nullable="false" />
          <Property Type="Double" Name="StepParent" Nullable="false" />
          <Property Type="Double" Name="StepNext" Nullable="false" />
          <Property Type="String" Name="StepTitle" Nullable="false" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="StepDescription" MaxLength="255" FixedLength="false" Unicode="false" />
          <Property Type="Int32" Name="StepDurationWarning" Nullable="false" />
          <Property Type="Int32" Name="StepDurationOvertime" Nullable="false" />
          <Property Type="Boolean" Name="IsDefaultStep" Nullable="false" />
          <NavigationProperty Name="WorkflowInstanceTasks" Relationship="Workflows.FK_WorkflowInstanceTasks_WorkflowTemplateSteps" FromRole="WorkflowTemplateStep" ToRole="WorkflowInstanceTask" />
          <Property Type="Int64" Name="WorkflowTaskHandlerID" />
          <NavigationProperty Name="WorkflowTaskHandler" Relationship="Workflows.FK_WorkflowTemplateSteps_WorkflowTaskHandlers" FromRole="WorkflowTemplateStep" ToRole="WorkflowTaskHandler" />
          <Property Type="String" Name="IsRequiredScript" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="IsEmailRequired" Type="Boolean" Nullable="false" />
          <Property Name="StepNextPossibles" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Name="StepApplicationRoles" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="StepReassignRoles" Type="String" MaxLength="1000" FixedLength="false" Unicode="false" />
          <Property Name="IsRequiredXml" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
          <Property Name="CanAutoExpire" Type="Boolean" Nullable="false" />
        </EntityType>
        <Association Name="FK_WorkflowInstanceTasks_WorkflowTemplateSteps">
          <End Type="Workflows.WorkflowTemplateStep" Role="WorkflowTemplateStep" Multiplicity="1" />
          <End Type="Workflows.WorkflowInstanceTask" Role="WorkflowInstanceTask" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkflowTemplateStep">
              <PropertyRef Name="WorkflowTemplateStepID" />
            </Principal>
            <Dependent Role="WorkflowInstanceTask">
              <PropertyRef Name="WorkflowTemplateStepID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_WorkflowTemplateSteps_WorkflowTaskHandlers">
          <End Type="Workflows.WorkflowTaskHandler" Role="WorkflowTaskHandler" Multiplicity="0..1" />
          <End Type="Workflows.WorkflowTemplateStep" Role="WorkflowTemplateStep" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkflowTaskHandler">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Principal>
            <Dependent Role="WorkflowTemplateStep">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <EntityType Name="WorkflowTaskHandlerSetting">
          <Key>
            <PropertyRef Name="WorkflowTaskHandlerSettingID" />
          </Key>
          <Property Type="Int32" Name="WorkflowTaskHandlerSettingID" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="Int64" Name="WorkflowTaskHandlerID" Nullable="false" />
          <Property Type="String" Name="SettingKey" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="SettingValue" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="false" />
          <NavigationProperty Name="WorkflowTaskHandler" Relationship="Workflows.FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers" FromRole="WorkflowTaskHandlerSetting" ToRole="WorkflowTaskHandler" />
        </EntityType>
        <Association Name="FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers">
          <End Type="Workflows.WorkflowTaskHandler" Role="WorkflowTaskHandler" Multiplicity="1" />
          <End Type="Workflows.WorkflowTaskHandlerSetting" Role="WorkflowTaskHandlerSetting" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="WorkflowTaskHandler">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </Principal>
            <Dependent Role="WorkflowTaskHandlerSetting">
              <PropertyRef Name="WorkflowTaskHandlerID" />
            </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="WorkflowsStoreContainer" CdmEntityContainer="WorkflowServiceContext">
          <EntitySetMapping Name="WorkflowInstanceTasks"><EntityTypeMapping TypeName="Workflows.WorkflowInstanceTask"><MappingFragment StoreEntitySet="WorkflowInstanceTasks">
            <ScalarProperty Name="EscalatedFromID" ColumnName="EscalatedFromID" />
                <ScalarProperty Name="WorkflowInstanceTaskID" ColumnName="WorkflowInstanceTaskID" />
            <ScalarProperty Name="WorkflowInstanceID" ColumnName="WorkflowInstanceID" />
            <ScalarProperty Name="WorkflowInstanceTaskStatusID" ColumnName="WorkflowInstanceTaskStatusID" />
            <ScalarProperty Name="WorkflowTemplateStepID" ColumnName="WorkflowTemplateStepID" />
            <ScalarProperty Name="DateCompleted" ColumnName="DateCompleted" />
            <ScalarProperty Name="AssignedToID" ColumnName="AssignedToID" />
            <ScalarProperty Name="CompletedByID" ColumnName="CompletedByID" />
            <ScalarProperty Name="Description" ColumnName="Description" />
            <ScalarProperty Name="Comments" ColumnName="Comments" />
            <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
            <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
            <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
            <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
          </MappingFragment></EntityTypeMapping></EntitySetMapping>
          <EntitySetMapping Name="WorkflowTaskHandlers"><EntityTypeMapping TypeName="Workflows.WorkflowTaskHandler"><MappingFragment StoreEntitySet="WorkflowTaskHandlers">
            <ScalarProperty Name="WorkflowTaskHandlerID" ColumnName="WorkflowTaskHandlerID" />
            <ScalarProperty Name="WorkflowID" ColumnName="WorkflowID" />
            <ScalarProperty Name="HandlerTypeName" ColumnName="HandlerTypeName" />
            <ScalarProperty Name="MethodName" ColumnName="MethodName" />
            <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
            <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
            <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
            <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
            <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
          </MappingFragment></EntityTypeMapping></EntitySetMapping>
          <EntitySetMapping Name="WorkflowTemplateSteps">
            <EntityTypeMapping TypeName="Workflows.WorkflowTemplateStep">
              <MappingFragment StoreEntitySet="WorkflowTemplateSteps">
                <ScalarProperty Name="CanAutoExpire" ColumnName="CanAutoExpire" />
                <ScalarProperty Name="IsRequiredXml" ColumnName="IsRequiredXml" />
                <ScalarProperty Name="StepReassignRoles" ColumnName="StepReassignRoles" />
                <ScalarProperty Name="StepApplicationRoles" ColumnName="StepApplicationRoles" />
                <ScalarProperty Name="StepNextPossibles" ColumnName="StepNextPossibles" />
                <ScalarProperty Name="IsEmailRequired" ColumnName="IsEmailRequired" />
                <ScalarProperty Name="IsRequiredScript" ColumnName="IsRequiredScript" />
                <ScalarProperty Name="WorkflowTaskHandlerID" ColumnName="WorkflowTaskHandlerID" />
                <ScalarProperty Name="IsDefaultStep" ColumnName="IsDefaultStep" />
                <ScalarProperty Name="StepDurationOvertime" ColumnName="StepDurationOvertime" />
                <ScalarProperty Name="StepDurationWarning" ColumnName="StepDurationWarning" />
                <ScalarProperty Name="StepDescription" ColumnName="StepDescription" />
                <ScalarProperty Name="StepTitle" ColumnName="StepTitle" />
                <ScalarProperty Name="StepNext" ColumnName="StepNext" />
                <ScalarProperty Name="StepParent" ColumnName="StepParent" />
                <ScalarProperty Name="Step" ColumnName="Step" />
                <ScalarProperty Name="Branch" ColumnName="Branch" />
                <ScalarProperty Name="WorkflowTemplateStepTypeID" ColumnName="WorkflowTemplateStepTypeID" />
                <ScalarProperty Name="WorkflowTemplateID" ColumnName="WorkflowTemplateID" />
                <ScalarProperty Name="WorkflowTemplateStepID" ColumnName="WorkflowTemplateStepID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="Pr_WorkflowInstanceTaskAction" FunctionName="Workflows.Store.Pr_WorkflowInstanceTaskAction" />
          <FunctionImportMapping FunctionImportName="Pr_WorkflowInstanceTaskActionFailover" FunctionName="Workflows.Store.Pr_WorkflowInstanceTaskActionFailover" />
          <EntitySetMapping Name="WorkflowTaskHandlerSettings">
            <EntityTypeMapping TypeName="Workflows.WorkflowTaskHandlerSetting">
              <MappingFragment StoreEntitySet="WorkflowTaskHandlerSettings">
                <ScalarProperty Name="SettingValue" ColumnName="SettingValue" />
                <ScalarProperty Name="SettingKey" ColumnName="SettingKey" />
                <ScalarProperty Name="WorkflowTaskHandlerID" ColumnName="WorkflowTaskHandlerID" />
                <ScalarProperty Name="WorkflowTaskHandlerSettingID" ColumnName="WorkflowTaskHandlerSettingID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="Pr_WorkflowInstanceRaiseException" FunctionName="Workflows.Store.Pr_WorkflowInstanceRaiseException" />
        </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" />
        <DesignerProperty Name="UseLegacyProvider" Value="True" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams>
      <Diagram Name="WorkflowModel">
        <EntityTypeShape EntityType="Workflows.WorkflowInstanceTask" Width="2.375" PointX="7.125" PointY="0.5" Height="4.2879036458333317" IsExpanded="true" />
        <EntityTypeShape EntityType="Workflows.WorkflowTaskHandler" Width="2.375" PointX="0.5" PointY="0.5" Height="3.1340950520833331" IsExpanded="true" />
        <EntityTypeShape EntityType="Workflows.WorkflowTemplateStep" Width="2.375" PointX="3.625" PointY="0.5" Height="5.0571093749999987" />
        <AssociationConnector Association="Workflows.FK_WorkflowInstanceTasks_WorkflowTemplateSteps" >
          <ConnectorPoint PointX="6" PointY="2.6439518229166659" />
          <ConnectorPoint PointX="7.125" PointY="2.6439518229166659" />
        </AssociationConnector>
        <AssociationConnector Association="Workflows.FK_WorkflowTemplateSteps_WorkflowTaskHandlers" >
          <ConnectorPoint PointX="2.875" PointY="2.0670475260416667" />
          <ConnectorPoint PointX="3.625" PointY="2.0670475260416667" />
        </AssociationConnector>
        <EntityTypeShape EntityType="Workflows.WorkflowTaskHandlerSetting" Width="2.25" PointX="0.5" PointY="4.375" Height="1.9802864583333317" />
        <AssociationConnector Association="Workflows.FK_WorkflowTaskHandlerSettings_WorkflowTaskHandlers" >
          <ConnectorPoint PointX="1.625" PointY="3.6340950520833331" />
          <ConnectorPoint PointX="1.625" PointY="4.375" />
        </AssociationConnector>
      </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>