﻿<?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="Model.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityContainer Name="ModelStoreContainer">
          <EntitySet Name="CaptureFields" EntityType="Model.Store.CaptureFields" store:Type="Tables" Schema="Form" />
          <EntitySet Name="ChecklistResults" EntityType="Model.Store.ChecklistResults" store:Type="Tables" Schema="Form" />
          <EntitySet Name="ChecklistTemplateQuestions" EntityType="Model.Store.ChecklistTemplateQuestions" store:Type="Tables" Schema="Form" />
          <EntitySet Name="ChecklistTemplates" EntityType="Model.Store.ChecklistTemplates" store:Type="Tables" Schema="Form" />
          <EntitySet Name="ChecklistTemplateStatus" EntityType="Model.Store.ChecklistTemplateStatus" store:Type="Tables" Schema="Form" />
          <EntitySet Name="HyperLinks" EntityType="Model.Store.HyperLinks" store:Type="Tables" Schema="Form" />
          <EntitySet Name="LayoutDataSources" EntityType="Model.Store.LayoutDataSources" store:Type="Tables" Schema="Form" />
          <EntitySet Name="Layouts" EntityType="Model.Store.Layouts" store:Type="Tables" Schema="Form" />
          <AssociationSet Name="FK_ChecklistResults_ChecklistTemplateQuestions" Association="Model.Store.FK_ChecklistResults_ChecklistTemplateQuestions">
            <End Role="ChecklistTemplateQuestions" EntitySet="ChecklistTemplateQuestions" />
            <End Role="ChecklistResults" EntitySet="ChecklistResults" />
          </AssociationSet>
          <AssociationSet Name="FK_ChecklistTemplates_ChecklistTemplateStatus" Association="Model.Store.FK_ChecklistTemplates_ChecklistTemplateStatus">
            <End Role="ChecklistTemplateStatus" EntitySet="ChecklistTemplateStatus" />
            <End Role="ChecklistTemplates" EntitySet="ChecklistTemplates" />
          </AssociationSet>
          <AssociationSet Name="FK_LayoutDataSources_Layouts" Association="Model.Store.FK_LayoutDataSources_Layouts">
            <End Role="Layouts" EntitySet="Layouts" />
            <End Role="LayoutDataSources" EntitySet="LayoutDataSources" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="CaptureFields">
          <Key>
            <PropertyRef Name="CaptureFieldID" />
          </Key>
          <Property Name="CaptureFieldID" Type="smallint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Description" Type="varchar" Nullable="false" MaxLength="100" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="ChecklistResults">
          <Key>
            <PropertyRef Name="ChecklistResultID" />
          </Key>
          <Property Name="ChecklistResultID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="EntityID" Type="int" Nullable="false" />
          <Property Name="ItemID" Type="bigint" Nullable="false" />
          <Property Name="ChecklistTemplateQuestionID" Type="bigint" Nullable="false" />
          <Property Name="Result" Type="varchar" MaxLength="1000" />
          <Property Name="Comments" Type="varchar" MaxLength="1000" />
          <Property Name="CreatedByID" Type="bigint" />
          <Property Name="CreadtedDate" Type="datetime" />
          <Property Name="UpdatedByID" Type="bigint" />
          <Property Name="UpdatedDate" Type="datetime" />
        </EntityType>
        <EntityType Name="ChecklistTemplateQuestions">
          <Key>
            <PropertyRef Name="ChecklistTemplateQuestionID" />
          </Key>
          <Property Name="ChecklistTemplateQuestionID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="ChecklistTemplateID" Type="bigint" Nullable="false" />
          <Property Name="CaptureFieldID" Type="smallint" Nullable="false" />
          <Property Name="Question" Type="varchar" Nullable="false" MaxLength="2000" />
          <Property Name="CommentLabel" Type="varchar" MaxLength="100" />
          <Property Name="RelatedLinks" Type="varchar(max)" />
          <Property Name="OrderBy" Type="bigint" Nullable="false" />
          <Property Name="DataSourceName" Type="varchar" MaxLength="50" />
          <Property Name="DataSourceCriteria" Type="varchar" MaxLength="50" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="ChecklistTemplates">
          <Key>
            <PropertyRef Name="ChecklistTemplateID" />
          </Key>
          <Property Name="ChecklistTemplateID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="EntityID" Type="int" Nullable="false" />
          <Property Name="ItemID" Type="bigint" Nullable="false" />
          <Property Name="ChecklistTemplateStatusID" Type="smallint" Nullable="false" />
          <Property Name="ChecklistTitle" Type="varchar" Nullable="false" MaxLength="255" />
          <Property Name="Version" Type="smallint" Nullable="false" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="ChecklistTemplateStatus">
          <Key>
            <PropertyRef Name="ChecklistTemplateStatusID" />
          </Key>
          <Property Name="ChecklistTemplateStatusID" Type="smallint" Nullable="false" />
          <Property Name="Description" Type="varchar" Nullable="false" MaxLength="255" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="HyperLinks">
          <Key>
            <PropertyRef Name="HyperLinkID" />
          </Key>
          <Property Name="HyperLinkID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="EntityID" Type="int" Nullable="false" />
          <Property Name="ItemID" Type="bigint" Nullable="false" />
          <Property Name="Title" Type="varchar" Nullable="false" MaxLength="255" />
          <Property Name="Description" Type="varchar" MaxLength="2000" />
          <Property Name="Url" Type="varchar" Nullable="false" MaxLength="1000" />
          <Property Name="ThumbnailUrl" Type="varchar" MaxLength="1000" />
          <Property Name="OpenInNewWindow" Type="bit" Nullable="false" />
          <Property Name="OrderBy" Type="int" 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" />
          <Property Name="IsCancelled" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="LayoutDataSources">
          <Key>
            <PropertyRef Name="LayoutID" />
            <PropertyRef Name="DataSourceID" />
          </Key>
          <Property Name="LayoutID" Type="bigint" Nullable="false" />
          <Property Name="DataSourceID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Layouts">
          <Key>
            <PropertyRef Name="LayoutID" />
          </Key>
          <Property Name="LayoutID" Type="bigint" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="varchar" Nullable="false" MaxLength="255" />
          <Property Name="Html" Type="varchar(max)" Nullable="false" />
          <Property Name="ScriptUi" Type="varchar(max)" Nullable="false" />
          <Property Name="ScriptValidation" Type="varchar(max)" Nullable="false" />
          <Property Name="ScriptEvents" Type="varchar(max)" Nullable="false" />
        </EntityType>
        <Association Name="FK_ChecklistResults_ChecklistTemplateQuestions">
          <End Role="ChecklistTemplateQuestions" Type="Model.Store.ChecklistTemplateQuestions" Multiplicity="1" />
          <End Role="ChecklistResults" Type="Model.Store.ChecklistResults" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ChecklistTemplateQuestions">
              <PropertyRef Name="ChecklistTemplateQuestionID" />
            </Principal>
            <Dependent Role="ChecklistResults">
              <PropertyRef Name="ChecklistTemplateQuestionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ChecklistTemplates_ChecklistTemplateStatus">
          <End Role="ChecklistTemplateStatus" Type="Model.Store.ChecklistTemplateStatus" Multiplicity="1" />
          <End Role="ChecklistTemplates" Type="Model.Store.ChecklistTemplates" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ChecklistTemplateStatus">
              <PropertyRef Name="ChecklistTemplateStatusID" />
            </Principal>
            <Dependent Role="ChecklistTemplates">
              <PropertyRef Name="ChecklistTemplateStatusID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_LayoutDataSources_Layouts">
          <End Role="Layouts" Type="Model.Store.Layouts" Multiplicity="1" />
          <End Role="LayoutDataSources" Type="Model.Store.LayoutDataSources" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Layouts">
              <PropertyRef Name="LayoutID" />
            </Principal>
            <Dependent Role="LayoutDataSources">
              <PropertyRef Name="LayoutID" />
            </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="AfxAdminFormContext" annotation:LazyLoadingEnabled="false">
          <EntitySet Name="CaptureFields" EntityType="Model.CaptureField" />
          <EntitySet Name="ChecklistResults" EntityType="Model.ChecklistResult" />
          <EntitySet Name="ChecklistTemplateQuestions" EntityType="Model.ChecklistTemplateQuestion" />
          <EntitySet Name="ChecklistTemplates" EntityType="Model.ChecklistTemplate" />
          <EntitySet Name="ChecklistTemplateStatus" EntityType="Model.ChecklistTemplateStatus" />
          <EntitySet Name="HyperLinks" EntityType="Model.HyperLink" />
          <EntitySet Name="LayoutDataSources" EntityType="Model.LayoutDataSource" />
          <EntitySet Name="Layouts" EntityType="Model.Layout" />
          <AssociationSet Name="FK_ChecklistTemplateQuestions_CaptureFields" Association="Model.FK_ChecklistTemplateQuestions_CaptureFields">
            <End Role="CaptureFields" EntitySet="CaptureFields" />
            <End Role="ChecklistTemplateQuestions" EntitySet="ChecklistTemplateQuestions" />
          </AssociationSet>
          <AssociationSet Name="FK_ChecklistResults_ChecklistTemplateQuestions" Association="Model.FK_ChecklistResults_ChecklistTemplateQuestions">
            <End Role="ChecklistTemplateQuestions" EntitySet="ChecklistTemplateQuestions" />
            <End Role="ChecklistResults" EntitySet="ChecklistResults" />
          </AssociationSet>
          <AssociationSet Name="FK_ChecklistTemplateQuestions_ChecklistTemplates" Association="Model.FK_ChecklistTemplateQuestions_ChecklistTemplates">
            <End Role="ChecklistTemplates" EntitySet="ChecklistTemplates" />
            <End Role="ChecklistTemplateQuestions" EntitySet="ChecklistTemplateQuestions" />
          </AssociationSet>
          <AssociationSet Name="FK_ChecklistTemplates_ChecklistTemplateStatus" Association="Model.FK_ChecklistTemplates_ChecklistTemplateStatus">
            <End Role="ChecklistTemplateStatus" EntitySet="ChecklistTemplateStatus" />
            <End Role="ChecklistTemplates" EntitySet="ChecklistTemplates" />
          </AssociationSet>
          <AssociationSet Name="FK_LayoutDataSources_Layouts" Association="Model.FK_LayoutDataSources_Layouts">
            <End Role="Layouts" EntitySet="Layouts" />
            <End Role="LayoutDataSources" EntitySet="LayoutDataSources" />
          </AssociationSet>
          </EntityContainer>
        <EntityType Name="CaptureField">
          <Key>
            <PropertyRef Name="CaptureFieldID" />
          </Key>
          <Property Name="CaptureFieldID" Type="Int16" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Description" Type="String" Nullable="false" MaxLength="100" Unicode="false" FixedLength="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="ChecklistTemplateQuestions" Relationship="Model.FK_ChecklistTemplateQuestions_CaptureFields" FromRole="CaptureFields" ToRole="ChecklistTemplateQuestions" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" />
        </EntityType>
        <EntityType Name="ChecklistResult">
          <Key>
            <PropertyRef Name="ChecklistResultID" />
          </Key>
          <Property Name="ChecklistResultID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="EntityID" Type="Int32" Nullable="false" />
          <Property Name="ItemID" Type="Int64" Nullable="false" />
          <Property Name="ChecklistTemplateQuestionID" Type="Int64" Nullable="false" />
          <Property Name="Result" Type="String" MaxLength="1000" Unicode="false" FixedLength="false" />
          <Property Name="Comments" Type="String" MaxLength="1000" Unicode="false" FixedLength="false" />
          <Property Name="CreatedByID" Type="Int64" />
          <Property Name="CreadtedDate" Type="DateTime" />
          <Property Name="UpdatedByID" Type="Int64" />
          <Property Name="UpdatedDate" Type="DateTime" />
          <NavigationProperty Name="ChecklistTemplateQuestion" Relationship="Model.FK_ChecklistResults_ChecklistTemplateQuestions" FromRole="ChecklistResults" ToRole="ChecklistTemplateQuestions" />
        </EntityType>
        <EntityType Name="ChecklistTemplateQuestion">
          <Key>
            <PropertyRef Name="ChecklistTemplateQuestionID" />
          </Key>
          <Property Name="ChecklistTemplateQuestionID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="ChecklistTemplateID" Type="Int64" Nullable="false" />
          <Property Name="CaptureFieldID" Type="Int16" Nullable="false" />
          <Property Name="Question" Type="String" Nullable="false" MaxLength="2000" Unicode="false" FixedLength="false" />
          <Property Name="CommentLabel" Type="String" MaxLength="100" Unicode="false" FixedLength="false" />
          <Property Name="RelatedLinks" Type="String" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="OrderBy" Type="Int64" Nullable="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="CaptureField" Relationship="Model.FK_ChecklistTemplateQuestions_CaptureFields" FromRole="ChecklistTemplateQuestions" ToRole="CaptureFields" a:GetterAccess="Public" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Public" />
          <NavigationProperty Name="ChecklistResults" Relationship="Model.FK_ChecklistResults_ChecklistTemplateQuestions" FromRole="ChecklistTemplateQuestions" ToRole="ChecklistResults" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" />
          <NavigationProperty Name="ChecklistTemplate" Relationship="Model.FK_ChecklistTemplateQuestions_ChecklistTemplates" FromRole="ChecklistTemplateQuestions" ToRole="ChecklistTemplates" a:GetterAccess="Public" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Public" />
          <Property Type="String" Name="DataSourceName" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="DataSourceCriteria" MaxLength="50" FixedLength="false" Unicode="false" />
        </EntityType>
        <EntityType Name="ChecklistTemplate">
          <Key>
            <PropertyRef Name="ChecklistTemplateID" />
          </Key>
          <Property Name="ChecklistTemplateID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="EntityID" Type="Int32" Nullable="false" />
          <Property Name="ItemID" Type="Int64" Nullable="false" />
          <Property Name="ChecklistTemplateStatusID" Type="Int16" Nullable="false" />
          <Property Name="ChecklistTitle" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="Version" Type="Int16" Nullable="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="ChecklistTemplateQuestions" Relationship="Model.FK_ChecklistTemplateQuestions_ChecklistTemplates" FromRole="ChecklistTemplates" ToRole="ChecklistTemplateQuestions" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" />
          <NavigationProperty Name="ChecklistTemplateStatus" Relationship="Model.FK_ChecklistTemplates_ChecklistTemplateStatus" FromRole="ChecklistTemplates" ToRole="ChecklistTemplateStatus" a:GetterAccess="Public" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Public" />
        </EntityType>
        <EntityType Name="ChecklistTemplateStatus">
          <Key>
            <PropertyRef Name="ChecklistTemplateStatusID" />
          </Key>
          <Property Name="ChecklistTemplateStatusID" Type="Int16" Nullable="false" />
          <Property Name="Description" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="ChecklistTemplates" Relationship="Model.FK_ChecklistTemplates_ChecklistTemplateStatus" FromRole="ChecklistTemplateStatus" ToRole="ChecklistTemplates" a:GetterAccess="Internal" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Internal" />
        </EntityType>
        <EntityType Name="HyperLink">
          <Key>
            <PropertyRef Name="HyperLinkID" />
          </Key>
          <Property Name="HyperLinkID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="EntityID" Type="Int32" Nullable="false" />
          <Property Name="ItemID" Type="Int64" Nullable="false" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="Description" Type="String" MaxLength="2000" Unicode="false" FixedLength="false" />
          <Property Name="Url" Type="String" Nullable="false" MaxLength="1000" Unicode="false" FixedLength="false" />
          <Property Name="ThumbnailUrl" Type="String" MaxLength="1000" Unicode="false" FixedLength="false" />
          <Property Name="OpenInNewWindow" Type="Boolean" Nullable="false" />
          <Property Name="OrderBy" Type="Int32" Nullable="false" />
          <Property Name="CreatedByID" Type="Int64" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" />
          <Property Name="UpdatedByID" Type="Int64" Nullable="false" />
          <Property Name="UpdatedDate" Type="DateTime" Nullable="false" />
          <Property Name="IsCancelled" Type="Boolean" Nullable="false" />
        </EntityType>
        <EntityType Name="LayoutDataSource">
          <Key>
            <PropertyRef Name="LayoutID" />
            <PropertyRef Name="DataSourceID" />
          </Key>
          <Property Name="LayoutID" Type="Int64" Nullable="false" />
          <Property Name="DataSourceID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Layout" Relationship="Model.FK_LayoutDataSources_Layouts" FromRole="LayoutDataSources" ToRole="Layouts" />
        </EntityType>
        <EntityType Name="Layout">
          <Key>
            <PropertyRef Name="LayoutID" />
          </Key>
          <Property Name="LayoutID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Title" Type="String" Nullable="false" MaxLength="255" Unicode="false" FixedLength="false" />
          <Property Name="Html" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="ScriptUi" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="ScriptValidation" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="ScriptEvents" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <NavigationProperty Name="LayoutDataSources" Relationship="Model.FK_LayoutDataSources_Layouts" FromRole="Layouts" ToRole="LayoutDataSources" />
        </EntityType>
        <Association Name="FK_ChecklistTemplateQuestions_CaptureFields">
          <End Role="CaptureFields" Type="Model.CaptureField" Multiplicity="1" />
          <End Role="ChecklistTemplateQuestions" Type="Model.ChecklistTemplateQuestion" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="CaptureFields">
              <PropertyRef Name="CaptureFieldID" />
            </Principal>
            <Dependent Role="ChecklistTemplateQuestions">
              <PropertyRef Name="CaptureFieldID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ChecklistResults_ChecklistTemplateQuestions">
          <End Role="ChecklistTemplateQuestions" Type="Model.ChecklistTemplateQuestion" Multiplicity="1" />
          <End Role="ChecklistResults" Type="Model.ChecklistResult" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ChecklistTemplateQuestions">
              <PropertyRef Name="ChecklistTemplateQuestionID" />
            </Principal>
            <Dependent Role="ChecklistResults">
              <PropertyRef Name="ChecklistTemplateQuestionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ChecklistTemplateQuestions_ChecklistTemplates">
          <End Role="ChecklistTemplates" Type="Model.ChecklistTemplate" Multiplicity="1" />
          <End Role="ChecklistTemplateQuestions" Type="Model.ChecklistTemplateQuestion" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ChecklistTemplates">
              <PropertyRef Name="ChecklistTemplateID" />
            </Principal>
            <Dependent Role="ChecklistTemplateQuestions">
              <PropertyRef Name="ChecklistTemplateID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ChecklistTemplates_ChecklistTemplateStatus">
          <End Role="ChecklistTemplateStatus" Type="Model.ChecklistTemplateStatus" Multiplicity="1" />
          <End Role="ChecklistTemplates" Type="Model.ChecklistTemplate" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ChecklistTemplateStatus">
              <PropertyRef Name="ChecklistTemplateStatusID" />
            </Principal>
            <Dependent Role="ChecklistTemplates">
              <PropertyRef Name="ChecklistTemplateStatusID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_LayoutDataSources_Layouts">
          <End Role="Layouts" Type="Model.Layout" Multiplicity="1" />
          <End Role="LayoutDataSources" Type="Model.LayoutDataSource" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Layouts">
              <PropertyRef Name="LayoutID" />
            </Principal>
            <Dependent Role="LayoutDataSources">
              <PropertyRef Name="LayoutID" />
            </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="ModelStoreContainer" CdmEntityContainer="AfxAdminFormContext">
          <EntitySetMapping Name="CaptureFields">
            <EntityTypeMapping TypeName="Model.CaptureField">
              <MappingFragment StoreEntitySet="CaptureFields">
                <ScalarProperty Name="CaptureFieldID" ColumnName="CaptureFieldID" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ChecklistResults">
            <EntityTypeMapping TypeName="Model.ChecklistResult">
              <MappingFragment StoreEntitySet="ChecklistResults">
                <ScalarProperty Name="ChecklistResultID" ColumnName="ChecklistResultID" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="ItemID" ColumnName="ItemID" />
                <ScalarProperty Name="ChecklistTemplateQuestionID" ColumnName="ChecklistTemplateQuestionID" />
                <ScalarProperty Name="Result" ColumnName="Result" />
                <ScalarProperty Name="Comments" ColumnName="Comments" />
                <ScalarProperty Name="CreatedByID" ColumnName="CreatedByID" />
                <ScalarProperty Name="CreadtedDate" ColumnName="CreadtedDate" />
                <ScalarProperty Name="UpdatedByID" ColumnName="UpdatedByID" />
                <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ChecklistTemplateQuestions">
            <EntityTypeMapping TypeName="Model.ChecklistTemplateQuestion">
              <MappingFragment StoreEntitySet="ChecklistTemplateQuestions">
                <ScalarProperty Name="DataSourceCriteria" ColumnName="DataSourceCriteria" />
                <ScalarProperty Name="DataSourceName" ColumnName="DataSourceName" />
                <ScalarProperty Name="ChecklistTemplateQuestionID" ColumnName="ChecklistTemplateQuestionID" />
                <ScalarProperty Name="ChecklistTemplateID" ColumnName="ChecklistTemplateID" />
                <ScalarProperty Name="CaptureFieldID" ColumnName="CaptureFieldID" />
                <ScalarProperty Name="Question" ColumnName="Question" />
                <ScalarProperty Name="CommentLabel" ColumnName="CommentLabel" />
                <ScalarProperty Name="RelatedLinks" ColumnName="RelatedLinks" />
                <ScalarProperty Name="OrderBy" ColumnName="OrderBy" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ChecklistTemplates">
            <EntityTypeMapping TypeName="Model.ChecklistTemplate">
              <MappingFragment StoreEntitySet="ChecklistTemplates">
                <ScalarProperty Name="ChecklistTemplateID" ColumnName="ChecklistTemplateID" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="ItemID" ColumnName="ItemID" />
                <ScalarProperty Name="ChecklistTemplateStatusID" ColumnName="ChecklistTemplateStatusID" />
                <ScalarProperty Name="ChecklistTitle" ColumnName="ChecklistTitle" />
                <ScalarProperty Name="Version" ColumnName="Version" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ChecklistTemplateStatus">
            <EntityTypeMapping TypeName="Model.ChecklistTemplateStatus">
              <MappingFragment StoreEntitySet="ChecklistTemplateStatus">
                <ScalarProperty Name="ChecklistTemplateStatusID" ColumnName="ChecklistTemplateStatusID" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="IsCancelled" ColumnName="IsCancelled" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="HyperLinks">
            <EntityTypeMapping TypeName="Model.HyperLink">
              <MappingFragment StoreEntitySet="HyperLinks">
                <ScalarProperty Name="HyperLinkID" ColumnName="HyperLinkID" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="ItemID" ColumnName="ItemID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Url" ColumnName="Url" />
                <ScalarProperty Name="ThumbnailUrl" ColumnName="ThumbnailUrl" />
                <ScalarProperty Name="OpenInNewWindow" ColumnName="OpenInNewWindow" />
                <ScalarProperty Name="OrderBy" ColumnName="OrderBy" />
                <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" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="LayoutDataSources">
            <EntityTypeMapping TypeName="Model.LayoutDataSource">
              <MappingFragment StoreEntitySet="LayoutDataSources">
                <ScalarProperty Name="LayoutID" ColumnName="LayoutID" />
                <ScalarProperty Name="DataSourceID" ColumnName="DataSourceID" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Layouts">
            <EntityTypeMapping TypeName="Model.Layout">
              <MappingFragment StoreEntitySet="Layouts">
                <ScalarProperty Name="LayoutID" ColumnName="LayoutID" />
                <ScalarProperty Name="Title" ColumnName="Title" />
                <ScalarProperty Name="Html" ColumnName="Html" />
                <ScalarProperty Name="ScriptUi" ColumnName="ScriptUi" />
                <ScalarProperty Name="ScriptValidation" ColumnName="ScriptValidation" />
                <ScalarProperty Name="ScriptEvents" ColumnName="ScriptEvents" />
              </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="FormModel">
        <EntityTypeShape EntityType="Model.CaptureField" Width="2.375" PointX="5.625" PointY="4.625" Height="1.7879850260416674" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.ChecklistResult" Width="2.375" PointX="8.625" PointY="0.5" Height="3.1340950520833317" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.ChecklistTemplateQuestion" Width="2.375" PointX="5.625" PointY="0.5" Height="3.1340950520833331" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.ChecklistTemplate" Width="2.125" PointX="3.125" PointY="0.75" Height="2.7494921874999996" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.ChecklistTemplateStatus" Width="2.125" PointX="0.5" PointY="1.125" Height="1.7879850260416674" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.HyperLink" Width="2.125" PointX="11.75" PointY="0.5" Height="3.7109993489583317" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.LayoutDataSource" Width="2" PointX="10.875" PointY="4.75" Height="1.5956835937499996" IsExpanded="true" />
        <EntityTypeShape EntityType="Model.Layout" Width="1.5" PointX="8.5" PointY="4.375" Height="2.3648893229166674" IsExpanded="true" />
        <AssociationConnector Association="Model.FK_ChecklistTemplateQuestions_CaptureFields" ManuallyRouted="false">
          <ConnectorPoint PointX="6.8125" PointY="4.625" />
          <ConnectorPoint PointX="6.8125" PointY="4.0186979166666665" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_ChecklistResults_ChecklistTemplateQuestions" ManuallyRouted="false">
          <ConnectorPoint PointX="8" PointY="2.1631982421875" />
          <ConnectorPoint PointX="8.625" PointY="2.1631982421875" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_ChecklistTemplateQuestions_ChecklistTemplates" ManuallyRouted="false">
          <ConnectorPoint PointX="5.25" PointY="2.2208968098958333" />
          <ConnectorPoint PointX="5.625" PointY="2.2208968098958333" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_ChecklistTemplates_ChecklistTemplateStatus" ManuallyRouted="false">
          <ConnectorPoint PointX="2.625" PointY="2.0189925130208337" />
          <ConnectorPoint PointX="3.125" PointY="2.0189925130208337" />
        </AssociationConnector>
        <AssociationConnector Association="Model.FK_LayoutDataSources_Layouts" ManuallyRouted="false">
          <ConnectorPoint PointX="10" PointY="5.547841796875" />
          <ConnectorPoint PointX="10.875" PointY="5.547841796875" />
        </AssociationConnector>
        </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>