locations

143 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
location_id VARCHAR 255 null
abbreviation_locations.location_id abbreviation_locations_location_id_foreign C
construction_usages.location_id construction_usages_location_id_foreign C
entry_historical_docs.location_id entry_historical_docs_location_id_foreign N
entry_variant_locations.location_id entry_variant_locations_location_id_foreign C
inflected_form_variants.location_id inflected_form_variants_location_id_foreign R
location_translations.location_id location_translations_location_id_foreign C
responses.location_id responses_location_id_foreign R
sense_examples.location_id sense_examples_location_id_foreign N
sense_locations.location_id sense_locations_location_id_foreign R
latitude DOUBLE 22 √ null
longitude DOUBLE 22 √ null
dialect_zone VARCHAR 255 √ null
dialect_zones.dialect_zone_id locations_dialect_zone_foreign R
location_precision VARCHAR 255 √ null
location_source_id VARCHAR 255 √ null
sources.source_id locations_location_source_id_foreign N
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc location_id
locations_dialect_zone_foreign Performance Asc dialect_zone
locations_location_source_id_foreign Performance Asc location_source_id

Relationships

Close relationships within degrees of separation