Column | Type | Size | Nulls | Auto | Children | Parents | Comments | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
location_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
|||||||||||||||||||
location_name | varchar(255) | 255 |
|
|
The name of the location. |
||||||||||||||||||||
location_type_id | int4 | 10 |
|
|
Specifies the type of location. |
||||||||||||||||||||
default_lat_dd | numeric(18,10) | 18,10 | √ |
|
|
Default latitude of the location in decimal degrees, e.g., the midpoint of a country. Leave empty if unknown. |
|||||||||||||||||||
default_long_dd | numeric(18,10) | 18,10 | √ |
|
|
Default longitude of the location in decimal degrees, e.g., the midpoint of a country. Leave empty if unknown. |
|||||||||||||||||||
date_updated | timestamptz | 35,6 | √ |
|
|