construction_usages

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
construction_usage_id VARCHAR 255 null
construction_usage_translations.construction_usage_id construction_usage_translations_construction_usage_id_foreign C
construction_id VARCHAR 255 null
constructions.construction_id construction_usages_construction_id_foreign C
location_id VARCHAR 255 null
locations.location_id construction_usages_location_id_foreign C
example TEXT 65535 null
adapted_example TEXT 65535 √ null
source_id VARCHAR 255 null
sources.source_id construction_usages_source_id_foreign C
year INT 10 √ null
certainty_id VARCHAR 255 √ null
certainty_labels.certainty_labels_id construction_usages_certainty_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 construction_usage_id
construction_usages_certainty_id_foreign Performance Asc certainty_id
construction_usages_construction_id_foreign Performance Asc construction_id
construction_usages_location_id_foreign Performance Asc location_id
construction_usages_source_id_foreign Performance Asc source_id

Relationships

Close relationships within degrees of separation