﻿<?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="Legitimate_LTPSModel.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="LtpsData">
          <Key>
            <PropertyRef Name="LtpsDataID" />
          </Key>
          <Property Name="ApplicationNumber" Type="varchar" MaxLength="50" Nullable="false" />
          <Property Name="ApplicationDate" Type="varchar" MaxLength="50" />
          <Property Name="ApplicationStatus" Type="varchar" MaxLength="50" />
          <Property Name="ApplicationType" Type="varchar" MaxLength="50" />
          <Property Name="ReceiptNumber" Type="varchar" MaxLength="50" />
          <Property Name="ApplicantReference" Type="varchar" MaxLength="50" />
          <Property Name="IDNumber" Type="varchar" MaxLength="50" />
          <Property Name="FirstName" Type="varchar" MaxLength="50" />
          <Property Name="LastName" Type="varchar" MaxLength="50" />
          <Property Name="Initials" Type="varchar" MaxLength="50" />
          <Property Name="TelephoneNumber" Type="varchar" MaxLength="50" />
          <Property Name="FaxNumber" Type="varchar" MaxLength="50" />
          <Property Name="EmailAddress" Type="varchar" MaxLength="50" />
          <Property Name="RouteNumber" Type="varchar" MaxLength="50" />
          <Property Name="Origin" Type="varchar" MaxLength="50" />
          <Property Name="Destination" Type="varchar" MaxLength="50" />
          <Property Name="PermitNumber" Type="varchar" MaxLength="50" />
          <Property Name="PermitIssue" Type="varchar" MaxLength="50" />
          <Property Name="PermitDate" Type="varchar" MaxLength="50" />
          <Property Name="PermitType" Type="varchar" MaxLength="50" />
          <Property Name="PermitStatus" Type="varchar" MaxLength="50" />
          <Property Name="StartDate" Type="varchar" MaxLength="50" />
          <Property Name="EndDate" Type="varchar" MaxLength="50" />
          <Property Name="CertificateNumber" Type="varchar" MaxLength="50" />
          <Property Name="PassengerType" Type="varchar" MaxLength="50" />
          <Property Name="VehicleReference" Type="varchar" MaxLength="50" />
          <Property Name="VehicleType" Type="varchar" MaxLength="50" />
          <Property Name="VehicleMake" Type="varchar" MaxLength="50" />
          <Property Name="RegistrationNumber" Type="varchar" MaxLength="50" />
          <Property Name="ChassisNumber" Type="varchar" MaxLength="50" />
          <Property Name="EngineNumber" Type="varchar" MaxLength="50" />
          <Property Name="GrossMass" Type="varchar" MaxLength="50" />
          <Property Name="SeatingCapacity" Type="varchar" MaxLength="50" />
          <Property Name="COFExpiry" Type="varchar" MaxLength="50" />
          <Property Name="COFReferenceNumber" Type="varchar" MaxLength="50" />
          <Property Name="NatisNumber" Type="varchar" MaxLength="50" />
          <Property Name="AssociationReference" Type="varchar" MaxLength="50" />
          <Property Name="AssociationName" Type="varchar" MaxLength="50" />
          <Property Name="AssociationStatus" Type="varchar" MaxLength="50" />
          <Property Name="PhysicalAddressCode" Type="varchar" MaxLength="50" />
          <Property Name="PhysicalAddressline1" Type="varchar" MaxLength="50" />
          <Property Name="PhysicalAddressline2" Type="varchar" MaxLength="50" />
          <Property Name="PhysicalAddressline3" Type="varchar" MaxLength="50" />
          <Property Name="LtpsDataID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="RecordAddedManually" Type="bit" Nullable="false" />
          <Property Name="RecordAddedByID" Type="bigint" />
        </EntityType>
        <Function Name="Pr_LtpsDataInsert" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="ApplicationNumber" Type="varchar" Mode="In" />
          <Parameter Name="ApplicationDate" Type="varchar" Mode="In" />
          <Parameter Name="ApplicationType" Type="varchar" Mode="In" />
          <Parameter Name="ReceiptNumber" Type="varchar" Mode="In" />
          <Parameter Name="IDNumber" Type="varchar" Mode="In" />
          <Parameter Name="FirstName" Type="varchar" Mode="In" />
          <Parameter Name="LastName" Type="varchar" Mode="In" />
          <Parameter Name="Initials" Type="varchar" Mode="In" />
          <Parameter Name="PermitNumber" Type="varchar" Mode="In" />
          <Parameter Name="StartDate" Type="varchar" Mode="In" />
          <Parameter Name="EndDate" Type="varchar" Mode="In" />
          <Parameter Name="UserID" Type="bigint" Mode="In" />
        </Function>
        <EntityContainer Name="Legitimate_LTPSModelStoreContainer">
          <EntitySet Name="LtpsData" EntityType="Self.LtpsData" Schema="dbo" store:Type="Tables" />
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="LtpsModel" 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">
        <EntityContainer Name="LtpsEntities" annotation:LazyLoadingEnabled="true" >
          <EntitySet Name="LtpsData" EntityType="LtpsModel.LtpsData" />
          <FunctionImport Name="Pr_LtpsDataInsert">
            <Parameter Name="ApplicationNumber" Mode="In" Type="String" />
            <Parameter Name="ApplicationDate" Mode="In" Type="String" />
            <Parameter Name="ApplicationType" Mode="In" Type="String" />
            <Parameter Name="ReceiptNumber" Mode="In" Type="String" />
            <Parameter Name="IDNumber" Mode="In" Type="String" />
            <Parameter Name="FirstName" Mode="In" Type="String" />
            <Parameter Name="LastName" Mode="In" Type="String" />
            <Parameter Name="Initials" Mode="In" Type="String" />
            <Parameter Name="PermitNumber" Mode="In" Type="String" />
            <Parameter Name="StartDate" Mode="In" Type="String" />
            <Parameter Name="EndDate" Mode="In" Type="String" />
            <Parameter Name="UserID" Mode="In" Type="Int64" />
          </FunctionImport>
        </EntityContainer>
        <EntityType Name="LtpsData">
          <Key>
            <PropertyRef Name="LtpsDataID" />
          </Key>
          <Property Name="ApplicationNumber" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ApplicationDate" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ApplicationStatus" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ApplicationType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ReceiptNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ApplicantReference" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="IDNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="FirstName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="LastName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Initials" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="TelephoneNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="FaxNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="EmailAddress" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="RouteNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Origin" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="Destination" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PermitNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PermitIssue" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PermitDate" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PermitType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PermitStatus" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="StartDate" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="EndDate" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="CertificateNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PassengerType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="VehicleReference" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="VehicleType" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="VehicleMake" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="RegistrationNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="ChassisNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="EngineNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="GrossMass" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="SeatingCapacity" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="COFExpiry" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="COFReferenceNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="NatisNumber" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="AssociationReference" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="AssociationName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="AssociationStatus" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PhysicalAddressCode" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PhysicalAddressline1" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PhysicalAddressline2" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="PhysicalAddressline3" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
          <Property Name="LtpsDataID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="RecordAddedManually" Type="Boolean" Nullable="false" />
          <Property Name="RecordAddedByID" Type="Int64" />
        </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="Legitimate_LTPSModelStoreContainer" CdmEntityContainer="LtpsEntities" >
          <EntitySetMapping Name="LtpsData">
            <EntityTypeMapping TypeName="LtpsModel.LtpsData">
              <MappingFragment StoreEntitySet="LtpsData">
                <ScalarProperty Name="RecordAddedByID" ColumnName="RecordAddedByID" />
                <ScalarProperty Name="RecordAddedManually" ColumnName="RecordAddedManually" />
                <ScalarProperty Name="LtpsDataID" ColumnName="LtpsDataID" />
                <ScalarProperty Name="PhysicalAddressline3" ColumnName="PhysicalAddressline3" />
                <ScalarProperty Name="PhysicalAddressline2" ColumnName="PhysicalAddressline2" />
                <ScalarProperty Name="PhysicalAddressline1" ColumnName="PhysicalAddressline1" />
                <ScalarProperty Name="PhysicalAddressCode" ColumnName="PhysicalAddressCode" />
                <ScalarProperty Name="AssociationStatus" ColumnName="AssociationStatus" />
                <ScalarProperty Name="AssociationName" ColumnName="AssociationName" />
                <ScalarProperty Name="AssociationReference" ColumnName="AssociationReference" />
                <ScalarProperty Name="NatisNumber" ColumnName="NatisNumber" />
                <ScalarProperty Name="COFReferenceNumber" ColumnName="COFReferenceNumber" />
                <ScalarProperty Name="COFExpiry" ColumnName="COFExpiry" />
                <ScalarProperty Name="SeatingCapacity" ColumnName="SeatingCapacity" />
                <ScalarProperty Name="GrossMass" ColumnName="GrossMass" />
                <ScalarProperty Name="EngineNumber" ColumnName="EngineNumber" />
                <ScalarProperty Name="ChassisNumber" ColumnName="ChassisNumber" />
                <ScalarProperty Name="RegistrationNumber" ColumnName="RegistrationNumber" />
                <ScalarProperty Name="VehicleMake" ColumnName="VehicleMake" />
                <ScalarProperty Name="VehicleType" ColumnName="VehicleType" />
                <ScalarProperty Name="VehicleReference" ColumnName="VehicleReference" />
                <ScalarProperty Name="PassengerType" ColumnName="PassengerType" />
                <ScalarProperty Name="CertificateNumber" ColumnName="CertificateNumber" />
                <ScalarProperty Name="EndDate" ColumnName="EndDate" />
                <ScalarProperty Name="StartDate" ColumnName="StartDate" />
                <ScalarProperty Name="PermitStatus" ColumnName="PermitStatus" />
                <ScalarProperty Name="PermitType" ColumnName="PermitType" />
                <ScalarProperty Name="PermitDate" ColumnName="PermitDate" />
                <ScalarProperty Name="PermitIssue" ColumnName="PermitIssue" />
                <ScalarProperty Name="PermitNumber" ColumnName="PermitNumber" />
                <ScalarProperty Name="Destination" ColumnName="Destination" />
                <ScalarProperty Name="Origin" ColumnName="Origin" />
                <ScalarProperty Name="RouteNumber" ColumnName="RouteNumber" />
                <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
                <ScalarProperty Name="FaxNumber" ColumnName="FaxNumber" />
                <ScalarProperty Name="TelephoneNumber" ColumnName="TelephoneNumber" />
                <ScalarProperty Name="Initials" ColumnName="Initials" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="IDNumber" ColumnName="IDNumber" />
                <ScalarProperty Name="ApplicantReference" ColumnName="ApplicantReference" />
                <ScalarProperty Name="ReceiptNumber" ColumnName="ReceiptNumber" />
                <ScalarProperty Name="ApplicationType" ColumnName="ApplicationType" />
                <ScalarProperty Name="ApplicationStatus" ColumnName="ApplicationStatus" />
                <ScalarProperty Name="ApplicationDate" ColumnName="ApplicationDate" />
                <ScalarProperty Name="ApplicationNumber" ColumnName="ApplicationNumber" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="Pr_LtpsDataInsert" FunctionName="Legitimate_LTPSModel.Store.Pr_LtpsDataInsert" />
        </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>