]> git.openstreetmap.org Git - nominatim.git/blob - docs/develop/search-tables.plantuml
prepare release 5.3.2-post1
[nominatim.git] / 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