]> git.openstreetmap.org Git - nominatim.git/blob - docs/develop/address-tables.plantuml
work around strange query planning behaviour
[nominatim.git] / docs / develop / address-tables.plantuml
1 @startuml
2 skinparam monochrome true
3 skinparam ObjectFontStyle bold
4
5 map search_name_X {
6   place_id => BIGINT
7   address_rank => SMALLINT
8   name_vector => INT[]
9   centroid => GEOMETRY
10 }
11
12 map location_area_large_X {
13   place_id => BIGINT
14   keywords => INT[]
15   partition => SMALLINT
16   rank_search => SMALLINT
17   rank_address => SMALLINT
18   country_code => VARCHR(2)
19   isguess => BOOLEAN
20   postcode => TEXT
21   centroid => POINT
22   geometry => GEOMETRY
23 }
24
25 map location_road_X {
26   place_id => BIGINT
27   partition => SMALLINT
28   country_code => VARCHR(2)
29   geometry => GEOMETRY
30 }
31
32 search_name_X -[hidden]> location_area_large_X
33 location_area_large_X -[hidden]> location_road_X
34
35 @enduml