<?xml version="1.0" encoding="iso-8859-1" standalone="yes"?>
<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
  <edmx:DataServices xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="1.0">
    <Schema Namespace="HGWPOIModel" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
      <EntityType Name="Places">
        <Key>
          <PropertyRef Name="id" />
        </Key>
        <Property Name="id" Type="Edm.Int32" Nullable="false" />
        <Property Name="company_name" Type="Edm.String" Nullable="true" />
        <Property Name="company_type" Type="Edm.String" Nullable="false" />
        <Property Name="category" Type="Edm.String" Nullable="true" />
        <Property Name="sub_category" Type="Edm.String" Nullable="true" />
        <Property Name="keywords" Type="Edm.String" Nullable="true" />
        <Property Name="status" Type="Edm.String" Nullable="false" />
        <Property Name="short_description" Type="Edm.String" Nullable="true" />
        <Property Name="operating_hrs" Type="Edm.String" Nullable="true" />
        <Property Name="block_number" Type="Edm.String" Nullable="true" />
        <Property Name="street_name" Type="Edm.String" Nullable="true" />
        <Property Name="street_name2" Type="Edm.String" Nullable="true" />
        <Property Name="unit" Type="Edm.String" Nullable="true" />
        <Property Name="building_name" Type="Edm.String" Nullable="true" />
        <Property Name="postal_code" Type="Edm.String" Nullable="true" />
        <Property Name="latitude" Type="Edm.Decimal" Nullable="true" />
        <Property Name="longitude" Type="Edm.Decimal" Nullable="true" />
        <Property Name="tel" Type="Edm.String" Nullable="true" />
        <Property Name="fax" Type="Edm.String" Nullable="true" />
        <Property Name="email" Type="Edm.String" Nullable="true" />
        <Property Name="website_url" Type="Edm.String" Nullable="true" />
        <Property Name="facebook_id" Type="Edm.String" Nullable="true" />
        <Property Name="twitter_id" Type="Edm.String" Nullable="true" />
        <Property Name="main_photo_url" Type="Edm.String" Nullable="true" />
        <Property Name="wifi" Type="Edm.String" Nullable="true" />
        <Property Name="payment_options" Type="Edm.String" Nullable="true" />
        <Property Name="food_menu_url" Type="Edm.String" Nullable="true" />
        <Property Name="food_corkage_policy" Type="Edm.String" Nullable="true" />
        <Property Name="food_cuisine" Type="Edm.String" Nullable="true" />
        <NavigationProperty Name="Places1" Relationship="HGWPOIModel.FK_Places_Places" FromRole="Places" ToRole="Places1" />
        <NavigationProperty Name="Places2" Relationship="HGWPOIModel.FK_Places_Places" FromRole="Places1" ToRole="Places" />
      </EntityType>
      <EntityType Name="Detail">
        <Key>
          <PropertyRef Name="id" />
          <PropertyRef Name="company_type" />
          <PropertyRef Name="status" />
        </Key>
        <Property Name="id" Type="Edm.Int32" Nullable="false" />
        <Property Name="parent_company_id" Type="Edm.Int32" Nullable="true" />
        <Property Name="company_name" Type="Edm.String" Nullable="true" MaxLength="500" Unicode="true" FixedLength="false" />
        <Property Name="company_type" Type="Edm.String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="category" Type="Edm.String" Nullable="true" MaxLength="400" Unicode="true" FixedLength="false" />
        <Property Name="sub_category" Type="Edm.String" Nullable="true" MaxLength="1000" Unicode="true" FixedLength="false" />
        <Property Name="keywords" Type="Edm.String" Nullable="true" MaxLength="500" Unicode="true" FixedLength="false" />
        <Property Name="status" Type="Edm.String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="short_description" Type="Edm.String" Nullable="true" MaxLength="3000" Unicode="true" FixedLength="false" />
        <Property Name="operating_hrs" Type="Edm.String" Nullable="true" MaxLength="1000" Unicode="true" FixedLength="false" />
        <Property Name="block_number" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="street_name" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="street_name2" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="unit" Type="Edm.String" Nullable="true" MaxLength="200" Unicode="true" FixedLength="false" />
        <Property Name="building_name" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="postal_code" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="latitude" Type="Edm.Decimal" Nullable="true" Precision="28" Scale="20" />
        <Property Name="longitude" Type="Edm.Decimal" Nullable="true" Precision="28" Scale="20" />
        <Property Name="tel" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="fax" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="email" Type="Edm.String" Nullable="true" MaxLength="100" Unicode="true" FixedLength="false" />
        <Property Name="website_url" Type="Edm.String" Nullable="true" MaxLength="400" Unicode="true" FixedLength="false" />
        <Property Name="facebook_id" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="twitter_id" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="main_photo_url" Type="Edm.String" Nullable="true" MaxLength="300" Unicode="true" FixedLength="false" />
        <Property Name="wifi" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="payment_options" Type="Edm.String" Nullable="true" MaxLength="100" Unicode="true" FixedLength="false" />
        <Property Name="food_menu_url" Type="Edm.String" Nullable="true" MaxLength="300" Unicode="true" FixedLength="false" />
        <Property Name="food_corkage_policy" Type="Edm.String" Nullable="true" MaxLength="400" Unicode="true" FixedLength="false" />
        <Property Name="food_cuisine" Type="Edm.String" Nullable="true" MaxLength="400" Unicode="true" FixedLength="false" />
      </EntityType>
      <EntityType Name="Search">
        <Key>
          <PropertyRef Name="id" />
          <PropertyRef Name="status" />
        </Key>
        <Property Name="id" Type="Edm.Int32" Nullable="false" />
        <Property Name="company_name" Type="Edm.String" Nullable="true" MaxLength="500" Unicode="true" FixedLength="false" />
        <Property Name="category" Type="Edm.String" Nullable="true" MaxLength="400" Unicode="true" FixedLength="false" />
        <Property Name="sub_category" Type="Edm.String" Nullable="true" MaxLength="1000" Unicode="true" FixedLength="false" />
        <Property Name="keywords" Type="Edm.String" Nullable="true" MaxLength="500" Unicode="true" FixedLength="false" />
        <Property Name="block_number" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="street_name" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="street_name2" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="unit" Type="Edm.String" Nullable="true" MaxLength="200" Unicode="true" FixedLength="false" />
        <Property Name="building_name" Type="Edm.String" Nullable="true" MaxLength="255" Unicode="true" FixedLength="false" />
        <Property Name="postal_code" Type="Edm.String" Nullable="true" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="status" Type="Edm.String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
        <Property Name="Distance" Type="Edm.Double" Nullable="true" />
      </EntityType>
      <Association Name="FK_Places_Places">
        <End Role="Places" Type="HGWPOIModel.Places" Multiplicity="0..1" />
        <End Role="Places1" Type="HGWPOIModel.Places" Multiplicity="*" />
      </Association>
    </Schema>
    <Schema Namespace="ServicesWebRole.EntityDataModels.HGWPOI" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
      <EntityContainer Name="HGWPOIEntities" m:IsDefaultEntityContainer="true">
        <FunctionImport Name="Places" EntitySet="Places" ReturnType="Collection(HGWPOIModel.Places)" m:HttpMethod="GET" />
        <FunctionImport Name="Search" EntitySet="Search" ReturnType="Collection(HGWPOIModel.Search)" m:HttpMethod="GET" />
        <FunctionImport Name="Detail" EntitySet="Detail" ReturnType="Collection(HGWPOIModel.Detail)" m:HttpMethod="GET" />
        <EntitySet Name="Places" EntityType="HGWPOIModel.Places" />
        <EntitySet Name="Detail" EntityType="HGWPOIModel.Detail" />
        <EntitySet Name="Search" EntityType="HGWPOIModel.Search" />
        <AssociationSet Name="FK_Places_Places" Association="HGWPOIModel.FK_Places_Places">
          <End Role="Places" EntitySet="Places" />
          <End Role="Places1" EntitySet="Places" />
        </AssociationSet>
      </EntityContainer>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>
