#############################
# Facility
############################
<table name="facility">
    <column name="id" type="INTEGER" primaryKey="true" autoIncrement="true" required="true" />
    <column name="title" type="VARCHAR" size="255" required="true"  />
    <column name="nice_title" type="VARCHAR" size="255" required="true"  />
    <column name="description" type="LONGVARCHAR" required="true" />
    <column name="district_id" type="INTEGER" />
    <column name="created_at" type="TIMESTAMP" />
    <column name="updated_at" type="TIMESTAMP" />
    <column name="author_id" type="INTEGER" required="true"  />
    <foreign-key foreignTable="district" onDelete="CASCADE">
      <reference local="district_id" foreign="id" />
    </foreign-key>
    <foreign-key foreignTable="user_profile" onDelete="CASCADE">
      <reference local="author_id" foreign="id" />
    </foreign-key>

  <unique name="unique_nice_title">
    <unique-column name="nice_title" />
  </unique>
</table>


##############################
# Region
##############################
  <table name="region">
    <column name="id" type="INTEGER" primaryKey="true" autoIncrement="true" required="true" />
    <column name="country_id" type="INTEGER" />
    <foreign-key foreignTable="country" onDelete="CASCADE">
      <reference local="country_id" foreign="id" />
    </foreign-key>
    <column name="title" type="VARCHAR" size="255" required="true"  />
    <column name="nice_title" type="VARCHAR" size="255" required="true"  />
    <column name="created_at" type="TIMESTAMP" />
    <column name="updated_at" type="TIMESTAMP" />
    <unique name="unique_nice_title">
      <unique-column name="nice_title" />
    </unique>
  </table>

###############################
# County
##############################
    <table name="county">
    <column name="id" type="INTEGER" primaryKey="true" autoIncrement="true" required="true" />
    <column name="country_id" type="INTEGER" />
    <foreign-key foreignTable="country" onDelete="CASCADE">
      <reference local="country_id" foreign="id" />
    </foreign-key>
    <column name="region_id" type="INTEGER" />
    <foreign-key foreignTable="region" onDelete="CASCADE">
      <reference local="region_id" foreign="id" />
    </foreign-key>
    <column name="title" type="VARCHAR" size="255" required="true"  />
    <column name="nice_title" type="VARCHAR" size="255" required="true"  />
    <column name="created_at" type="TIMESTAMP" />
    <column name="updated_at" type="TIMESTAMP" />
    <unique name="unique_nice_title">
      <unique-column name="nice_title" />
    </unique>
  </table>

###############################
# District
###############################
  <table name="district">
    <column name="id" type="INTEGER" primaryKey="true" autoIncrement="true" required="true" />
    <column name="title" type="VARCHAR" size="255" required="true"  />
    <column name="nice_title" type="VARCHAR" size="255" required="true"  />
    <column name="country_id" type="INTEGER" />
    <column name="region_id" type="INTEGER" />
    <column name="county_id" type="INTEGER" />
    <column name="created_at" type="TIMESTAMP" />
    <column name="updated_at" type="TIMESTAMP" />
    <!-- STATUSES FIELDS -->
    <foreign-key foreignTable="county" onDelete="CASCADE">
      <reference local="county_id" foreign="id" />
    </foreign-key>
    <foreign-key foreignTable="region" onDelete="CASCADE">
      <reference local="region_id" foreign="id" />
    </foreign-key>
    <foreign-key foreignTable="country" onDelete="CASCADE">
      <reference local="country_id" foreign="id" />
    </foreign-key>
    <unique name="unique_nice_title">
      <unique-column name="nice_title" />
    </unique>
  </table>