190 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| population_common_name_id_fkey |
|
|
Restrict delete | ||
| population_cross_type_id_fkey |
|
|
Restrict delete | ||
| population_female_parent_id_fkey |
|
|
Restrict delete | ||
| population_male_parent_id_fkey |
|
|
Restrict delete | ||
| population_person_id_fkey |
|
|
Restrict delete | ||
| population_sp_person_id_fkey |
|
|
Restrict delete | ||
| population_donor_parent_id_fkey |
|
|
Restrict delete | ||
| population_recurrent_parent_id_fkey |
|
|
Restrict delete | ||
| population_background_accession_id_fkey |
|
|
Restrict delete | ||
| locus_unigene_unigene_id_fkey |
|
|
Restrict delete | ||
| locus_unigene_locus_id_fkey |
|
|
Restrict delete | ||
| locus_unigene_sp_person_id_fkey |
|
|
Restrict delete | ||
| population_dbxref_population_id_fkey |
|
|
Cascade on delete | ||
| population_dbxref_sp_person_id_fkey |
|
|
Null on delete | ||
| population_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| locus_pub_ranking_validate_locus_id_fkey |
|
|
Restrict delete | ||
| locus_pub_ranking_validate_pub_id_fkey |
|
|
Restrict delete | ||
| locus_marker_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_marker_marker_id_fkey |
|
|
Restrict delete | ||
| locus_marker_locus_id_fkey |
|
|
Restrict delete | ||
| project_md_image_project_id_fkey |
|
|
Restrict delete | ||
| project_md_image_type_id_fkey |
|
|
Restrict delete | ||
| project_md_image_image_id_fkey |
|
|
Restrict delete | ||
| locus2locus_object_id_fkey |
|
|
Restrict delete | ||
| locus2locus_relationship_id_fkey |
|
|
Restrict delete | ||
| locus2locus_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus2locus_reference_id_fkey |
|
|
Restrict delete | ||
| locus2locus_evidence_id_fkey |
|
|
Restrict delete | ||
| locus2locus_subject_id_fkey |
|
|
Restrict delete | ||
| variant_locus_id_fkey |
|
|
Restrict delete | ||
| cvterm_pub_ranking_pub_id_fkey |
|
|
Restrict delete | ||
| cvterm_pub_ranking_cvterm_id_fkey |
|
|
Restrict delete | ||
| polymorphic_fragment_sp_person_id_fkey |
|
|
Restrict delete | ||
| polymorphic_fragment_flanking_marker2_id_fkey |
|
|
Restrict delete | ||
| polymorphic_fragment_flanking_marker1_id_fkey |
|
|
Restrict delete | ||
| polymorphic_fragment_genotype_id_fkey |
|
|
Restrict delete | ||
| locusgroup_sp_person_id_fkey |
|
|
Restrict delete | ||
| locusgroup_relationship_id_fkey |
|
|
Restrict delete | ||
| stock_allele_allele_id_fkey |
|
|
Cascade on delete | ||
| stock_image_metadata_id_fkey |
|
|
Cascade on delete | ||
| stock_allele_stock_id_fkey |
|
|
Cascade on delete | ||
| user_trait_sp_person_id_fkey |
|
|
Restrict delete | ||
| user_trait_cv_id_fkey |
|
|
Restrict delete | ||
| user_trait_dbxref_id_fkey |
|
|
Null on delete | ||
| locus_pub_ranking_locus_id_fkey |
|
|
Restrict delete | ||
| locus_pub_ranking_pub_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_reference_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_evidence_with_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_evidence_description_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_evidence_relationship_type_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_locus_dbxref_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_evidence_code_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_updated_by_fkey |
|
|
Restrict delete | ||
| locus_owner_locus_id_fkey |
|
|
Cascade on delete | ||
| locus_owner_granted_by_fkey |
|
|
Restrict delete | ||
| locus_owner_sp_person_id_fkey |
|
|
Restrict delete | ||
| tomato_il_bin_n_marker_s_fkey |
|
|
Restrict delete | ||
| tomato_il_bin_s_marker_s_fkey |
|
|
Restrict delete | ||
| tomato_il_bin_n_marker_n_fkey |
|
|
Restrict delete | ||
| tomato_il_bin_s_marker_n_fkey |
|
|
Restrict delete | ||
| nd_experiment_md_json_json_id_fkey |
|
|
Restrict delete | ||
| nd_experiment_md_json_nd_experiment_id_fkey |
|
|
Restrict delete | ||
| locusgroup_member_locusgroup_id_fkey |
|
|
Restrict delete | ||
| locusgroup_member_sp_person_id_fkey |
|
|
Restrict delete | ||
| locusgroup_member_evidence_id_fkey |
|
|
Restrict delete | ||
| locusgroup_member_reference_id_fkey |
|
|
Restrict delete | ||
| locusgroup_member_locus_id_fkey |
|
|
Cascade on delete | ||
| locus_dbxref_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_locus_id_fkey |
|
|
Restrict delete | ||
| locus_history_locus_id_fkey |
|
|
Cascade on delete | ||
| locus_history_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_history_updated_by_fkey |
|
|
Restrict delete | ||
| nd_experiment_md_images_nd_experiment_id_fkey |
|
|
Restrict delete | ||
| nd_experiment_md_images_image_id_fkey |
|
|
Restrict delete | ||
| allele_alias_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_alias_allele_id_fkey |
|
|
Restrict delete | ||
| individual_image_individual_id_fkey |
|
|
Restrict delete | ||
| individual_image_image_id_fkey |
|
|
Restrict delete | ||
| individual_image_sp_person_id_fkey |
|
|
Restrict delete | ||
| stock_image_image_id_fkey |
|
|
Restrict delete | ||
| stock_image_metadata_id_fkey |
|
|
Restrict delete | ||
| stock_image_stock_id_fkey |
|
|
Restrict delete | ||
| individual_alias_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_alias_individual_id_fkey |
|
|
Restrict delete | ||
| germplasm_dbxref_id_fkey |
|
|
Restrict delete | ||
| germplasm_sp_person_id_fkey |
|
|
Restrict delete | ||
| germplasm_individual_id_fkey |
|
|
Restrict delete | ||
| individual_population_id_fkey |
|
|
Cascade on delete | ||
| individual_common_name_id_fkey |
|
|
Restrict delete | ||
| individual_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_accession_id_fkey |
|
|
Restrict delete | ||
| individual_updated_by_fkey |
|
|
Restrict delete | ||
| registry_updated_by_fkey |
|
|
Restrict delete | ||
| registry_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_dbxref_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| allele_dbxref_allele_id_fkey |
|
|
Restrict delete | ||
| user_trait_unit_population_id_fkey |
|
|
Cascade on delete | ||
| user_trait_unit_unit_id_fkey |
|
|
Cascade on delete | ||
| user_trait_unit_user_trait_id_fkey |
|
|
Cascade on delete | ||
| nd_experiment_md_files_nd_experiment_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_individual_id_fkey |
|
|
Restrict delete | ||
| genotype_region_sp_person_id_fkey |
|
|
Restrict delete | ||
| genotype_region_lg_id_fkey |
|
|
Restrict delete | ||
| genotype_region_genotype_id_fkey |
|
|
Cascade on delete | ||
| genotype_region_marker_id_ss_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_nn_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_sn_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_ns_fkey |
|
|
Restrict delete | ||
| genotype_experiment_reference_map_id_fkey |
|
|
Cascade on delete | ||
| genotype_experiment_background_accession_id_fkey |
|
|
Restrict delete | ||
| genotype_experiment_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_locus_individual_id_fkey |
|
|
Restrict delete | ||
| individual_locus_locus_id_fkey |
|
|
Restrict delete | ||
| individual_locus_sp_person_id_fkey |
|
|
Restrict delete | ||
| phenotype_user_trait_user_trait_id_fkey |
|
|
Restrict delete | ||
| phenotype_user_trait_phenotype_id_fkey |
|
|
Cascade on delete | ||
| stock_owner_metadata_id_fkey |
|
|
Restrict delete | ||
| stock_owner_stock_id_fkey |
|
|
Restrict delete | ||
| stock_owner_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_locus_dbxref_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_locus_dbxref_evidence_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_evidence_code_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_reference_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_updated_by_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_relationship_type_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_evidence_description_fkey |
|
|
Restrict delete | ||
| locus_dbxref_evidence_history_evidence_with_fkey |
|
|
Restrict delete | ||
| locus_alias_locus_id_fkey |
|
|
Restrict delete | ||
| locus_alias_sp_person_id_fkey |
|
|
Restrict delete | ||
| is_public_owner_id_fkey |
|
|
Restrict delete | ||
| is_public_population_id_fkey |
|
|
Cascade on delete | ||
| locus_image_image_id_fkey |
|
|
Restrict delete | ||
| locus_image_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_image_locus_id_fkey |
|
|
Restrict delete | ||
| individual_allele_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_allele_allele_id_fkey |
|
|
Restrict delete | ||
| individual_allele_individual_id_fkey |
|
|
Restrict delete | ||
| allele_updated_by_fkey |
|
|
Restrict delete | ||
| allele_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_locus_id_fkey |
|
|
Restrict delete | ||
| allele_history_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_history_updated_by_fkey |
|
|
Restrict delete | ||
| allele_history_locus_id_fkey |
|
|
Cascade on delete | ||
| allele_history_allele_id_fkey |
|
|
Cascade on delete | ||
| individual_dbxref_evidence_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_evidence_code_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_evidence_description_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_updated_by_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_relationship_type_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_individual_dbxref_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_reference_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_evidence_with_fkey |
|
|
Restrict delete | ||
| pub_curator_assigned_to_fkey |
|
|
Restrict delete | ||
| pub_curator_sp_person_id_fkey |
|
|
Restrict delete | ||
| pub_curator_curated_by_fkey |
|
|
Restrict delete | ||
| pub_curator_pub_id_fkey |
|
|
Restrict delete | ||
| locus_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_common_name_id_fkey |
|
|
Restrict delete | ||
| locus_organism_id_fkey |
|
|
Restrict delete | ||
| locus_updated_by_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_evidence_description_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_updated_by_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_hi_individual_dbxref_evidence_i_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_evidence_code_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_reference_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_evidence_with_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_individual_dbxref_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_relationship_type_fkey |
|
|
Restrict delete | ||
| individual_history_individual_id_fkey |
|
|
Cascade on delete | ||
| individual_history_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_history_updated_by_fkey |
|
|
Restrict delete | ||
| locus_registry_registry_id_fkey |
|
|
Restrict delete | ||
| locus_registry_sp_person_id_fkey |
|
|
Restrict delete | ||
| locus_registry_locus_id_fkey |
|
|
Restrict delete | ||
| genotype_genotype_experiment_id_fkey |
|
|
Restrict delete | ||
| genotype_reference_map_id_fkey |
|
|
Restrict delete | ||
| genotype_individual_id_fkey |
|
|
Cascade on delete | ||
| genotype_background_accession_id_fkey |
|
|
Restrict delete | ||
| genotype_sp_person_id_fkey |
|
|
Restrict delete | ||
| stock_file_file_id_fkey |
|
|
Cascade on delete | ||
| stock_file_stock_id_fkey |
|
|
Cascade on delete | ||
| project_owner_project_id_fkey |
|
|
Restrict delete | ||
| project_owner_sp_person_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| tomato_il_bin | tomato_il_bin_chromosome_check | (((chromosome >= 1) AND (chromosome <= 12))) |
| locusgroup_member | locusgroup_member_direction_check | ((((direction)::text = 'subject'::text) OR ((direction)::text = 'object'::text) OR ((direction)::text = ''::text))) |
| locus_history | locus_history_lg_arm_check | ((((lg_arm)::text = 'short'::text) OR ((lg_arm)::text = 'long'::text) OR ((lg_arm)::text = ''::text))) |
| germplasm | chk_germplasm_germplasm_type | ((((germplasm_type)::text = 'seed'::text) OR ((germplasm_type)::text = 'vegetative'::text))) |
| registry | registry_status_check | ((((status)::text = 'registered'::text) OR ((status)::text = 'active'::text) OR ((status)::text = 'inactive'::text) OR ((status)::text = 'deleted'::text) OR ((status)::text = 'obsolete'::text))) |
| genotype_region | genotype_region_type_check | ((((type)::text = 'bin'::text) OR ((type)::text = 'map'::text) OR ((type)::text = 'inbred'::text))) |
| genotype_region | genotype_region_zygocity_code_check | ((((zygocity_code)::text = 'a'::text) OR ((zygocity_code)::text = 'b'::text) OR ((zygocity_code)::text = 'c'::text) OR ((zygocity_code)::text = 'd'::text) OR ((zygocity_code)::text = 'h'::text))) |
| allele | chk_allele_mode_of_inheritance | ((((mode_of_inheritance)::text = 'recessive'::text) OR ((mode_of_inheritance)::text = 'partially dominant'::text) OR ((mode_of_inheritance)::text = 'dominant'::text) OR ((mode_of_inheritance)::text = ''::text))) |
| allele_history | allele_history_mode_of_inheritance_check | ((((mode_of_inheritance)::text = 'dominant'::text) OR ((mode_of_inheritance)::text = 'partially dominant'::text) OR ((mode_of_inheritance)::text = 'recessive'::text) OR ((mode_of_inheritance)::text = ''::text))) |
| locus | chk_lg_arm | ((((lg_arm)::text = 'short'::text) OR ((lg_arm)::text = 'long'::text) OR ((lg_arm)::text = ''::text))) |