tbl_locations

3404 rows


Description

Represents geographical locations, typically defined by regions. These can be current or historical locations.

Columns

Column Type Size Nulls Auto Children Parents Comments
location_id int4 10 √
tbl_contacts.location_id Implied Constraint R
tbl_rdb.location_id fk_tbl_rdb_tbl_location_id R
tbl_rdb_systems.location_id fk_rdb_systems_location_id R
tbl_relative_ages.location_id fk_relative_ages_location_id R
tbl_site_locations.location_id fk_locations_location_id R
tbl_taxa_seasonality.location_id fk_taxa_seasonality_location_id R

Primary key (automatically incremented).
location_name varchar(255) 255

The name of the location.
location_type_id int4 10
tbl_location_types.location_type_id fk_locations_location_type_id R

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 √

Indexes

Constraint Name Type Sort Column(s)
tbl_locations_pkey Primary key Asc location_id
idx_locations_location_type_id Performance Asc location_type_id

Relationships

Close relationships within degrees of separation