entries

49376 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
entry_id VARCHAR 255 null
entry_crossrefs.source_entry_id entry_crossrefs_source_entry_id_foreign C
entry_crossrefs.target_entry_id entry_crossrefs_target_entry_id_foreign C
entry_display_forms.entry_id entry_display_forms_entry_id_foreign R
entry_etymologies.entry_id entry_etymologies_entry_id_foreign R
entry_etymologies.source_entry_id entry_etymologies_source_entry_id_foreign R
entry_historical_docs.entry_id entry_historical_docs_entry_id_foreign C
entry_lexical_fields.entry_id entry_lexical_fields_entry_id_foreign R
entry_parent.child_entry_id entry_parent_child_entry_id_foreign C
entry_parent.parent_entry_id entry_parent_parent_entry_id_foreign C
entry_phenomenoms.entry_id entry_phenomenoms_entry_id_foreign C
entry_senses.entry_id entry_senses_entry_id_foreign R
entry_sources.entry_id entry_sources_entry_id_foreign R
entry_translations.entry_id entry_translations_entry_id_foreign C
entry_variants.entry_id entry_variants_entry_id_foreign C
inflected_forms.entry_id inflected_forms_entry_id_foreign N
normative_entry_forms.entry_id normative_entry_forms_entry_id_foreign R
original_entry_sources.entry_id original_entry_sources_entry_id_foreign R
responses.elicited_entry_id responses_elicited_entry_id_foreign R
lemma_form VARCHAR 255 null
lemma_form_display VARCHAR 255 null
is_reconstructed BIT 1 √ null
is_from_written_tradition BIT 1 √ null
is_always_pronominal BIT 1 √ null
entry_type_id VARCHAR 255 null
entry_types.entry_type_id entries_entry_type_id_foreign R
status_id VARCHAR 255 null
status.status_id entries_status_id_foreign R
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_id
entries_entry_type_id_foreign Performance Asc entry_type_id
entries_lemma_form_display_unique Must be unique Asc lemma_form_display
entries_status_id_foreign Performance Asc status_id

Relationships

Close relationships within degrees of separation