<?xml version="1.0" encoding="UTF-8"?>
<object>
  <className>Location</className>
  <tableName>location</tableName>
  <sequenceName>location_seq</sequenceName>
  <keyColumnName>location_id</keyColumnName>

  <!-- include all columns in table, except primary key ( do include foreign key columns) -->
  <column>
    <column_name>name</column_name>
    <property>name</property>
    <javaDataType>String</javaDataType>
    <treatAs>String</treatAs>
  </column>
  <column>
    <column_name>region_id</column_name>
    <property>regionId</property>
    <javaDataType>long</javaDataType>
    <treatAs>long</treatAs>
  </column>

  <toOneJoinedTable>
    <ClassName>Region</ClassName>
    <InstanceName>region</InstanceName>
    <PropertyName>regionId</PropertyName>                       
    <tableName>region</tableName>                       
    <joinTest>location.region_id = region.region_id</joinTest>
    <readOnly/>
    <column>
      <column_name>region_id</column_name>
      <javaDataType>String</javaDataType>
    </column>
    <column>
      <column_name>name</column_name>
      <property>regionName</property>
      <javaDataType>String</javaDataType>
      <includeGetSetMethodsFor/>
    </column>
    <column>
      <column_name>division_id</column_name>
      <property>divisionId</property>
      <javaDataType>long</javaDataType>
    </column>
  </toOneJoinedTable>

  <toOneJoinedTable>
    <ClassName>Division</ClassName>
    <InstanceName>division</InstanceName>
    <tableName>division</tableName>                       
    <joinTest>region.division_id = division.division_id</joinTest>
    <readOnly/>
    <column>
      <column_name>division_id</column_name>
      <javaDataType>String</javaDataType>
    </column>
    <column>
      <column_name>name</column_name>
      <property>divisionName</property>
      <javaDataType>String</javaDataType>
      <includeGetSetMethodsFor/>
    </column>
  </toOneJoinedTable>


</object>



