tbl_location_types

14 rows


Description

Contains definitions for various geographical terms, specifying their resolution and context (e.g., administrative unit, historical administrative unit, lake, country).

Columns

Column Type Size Nulls Auto Children Parents Comments
location_type_id int4 10 √
tbl_locations.location_type_id fk_locations_location_type_id R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
description text 2147483647 √

A detailed explanation or definition of the location type.
location_type varchar(40) 40 √

The name or designation of the location type (e.g., country, city, lake).

Indexes

Constraint Name Type Sort Column(s)
tbl_location_types_pkey Primary key Asc location_type_id
tbl_location_types_location_type_key Must be unique Asc location_type
tbl_location_types_location_type_unique Must be unique Asc location_type

Relationships

Close relationships within degrees of separation