erDiagram
  shop_shop }o--o| places_location : "reference_location_id"
  places_location }|--|| places_area : "area_id"
  places_location }|--|| places_country : "_country_id"
  places_area }|--|| places_country : "country_id"
  places_location }o--o{ places_region : "places_location__regions"
  places_area }o--o{ places_region : "places_area__regions"
  places_country }o--o{ places_region : "places_country__regions"
  places_location }o--o{ places_continent : "places_location__continents"
  places_area }o--o{ places_continent : "places_area__continents"
  places_country }o--o{ places_continent : "places_country__continents"
  places_country ||--o| places_countrycurrency : "default currency (API)"
  shop_shop {
    int id PK
    int reference_location_id FK
  }
  places_location {
    int id PK "scope key"
    text title "10 languages, card"
    text slug "10 languages, URL"
    int area_id FK
    int country_id FK "column is _country_id"
    float8 latitude "centroid"
    float8 longitude "centroid"
    bool is_autosuggest "lookup"
    bool is_active
    bool is_on_map
  }
  places_area {
    int id PK "scope key"
    text title "10 languages"
    text slug "Adventures URLs"
    int country_id FK
    float8 latitude
    float8 longitude
    bool is_autosuggest
  }
  places_country {
    int id PK "scope key"
    text title "10 languages, card"
    text title_lc "native name"
    varchar2 code "ISO, display rules"
    text slug
    bool is_autosuggest
  }
  places_region {
    int id PK "region_ids"
    text title "10 languages"
    text slug
    bool is_autosuggest
  }
  places_continent {
    int id PK "continent_ids"
    text title "10 languages"
    bool is_autosuggest
  }
  places_countrycurrency {
    int country_id FK
    varchar3 currency
  }