abbreviation_aliases

4 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_aliases_abbreviation_id_foreign C
alias_code VARCHAR 255 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_aliases_abbreviation_id_alias_code_unique Must be unique Asc/Asc abbreviation_id + alias_code
abbreviation_aliases_alias_code_index Performance Asc alias_code

Relationships

Close relationships within degrees of separation