﻿<?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="NewVehicleModel.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="NewVehicleModelStoreContainer">
          <EntitySet Name="NewVehicleRequestDetails" EntityType="NewVehicleModel.Store.NewVehicleRequestDetails" store:Type="Tables" Schema="App" />
        </EntityContainer>
        <EntityType Name="NewVehicleRequestDetails">
          <Key>
            <PropertyRef Name="NewVehicleRequestDetailID" />
          </Key>
          <Property Name="NewVehicleRequestDetailID" 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="NewVehicleRequestTypeID" Type="smallint" Nullable="false" />
          <Property Name="RegistrationNumber" Type="varchar" MaxLength="50" />
          <Property Name="EngineNumber" Type="varchar" MaxLength="50" />
          <Property Name="VIN" Type="varchar" MaxLength="50" />
          <Property Name="SeatedCapacity" Type="int" />
          <Property Name="StandingCapacity" Type="int" />
          <Property Name="GrossMass" Type="int" />
          <Property Name="VehicleMakeID" Type="smallint" />
          <Property Name="VehicleTypeID" Type="smallint" />
          <Property Name="VerifiedVehicleID" Type="bigint" />
        </EntityType>
      </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="NewVehicleContext" annotation:LazyLoadingEnabled="false">
          <FunctionImport Name="Pr_NewVehicleRequestDetailsSearch">
            <Parameter Name="NewVehicleRequestDetailID" Mode="In" Type="Int64" />
            <Parameter Name="WorkflowInstanceStatusID" Mode="In" Type="Int16" />
          </FunctionImport>
          <EntitySet Name="NewVehicleRequestDetails" EntityType="Model.NewVehicleRequestDetail" />
        </EntityContainer>
        <EntityType Name="NewVehicleRequestDetail">
          <Key>
            <PropertyRef Name="NewVehicleRequestDetailID" />
          </Key>
          <Property Type="Int64" Name="NewVehicleRequestDetailID" 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="Int16" Name="NewVehicleRequestTypeID" Nullable="false" />
          <Property Type="String" Name="RegistrationNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="EngineNumber" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="VIN" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Type="Int32" Name="SeatedCapacity" />
          <Property Type="Int32" Name="StandingCapacity" />
          <Property Type="Int32" Name="GrossMass" />
          <Property Type="Int16" Name="VehicleMakeID" />
          <Property Type="Int16" Name="VehicleTypeID" />
          <Property Type="Int64" Name="VerifiedVehicleID" />
        </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="NewVehicleModelStoreContainer" CdmEntityContainer="NewVehicleContext">
          <EntitySetMapping Name="NewVehicleRequestDetails">
            <EntityTypeMapping TypeName="Model.NewVehicleRequestDetail">
              <MappingFragment StoreEntitySet="NewVehicleRequestDetails">
                <ScalarProperty Name="VerifiedVehicleID" ColumnName="VerifiedVehicleID" />
                <ScalarProperty Name="VehicleTypeID" ColumnName="VehicleTypeID" />
                <ScalarProperty Name="VehicleMakeID" ColumnName="VehicleMakeID" />
                <ScalarProperty Name="GrossMass" ColumnName="GrossMass" />
                <ScalarProperty Name="StandingCapacity" ColumnName="StandingCapacity" />
                <ScalarProperty Name="SeatedCapacity" ColumnName="SeatedCapacity" />
                <ScalarProperty Name="VIN" ColumnName="VIN" />
                <ScalarProperty Name="EngineNumber" ColumnName="EngineNumber" />
                <ScalarProperty Name="RegistrationNumber" ColumnName="RegistrationNumber" />
                <ScalarProperty Name="NewVehicleRequestTypeID" ColumnName="NewVehicleRequestTypeID" />
                <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="NewVehicleRequestDetailID" ColumnName="NewVehicleRequestDetailID" />
              </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="NewVehicleModel" ZoomLevel="74">
        <EntityTypeShape EntityType="Model.NewVehicleRequestDetail" Width="1.5" PointX="8.8957475912271757" PointY="16.819636874282562" />
      </Diagram>
    </Diagrams>
  </Designer>
</edmx:Edmx>