abbreviation_locations

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
abbreviation_id VARCHAR 255 null
abbreviations.abbreviation_id abbreviation_locations_abbreviation_id_foreign C
location_id VARCHAR 255 null
locations.location_id abbreviation_locations_location_id_foreign C
order INT 10 √ null
notes TEXT 65535 √ null
meta JSON 1073741824 √ null
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 id
abbreviation_locations_abbreviation_id_index Performance Asc abbreviation_id
abbreviation_locations_abbreviation_id_location_id_unique Must be unique Asc/Asc abbreviation_id + location_id
abbreviation_locations_location_id_index Performance Asc location_id

Relationships

Close relationships within degrees of separation