entry_etymologies

45656 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
entry_etymology_id VARCHAR 255 null
entry_etymology_translations.entry_etymology_id entry_etymology_translations_entry_etymology_id_foreign C
entry_id VARCHAR 255 null
entries.entry_id entry_etymologies_entry_id_foreign R
explanation TEXT 65535 null
source_id VARCHAR 255 null
sources.source_id entry_etymologies_source_id_foreign R
source_entry_id VARCHAR 255 √ null
entries.entry_id entry_etymologies_source_entry_id_foreign R
etymon VARCHAR 255 √ null
origin_language VARCHAR 255 null
languages.language_id entry_etymologies_origin_language_foreign R
origin_source_id VARCHAR 255 √ null
origin_reference VARCHAR 255 √ null
etym_class VARCHAR 255 √ null
is_uncertain BIT 1 √ 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 entry_etymology_id
entry_etymologies_entry_id_foreign Performance Asc entry_id
entry_etymologies_origin_language_foreign Performance Asc origin_language
entry_etymologies_source_entry_id_foreign Performance Asc source_entry_id
entry_etymologies_source_id_foreign Performance Asc source_id

Relationships

Close relationships within degrees of separation