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