entry_senses

151309 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
entry_sense_id VARCHAR 255 null
entry_crossrefs.target_sense_id entry_crossrefs_target_sense_id_foreign C
entry_sense_translations.entry_sense_id entry_sense_translations_entry_sense_id_foreign C
sense_examples.sense_id sense_examples_sense_id_foreign C
sense_genders.entry_sense_id sense_genders_entry_sense_id_foreign R
sense_locations.entry_sense_id sense_locations_entry_sense_id_foreign R
sense_markers.entry_sense_id sense_markers_entry_sense_id_foreign C
sense_pos.entry_sense_id sense_pos_entry_sense_id_foreign C
sense_scientific_name.entry_sense_id sense_scientific_name_entry_sense_id_foreign C
entry_id VARCHAR 255 null
entries.entry_id entry_senses_entry_id_foreign R
sense_number INT 10 null
sense_text TEXT 65535 null
source_id VARCHAR 255 null
sources.source_id entry_senses_source_id_foreign R
source_entry_id VARCHAR 255 √ null
edition VARCHAR 255 √ null
language VARCHAR 255 √ null
granularity VARCHAR 255 √ null
comment VARCHAR 255 √ null
original_display 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 entry_sense_id
entry_senses_entry_id_foreign Performance Asc entry_id
entry_senses_source_id_foreign Performance Asc source_id

Relationships

Close relationships within degrees of separation