docs/develop/search-tables.plantuml

   1 @startuml
   2 skinparam monochrome true
   3 skinparam ObjectFontStyle bold
   4
   5 left to right direction
   6
   7 map placex {
   8   place_id => BIGINT
   9   osm_type => CHAR(1)
  10   osm_id => BIGINT
  11   class => TEXT
  12   type => TEXT
  13   name => HSTORE
  14   address => HSTORE
  15   extratags => HSTORE
  16   admin_level => SMALLINT
  17   partition => SMALLINT
  18   geometry_sector => INT
  19   parent_place_id => BIGINT
  20   linked_place_id => BIGINT
  21   importance => DOUBLE
  22   rank_search => SMALLINT
  23   rank_address => SMALLINT
  24   wikipedia => TEXT
  25   country_code => VARCHAR(2)
  26   housenumber => TEXT
  27   postcode => TEXT
  28   indexed_status => SMALLINT
  29   indexed_date => TIMESTAMP
  30   centroid => GEOMETRY
  31   geometry => GEOMETRY
  32   token_info JSONB
  33 }
  34
  35 map search_name {
  36   place_id => BIGINT
  37   importance => DOUBLE
  38   search_rank => SMALLINT
  39   address_rank => SMALLINT
  40   name_vector => INT[]
  41   nameaddress_vector => INT[]
  42   country_code => VARCHAR(2)
  43   centroid => GEOMETRY
  44 }
  45
  46 map word {
  47   word_id => INT
  48   word_token => TEXT
  49   ... =>
  50 }
  51
  52 map location_property_osmline {
  53   place_id => BIGINT
  54   osm_id => BIGINT
  55   type => TEXT
  56   startnumber => INT
  57   endnumber => INT
  58   step => int
  59   address => HSTORE
  60   geometry_sector => INT
  61   parent_place_id => BIGINT
  62   country_code => VARCHAR(2)
  63   postcode => text
  64   indexed_status => SMALLINT
  65   indexed_date => TIMESTAMP
  66   linegeo => GEOMETRY
  67   token_info JSONB
  68 }
  69
  70 map place_addressline {
  71   place_id => BIGINT
  72   address_place_id => BIGINT
  73   distance => DOUBLE
  74   cached_rank_address => SMALLINT
  75   fromarea => BOOLEAN
  76   isaddress => BOOLEAN
  77 }
  78
  79 map location_postcodes {
  80   place_id => BIGINT
  81   osm_id => BIGINT
  82   postcode => TEXT
  83   country_code => TEXT
  84   parent_place_id => BIGINT
  85   rank_search => SMALLINT
  86   indexed_status => SMALLINT
  87   indexed_date => TIMESTAMP
  88   geometry => GEOMETRY
  89   centroid -> GEOMETRY
  90 }
  91
  92 placex::place_id <-- search_name::place_id
  93 placex::place_id <-- place_addressline::place_id
  94 placex::place_id <-- place_addressline::address_place_id
  95
  96 search_name::name_vector --> word::word_id
  97 search_name::nameaddress_vector --> word::word_id
  98
  99 place_addressline -[hidden]> location_property_osmline
 100 search_name -[hidden]> place_addressline
 101 location_property_osmline -[hidden]-> location_postcodes
 102
 103 @enduml