190 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| allele_alias_allele_id_fkey |
|
|
Restrict delete | ||
| allele_alias_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_dbxref_allele_id_fkey |
|
|
Restrict delete | ||
| allele_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| allele_dbxref_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_history_allele_id_fkey |
|
|
Cascade on delete | ||
| allele_history_locus_id_fkey |
|
|
Cascade on delete | ||
| allele_history_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_history_updated_by_fkey |
|
|
Restrict delete | ||
| allele_locus_id_fkey |
|
|
Restrict delete | ||
| allele_sp_person_id_fkey |
|
|
Restrict delete | ||
| allele_updated_by_fkey |
|
|
Restrict delete | ||
| cvterm_pub_ranking_cvterm_id_fkey |
|
|
Restrict delete | ||
| cvterm_pub_ranking_pub_id_fkey |
|
|
Restrict delete | ||
| genotype_background_accession_id_fkey |
|
|
Restrict delete | ||
| genotype_experiment_background_accession_id_fkey |
|
|
Restrict delete | ||
| genotype_experiment_reference_map_id_fkey |
|
|
Cascade on delete | ||
| genotype_experiment_sp_person_id_fkey |
|
|
Restrict delete | ||
| genotype_genotype_experiment_id_fkey |
|
|
Restrict delete | ||
| genotype_individual_id_fkey |
|
|
Cascade on delete | ||
| genotype_reference_map_id_fkey |
|
|
Restrict delete | ||
| genotype_region_genotype_id_fkey |
|
|
Cascade on delete | ||
| genotype_region_lg_id_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_nn_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_ns_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_sn_fkey |
|
|
Restrict delete | ||
| genotype_region_marker_id_ss_fkey |
|
|
Restrict delete | ||
| genotype_region_sp_person_id_fkey |
|
|
Restrict delete | ||
| genotype_sp_person_id_fkey |
|
|
Restrict delete | ||
| germplasm_dbxref_id_fkey |
|
|
Restrict delete | ||
| germplasm_individual_id_fkey |
|
|
Restrict delete | ||
| germplasm_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_accession_id_fkey |
|
|
Restrict delete | ||
| individual_alias_individual_id_fkey |
|
|
Restrict delete | ||
| individual_alias_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_allele_allele_id_fkey |
|
|
Restrict delete | ||
| individual_allele_individual_id_fkey |
|
|
Restrict delete | ||
| individual_allele_sp_person_id_fkey |
|
|
Restrict delete | ||
| individual_common_name_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_evidence_code_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_evidence_description_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_evidence_with_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_evidence_description_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_reference_id_fkey |
|
|
Restrict delete | ||
| individual_dbxref_evidence_history_relationship_type_fkey |
|
|
Restrict delete |
Processing...
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| 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))) |
| 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))) |
| germplasm | chk_germplasm_germplasm_type | ((((germplasm_type)::text = 'seed'::text) OR ((germplasm_type)::text = 'vegetative'::text))) |
| locus | chk_lg_arm | ((((lg_arm)::text = 'short'::text) OR ((lg_arm)::text = 'long'::text) OR ((lg_arm)::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))) |
| locusgroup_member | locusgroup_member_direction_check | ((((direction)::text = 'subject'::text) OR ((direction)::text = 'object'::text) OR ((direction)::text = ''::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))) |
| tomato_il_bin | tomato_il_bin_chromosome_check | (((chromosome >= 1) AND (chromosome <= 12))) |
Processing...