Tables


SchemaSpy Analysis of cordia.cordia

Generated on Tue Dec 02 09:20 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 114
VIEWS 0
COLUMNS 839
Constraints 143
Anomalies 1
Routines 0

Database Properties

Database Type: MySQL - 8.0.43

Tables

Table / View Children Parents Columns Rows Type Comments
elicit_types 0 0 7 4 Table
normative_entry_forms 2 3 10 27 Table
elicits 2 0 6 5 Table
sense_markers 0 2 8 0 Table
taxon_genus 1 0 7 6 Table
sense_examples 1 5 12 0 Table
entry_sense_translations 0 1 7 163010 Table
construction_usage_translations 0 1 7 0 Table
entry_sources 0 2 5 27 Table
sense_marker_labels 2 0 5 4 Table
phenomenon_masters 5 1 5 15 Table
normative_form_changes 0 1 11 0 Table
failed_jobs 0 0 7 0 Table
constructions 2 0 5 4 Table
entry_type_translations 0 1 8 20 Table
migrations 0 0 3 66 Table
construction_translations 0 1 8 12 Table
phenomenon_levels 2 0 4 6 Table
morph_trait_label_translations 0 2 8 0 Table
cordia_logs 0 1 10 0 Table
certainty_labels 8 0 4 3 Table
entry_etymology_translations 0 1 7 2 Table
personal_access_tokens 0 0 11 0 Table
pos_label_translations 0 1 8 48 Table
roles 2 0 5 3 Table
users 1 1 10 4 Table
abbreviations 3 0 9 113 Table
speakers 5 1 6 0 Table
password_reset_tokens 1 0 3 0 Table
tags 2 0 5 5 Table
response_types 3 0 4 3 Table
tag_translations 0 1 8 20 Table
entry_variant_translations 0 1 8 0 Table
gender_translations 0 1 8 20 Table
cache_locks 0 0 3 0 Table
job_batches 0 0 10 0 Table
character_inventories 1 0 7 4 Table
location_translations 0 1 8 572 Table
entry_etymologies 1 4 14 45656 Table
morph_trait_labels 2 1 5 0 Table
languages 3 0 4 92 Table
prompt_types 1 0 10 3 Table
entry_crossref_translations 0 1 8 0 Table
responses 2 6 15 0 Table
jobs 0 0 7 0 Table
entry_crossrefs 1 4 8 0 Table
entry_lexical_fields 1 2 6 0 Table
variant_marker_labels 2 0 5 5 Table
sense_marker_label_translations 0 1 8 16 Table
status_translations 0 1 8 16 Table
entry_historical_docs 1 3 12 56416 Table
locations 9 2 9 143 Table
permissions 2 0 5 318 Table
model_has_permissions 0 1 3 0 Table
scientific_names 2 3 9 8 Table
speaker_translations 0 1 9 4 Table
phenomenon_dialect_zones 1 2 6 3 Table
abbreviation_locations 0 2 9 0 Table
entry_variants 3 7 16 36073 Table
phenomenon_dialect_zone_translations 0 1 7 12 Table
pos_labels 4 0 4 12 Table
certainty_label_translations 0 1 8 9 Table
status 4 0 6 4 Table
sense_example_translations 0 1 7 0 Table
abbreviations_translations 0 1 8 452 Table
original_entry_sources 0 2 6 50550 Table
normative_entry_form_translations 0 1 7 0 Table
entry_display_forms 1 2 8 0 Table
abbreviation_aliases 0 1 6 4 Table
entries 18 2 11 49376 Table
inflected_forms 2 3 10 0 Table
sense_pos 0 2 8 50 Table
phenomenons 0 4 10 0 Table
character_inventory_translations 0 1 8 16 Table
entry_types 2 0 5 5 Table
entry_variant_locations 0 2 6 0 Table
entry_lexical_field_translations 0 1 7 0 Table
entry_translations 0 1 7 0 Table
cache 0 0 3 0 Table
role_has_permissions 0 2 2 742 Table
tag_assignment_translations 0 1 6 0 Table
entry_historical_doc_translations 0 1 7 0 Table
prompt_elicits 0 2 6 0 Table
genders 3 0 4 5 Table
construction_usages 1 4 11 0 Table
elicit_translations 0 1 8 15 Table
response_phenomenoms 0 2 7 0 Table
lexical_field_translations 0 1 8 120 Table
entry_parent 0 2 8 2 Table
phenomenon_level_translations 0 1 8 24 Table
phenomenon_master_translations 0 1 8 60 Table
taxon_rank 1 0 6 13 Table
tag_assignments 1 1 7 0 Table
sense_scientific_name 0 2 7 0 Table
inflected_form_variant_translations 0 1 8 0 Table
language_translations 0 1 7 368 Table
response_type_translations 0 1 8 12 Table
entry_phenomenom_translations 0 1 7 0 Table
source_translations 0 1 11 40 Table
sources 17 1 9 10 Table
dialect_zones 3 0 4 3 Table
dialect_zone_translations 0 1 8 9 Table
sense_locations 0 3 7 0 Table
sense_genders 0 2 5 16 Table
entry_phenomenoms 1 2 6 0 Table
inflected_form_translations 0 1 7 0 Table
entry_senses 8 2 14 151309 Table
entry_display_form_translations 0 1 7 0 Table
sessions 0 0 6 0 Table
model_has_roles 0 1 3 4 Table
variant_marker_label_translations 0 1 8 20 Table
inflected_form_variants 1 5 12 0 Table
lexical_fields 2 0 4 30 Table
elicitation_prompts 2 3 10 3 Table