sources

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
source_id VARCHAR 255 null
construction_usages.source_id construction_usages_source_id_foreign C
elicitation_prompts.origin_source_id elicitation_prompts_origin_source_id_foreign R
entry_crossrefs.source_id entry_crossrefs_source_id_foreign C
entry_display_forms.source_id entry_display_forms_source_id_foreign R
entry_etymologies.source_id entry_etymologies_source_id_foreign R
entry_historical_docs.source_id entry_historical_docs_source_id_foreign C
entry_senses.source_id entry_senses_source_id_foreign R
entry_sources.source_id entry_sources_source_id_foreign R
entry_variants.source_id entry_variants_source_id_foreign C
inflected_form_variants.source_id inflected_form_variants_source_id_foreign R
locations.location_source_id locations_location_source_id_foreign N
normative_entry_forms.origin_source_id normative_entry_forms_origin_source_id_foreign R
original_entry_sources.source_id original_entry_sources_source_id_foreign R
responses.origin_source_id responses_origin_source_id_foreign R
sense_examples.source_id sense_examples_source_id_foreign N
source_translations.source_id source_translations_source_id_foreign C
sources.parent_source_id sources_parent_source_id_foreign N
year INT 10 √ null
parent_source_id VARCHAR 255 √ null
sources.source_id sources_parent_source_id_foreign N
is_primary BIT 1 √ null
link VARCHAR 255 √ null
license 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 source_id
sources_parent_source_id_foreign Performance Asc parent_source_id

Relationships

Close relationships within degrees of separation