@startuml
skinparam monochrome true
skinparam ObjectFontStyle bold

map planet_osm_nodes #eee {
  id => BIGINT
  lat => INT
  lon => INT
}

map planet_osm_ways #eee {
  id => BIGINT
  nodes => BIGINT[]
  tags => TEXT[]
}

map planet_osm_rels #eee {
  id => BIGINT
  parts => BIGINT[]
  members => TEXT[]
  tags => TEXT[]
  way_off => SMALLINT
  rel_off => SMALLINT
}

map place {
  osm_type => CHAR(1)
  osm_id => BIGINT
  class => TEXT
  type => TEXT
  name => HSTORE
  address => HSTORE
  extratags => HSTORE
  admin_level => SMALLINT
  geometry => GEOMETRY
  categories => LTREE[]
}

map place_entrance {
  osm_id => BIGINT
  type => TEXT
  extratags => HSTORE
  geometry => GEOMETRY
}

map place_associated_street {
  relation_id => BIGINT
  member_type => TEXT
  member_id => BIGINT
  member_role => TEXT
}

map place_postcode {
  osm_type => CHAR(1)
  osm_id => BIGINT
  postcode => TEXT
  country_code => TEXT
  centroid => GEOMETRY
  geometry => GEOMETRY
}

map place_interpolation {
  osm_id => BIGINT
  type => TEXT
  address => HSTORE
  nodes => BIGINT[]
  geometry => GEOMETRY
}


planet_osm_nodes  -[hidden]> planet_osm_ways
planet_osm_ways  -[hidden]> planet_osm_rels
planet_osm_ways -[hidden]-> place
place -[hidden]-> place_postcode
place -[hidden]-> place_interpolation
place_postcode -[hidden]-> place_entrance
place_interpolation -[hidden]-> place_associated_street

planet_osm_nodes::id <- planet_osm_ways::nodes
planet_osm_nodes::id <- place_interpolation::nodes
planet_osm_nodes::id <- place_entrance::osm_id
planet_osm_rels::id <- place_associated_street::relation_id

@enduml