cordia.cordia

143 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

normative_entry_forms_status_id_foreign

normative_entry_forms.status_id

status.status_id

Restrict delete

normative_entry_forms_entry_id_foreign

normative_entry_forms.entry_id

entries.entry_id

Restrict delete

normative_entry_forms_origin_source_id_foreign

normative_entry_forms.origin_source_id

sources.source_id

Restrict delete

sense_markers_entry_sense_id_foreign

sense_markers.entry_sense_id

entry_senses.entry_sense_id

Cascade on delete

sense_markers_sense_marker_label_id_foreign

sense_markers.sense_marker_label_id

sense_marker_labels.sense_marker_label_id

Restrict delete

sense_examples_source_id_foreign

sense_examples.source_id

sources.source_id

Null on delete

sense_examples_certainty_id_foreign

sense_examples.certainty_id

certainty_labels.certainty_labels_id

Null on delete

sense_examples_speaker_id_foreign

sense_examples.speaker_id

speakers.speaker_id

Null on delete

sense_examples_location_id_foreign

sense_examples.location_id

locations.location_id

Null on delete

sense_examples_sense_id_foreign

sense_examples.sense_id

entry_senses.entry_sense_id

Cascade on delete

entry_sense_translations_entry_sense_id_foreign

entry_sense_translations.entry_sense_id

entry_senses.entry_sense_id

Cascade on delete

construction_usage_translations_construction_usage_id_foreign

construction_usage_translations.construction_usage_id

construction_usages.construction_usage_id

Cascade on delete

entry_sources_entry_id_foreign

entry_sources.entry_id

entries.entry_id

Restrict delete

entry_sources_source_id_foreign

entry_sources.source_id

sources.source_id

Restrict delete

phenomenon_masters_phenomenon_level_id_foreign

phenomenon_masters.phenomenon_level_id

phenomenon_levels.phenomenon_level_id

Restrict delete

normative_form_changes_normative_entry_form_id_foreign

normative_form_changes.normative_entry_form_id

normative_entry_forms.normative_entry_form_id

Cascade on delete

entry_type_translations_entry_type_id_foreign

entry_type_translations.entry_type_id

entry_types.entry_type_id

Cascade on delete

construction_translations_construction_id_foreign

construction_translations.construction_id

constructions.construction_id

Cascade on delete

morph_trait_label_translations_pos_id_morph_trait_foreign

morph_trait_label_translations.pos_id

morph_trait_label_translations.morph_trait

morph_trait_labels.pos_id

morph_trait_labels.morph_trait

Cascade on delete

cordia_logs_user_id_foreign

cordia_logs.user_id

users.id

Null on delete

entry_etymology_translations_entry_etymology_id_foreign

entry_etymology_translations.entry_etymology_id

entry_etymologies.entry_etymology_id

Cascade on delete

pos_label_translations_pos_labels_id_foreign

pos_label_translations.pos_labels_id

pos_labels.pos_labels_id

Cascade on delete

speakers_gender_id_foreign

speakers.gender_id

genders.gender_id

Restrict delete

tag_translations_tag_id_foreign

tag_translations.tag_id

tags.tag_id

Cascade on delete

entry_variant_translations_entry_variant_id_foreign

entry_variant_translations.entry_variant_id

entry_variants.entry_variant_id

Cascade on delete

gender_translations_gender_id_foreign

gender_translations.gender_id

genders.gender_id

Cascade on delete

location_translations_location_id_foreign

location_translations.location_id

locations.location_id

Cascade on delete

entry_etymologies_origin_language_foreign

entry_etymologies.origin_language

languages.language_id

Restrict delete

entry_etymologies_source_id_foreign

entry_etymologies.source_id

sources.source_id

Restrict delete

entry_etymologies_entry_id_foreign

entry_etymologies.entry_id

entries.entry_id

Restrict delete

entry_etymologies_source_entry_id_foreign

entry_etymologies.source_entry_id

entries.entry_id

Restrict delete

morph_trait_labels_pos_id_foreign

morph_trait_labels.pos_id

pos_labels.pos_labels_id

Restrict delete

entry_crossref_translations_entry_crossref_id_foreign

entry_crossref_translations.entry_crossref_id

entry_crossrefs.entry_crossref_id

Cascade on delete

responses_prompt_id_foreign

responses.prompt_id

elicitation_prompts.elicitation_prompt_id

Restrict delete

responses_speaker_id_foreign

responses.speaker_id

speakers.speaker_id

Restrict delete

responses_origin_source_id_foreign

responses.origin_source_id

sources.source_id

Restrict delete

responses_elicited_entry_id_foreign

responses.elicited_entry_id

entries.entry_id

Restrict delete

responses_certainty_id_foreign

responses.certainty_id

certainty_labels.certainty_labels_id

Null on delete

responses_location_id_foreign

responses.location_id

locations.location_id

Restrict delete

entry_crossrefs_target_entry_id_foreign

entry_crossrefs.target_entry_id

entries.entry_id

Cascade on delete

entry_crossrefs_target_sense_id_foreign

entry_crossrefs.target_sense_id

entry_senses.entry_sense_id

Cascade on delete

entry_crossrefs_source_id_foreign

entry_crossrefs.source_id

sources.source_id

Cascade on delete

entry_crossrefs_source_entry_id_foreign

entry_crossrefs.source_entry_id

entries.entry_id

Cascade on delete

entry_lexical_fields_entry_id_foreign

entry_lexical_fields.entry_id

entries.entry_id

Restrict delete

entry_lexical_fields_lexical_field_id_foreign

entry_lexical_fields.lexical_field_id

lexical_fields.lexical_field_id

Restrict delete

sense_marker_label_translations_sense_marker_label_id_foreign

sense_marker_label_translations.sense_marker_label_id

sense_marker_labels.sense_marker_label_id

Cascade on delete

status_translations_status_id_foreign

status_translations.status_id

status.status_id

Cascade on delete

entry_historical_docs_location_id_foreign

entry_historical_docs.location_id

locations.location_id

Null on delete

entry_historical_docs_source_id_foreign

entry_historical_docs.source_id

sources.source_id

Cascade on delete

entry_historical_docs_entry_id_foreign

entry_historical_docs.entry_id

entries.entry_id

Cascade on delete

locations_dialect_zone_foreign

locations.dialect_zone

dialect_zones.dialect_zone_id

Restrict delete

locations_location_source_id_foreign

locations.location_source_id

sources.source_id

Null on delete

model_has_permissions_permission_id_foreign

model_has_permissions.permission_id

permissions.id

Cascade on delete

scientific_names_accepted_scientific_name_id_foreign

scientific_names.accepted_scientific_name_id

scientific_names.scientific_name_id

Restrict delete

scientific_names_taxon_rank_id_foreign

scientific_names.taxon_rank_id

taxon_rank.taxon_rank_id

Restrict delete

scientific_names_taxon_genus_id_foreign

scientific_names.taxon_genus_id

taxon_genus.taxon_genus_id

Restrict delete

speaker_translations_speaker_id_foreign

speaker_translations.speaker_id

speakers.speaker_id

Cascade on delete

phenomenon_dialect_zones_dialect_zone_foreign

phenomenon_dialect_zones.dialect_zone

dialect_zones.dialect_zone_id

Restrict delete

phenomenon_dialect_zones_phenomenon_id_foreign

phenomenon_dialect_zones.phenomenon_id

phenomenon_masters.phenomenon_master_id

Restrict delete

abbreviation_locations_abbreviation_id_foreign

abbreviation_locations.abbreviation_id

abbreviations.abbreviation_id

Cascade on delete

abbreviation_locations_location_id_foreign

abbreviation_locations.location_id

locations.location_id

Cascade on delete

entry_variants_entry_id_foreign

entry_variants.entry_id

entries.entry_id

Cascade on delete

entry_variants_variant_marker_id_foreign

entry_variants.variant_marker_id

variant_marker_labels.variant_marker_label_id

Restrict delete

entry_variants_response_type_foreign

entry_variants.response_type

response_types.response_type_id

Restrict delete

entry_variants_certainty_id_foreign

entry_variants.certainty_id

certainty_labels.certainty_labels_id

Null on delete

entry_variants_speaker_id_foreign

entry_variants.speaker_id

speakers.speaker_id

Cascade on delete

fk_entry_variants_response_type

entry_variants.response_type

response_types.response_type_id

Restrict delete

entry_variants_source_id_foreign

entry_variants.source_id

sources.source_id

Cascade on delete

fk_pdzt_zone

phenomenon_dialect_zone_translations.phenomenon_dialect_zone_id

phenomenon_dialect_zones.phenomenon_dialect_zone_id

Cascade on delete

certainty_label_translations_certainty_labels_id_foreign

certainty_label_translations.certainty_labels_id

certainty_labels.certainty_labels_id

Cascade on delete

sense_example_translations_sense_example_id_foreign

sense_example_translations.sense_example_id

sense_examples.sense_example_id

Cascade on delete

abbreviations_translations_abbreviation_id_foreign

abbreviations_translations.abbreviation_id

abbreviations.abbreviation_id

Cascade on delete

original_entry_sources_entry_id_foreign

original_entry_sources.entry_id

entries.entry_id

Restrict delete

original_entry_sources_source_id_foreign

original_entry_sources.source_id

sources.source_id

Restrict delete

fk_normative_entry

normative_entry_form_translations.normative_entry_form_id

normative_entry_forms.normative_entry_form_id

Cascade on delete

entry_display_forms_source_id_foreign

entry_display_forms.source_id

sources.source_id

Restrict delete

entry_display_forms_entry_id_foreign

entry_display_forms.entry_id

entries.entry_id

Restrict delete

abbreviation_aliases_abbreviation_id_foreign

abbreviation_aliases.abbreviation_id

abbreviations.abbreviation_id

Cascade on delete

entries_entry_type_id_foreign

entries.entry_type_id

entry_types.entry_type_id

Restrict delete

entries_status_id_foreign

entries.status_id

status.status_id

Restrict delete

inflected_forms_entry_id_foreign

inflected_forms.entry_id

entries.entry_id

Null on delete

inflected_forms_pos_id_foreign

inflected_forms.pos_id

pos_labels.pos_labels_id

Null on delete

inflected_forms_status_id_foreign

inflected_forms.status_id

status.status_id

Null on delete

sense_pos_pos_id_foreign

sense_pos.pos_id

pos_labels.pos_labels_id

Cascade on delete

sense_pos_entry_sense_id_foreign

sense_pos.entry_sense_id

entry_senses.entry_sense_id

Cascade on delete

phenomenons_certainty_id_foreign

phenomenons.certainty_id

certainty_labels.certainty_labels_id

Null on delete

phenomenons_response_id_foreign

phenomenons.response_id

responses.response_id

Null on delete

phenomenons_entry_variant_id_foreign

phenomenons.entry_variant_id

entry_variants.entry_variant_id

Null on delete

phenomenons_phenomenon_id_foreign

phenomenons.phenomenon_id

phenomenon_masters.phenomenon_master_id

Cascade on delete

character_inventory_translations_character_inventory_id_foreign

character_inventory_translations.character_inventory_id

character_inventories.character_inventory_id

Cascade on delete

entry_variant_locations_entry_variant_id_foreign

entry_variant_locations.entry_variant_id

entry_variants.entry_variant_id

Cascade on delete

entry_variant_locations_location_id_foreign

entry_variant_locations.location_id

locations.location_id

Cascade on delete

entry_lexical_field_translations_entry_lexical_fields_id_foreign

entry_lexical_field_translations.entry_lexical_fields_id

entry_lexical_fields.entry_lexical_fields_id

Cascade on delete

entry_translations_entry_id_foreign

entry_translations.entry_id

entries.entry_id

Cascade on delete

role_has_permissions_role_id_foreign

role_has_permissions.role_id

roles.id

Cascade on delete

role_has_permissions_permission_id_foreign

role_has_permissions.permission_id

permissions.id

Cascade on delete

tag_assignment_translations_tag_assignment_id_foreign

tag_assignment_translations.tag_assignment_id

tag_assignments.tag_assignment_id

Cascade on delete

fk_entry_historical

entry_historical_doc_translations.entry_historical_doc_id

entry_historical_docs.entry_historical_doc_id

Cascade on delete

prompt_elicits_prompt_id_foreign

prompt_elicits.prompt_id

elicitation_prompts.elicitation_prompt_id

Cascade on delete

prompt_elicits_elicit_id_foreign

prompt_elicits.elicit_id

elicits.elicit_id

Cascade on delete

construction_usages_location_id_foreign

construction_usages.location_id

locations.location_id

Cascade on delete

construction_usages_certainty_id_foreign

construction_usages.certainty_id

certainty_labels.certainty_labels_id

Null on delete

construction_usages_source_id_foreign

construction_usages.source_id

sources.source_id

Cascade on delete

construction_usages_construction_id_foreign

construction_usages.construction_id

constructions.construction_id

Cascade on delete

elicit_translations_elicit_id_foreign

elicit_translations.elicit_id

elicits.elicit_id

Cascade on delete

response_phenomenoms_response_phenomenon_id_foreign

response_phenomenoms.response_phenomenon_id

responses.response_id

Cascade on delete

response_phenomenoms_phenomenon_id_foreign

response_phenomenoms.phenomenon_id

phenomenon_masters.phenomenon_master_id

Cascade on delete

lexical_field_translations_lexical_field_id_foreign

lexical_field_translations.lexical_field_id

lexical_fields.lexical_field_id

Cascade on delete

entry_parent_child_entry_id_foreign

entry_parent.child_entry_id

entries.entry_id

Cascade on delete

entry_parent_parent_entry_id_foreign

entry_parent.parent_entry_id

entries.entry_id

Cascade on delete

phenomenon_level_translations_phenomenon_level_id_foreign

phenomenon_level_translations.phenomenon_level_id

phenomenon_levels.phenomenon_level_id

Cascade on delete

phenomenon_master_translations_phenomenon_master_id_foreign

phenomenon_master_translations.phenomenon_master_id

phenomenon_masters.phenomenon_master_id

Cascade on delete

tag_assignments_tag_id_foreign

tag_assignments.tag_id

tags.tag_id

Restrict delete

sense_scientific_name_entry_sense_id_foreign

sense_scientific_name.entry_sense_id

entry_senses.entry_sense_id

Cascade on delete

sense_scientific_name_scientific_name_id_foreign

sense_scientific_name.scientific_name_id

scientific_names.scientific_name_id

Cascade on delete

fk_inflected_form_variant

inflected_form_variant_translations.inflected_form_variant_id

inflected_form_variants.inflected_form_variant_id

Cascade on delete

language_translations_language_id_foreign

language_translations.language_id

languages.language_id

Cascade on delete

response_type_translations_response_type_id_foreign

response_type_translations.response_type_id

response_types.response_type_id

Cascade on delete

entry_phenomenom_translations_link_id_foreign

entry_phenomenom_translations.link_id

entry_phenomenoms.link_id

Cascade on delete

source_translations_source_id_foreign

source_translations.source_id

sources.source_id

Cascade on delete

sources_parent_source_id_foreign

sources.parent_source_id

sources.source_id

Null on delete

dialect_zone_translations_dialect_zone_id_foreign

dialect_zone_translations.dialect_zone_id

dialect_zones.dialect_zone_id

Cascade on delete

sense_locations_certainty_id_foreign

sense_locations.certainty_id

certainty_labels.certainty_labels_id

Null on delete

sense_locations_location_id_foreign

sense_locations.location_id

locations.location_id

Restrict delete

sense_locations_entry_sense_id_foreign

sense_locations.entry_sense_id

entry_senses.entry_sense_id

Restrict delete

sense_genders_gender_id_foreign

sense_genders.gender_id

genders.gender_id

Restrict delete

sense_genders_entry_sense_id_foreign

sense_genders.entry_sense_id

entry_senses.entry_sense_id

Restrict delete

entry_phenomenoms_phenomenon_id_foreign

entry_phenomenoms.phenomenon_id

phenomenon_masters.phenomenon_master_id

Cascade on delete

entry_phenomenoms_entry_id_foreign

entry_phenomenoms.entry_id

entries.entry_id

Cascade on delete

inflected_form_translations_inflected_form_id_foreign

inflected_form_translations.inflected_form_id

inflected_forms.inflected_form_id

Cascade on delete

entry_senses_entry_id_foreign

entry_senses.entry_id

entries.entry_id

Restrict delete

entry_senses_source_id_foreign

entry_senses.source_id

sources.source_id

Restrict delete

entry_display_form_translations_entry_display_form_id_foreign

entry_display_form_translations.entry_display_form_id

entry_display_forms.entry_display_form_id

Cascade on delete

model_has_roles_role_id_foreign

model_has_roles.role_id

roles.id

Cascade on delete

variant_label_fk

variant_marker_label_translations.variant_marker_label_id

variant_marker_labels.variant_marker_label_id

Cascade on delete

inflected_form_variants_certainty_id_foreign

inflected_form_variants.certainty_id

certainty_labels.certainty_labels_id

Null on delete

inflected_form_variants_inflected_form_id_foreign

inflected_form_variants.inflected_form_id

inflected_forms.inflected_form_id

Cascade on delete

inflected_form_variants_speaker_id_foreign

inflected_form_variants.speaker_id

speakers.speaker_id

Null on delete

inflected_form_variants_source_id_foreign

inflected_form_variants.source_id

sources.source_id

Restrict delete

inflected_form_variants_location_id_foreign

inflected_form_variants.location_id

locations.location_id

Restrict delete

elicitation_prompts_origin_source_id_foreign

elicitation_prompts.origin_source_id

sources.source_id

Restrict delete

elicitation_prompts_language_id_foreign

elicitation_prompts.language_id

languages.language_id

Restrict delete

elicitation_prompts_prompt_type_id_foreign

elicitation_prompts.prompt_type_id

prompt_types.prompt_type_id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint