|
id
|
int(10) unsigned
|
|
|
|
|
entities_id
|
int(10) unsigned
|
|
|
0
|
|
is_recursive
|
tinyint(4)
|
|
|
0
|
|
name
|
varchar(255)
|
|
|
|
|
locations_id
|
int(10) unsigned
|
|
|
0
|
|
completename
|
text
|
|
|
|
|
comment
|
text
|
|
|
|
|
level
|
int(11)
|
|
|
0
|
|
ancestors_cache
|
longtext
|
|
|
|
|
sons_cache
|
longtext
|
|
|
|
|
address
|
text
|
|
|
|
|
postcode
|
varchar(255)
|
|
|
|
|
town
|
varchar(255)
|
|
|
|
|
state
|
varchar(255)
|
|
|
|
|
country
|
varchar(255)
|
|
|
|
|
building
|
varchar(255)
|
|
|
|
|
room
|
varchar(255)
|
|
|
|
|
latitude
|
varchar(255)
|
|
|
|
|
longitude
|
varchar(255)
|
|
|
|
|
altitude
|
varchar(255)
|
|
|
|
|
date_mod
|
timestamp
|
|
|
|
|
date_creation
|
timestamp
|
|
|
|