144 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| organism_id_fk |
|
|
Restrict delete | ||
| accession_name_id_fk |
|
|
Restrict delete | ||
| accession_chado_organism_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| clone_id_fk |
|
|
Restrict delete | ||
| family_tree_family_id_fkey |
|
|
Restrict delete | ||
| cds_protein_feature_id_fkey |
|
|
Restrict delete | ||
| cds_unigene_id_fkey |
|
|
Cascade on delete | ||
| snp_file_file_id_fkey |
|
|
Restrict delete | ||
| snp_file_snp_id_fkey |
|
|
Restrict delete | ||
| foriegn |
|
|
Restrict delete | ||
| library_sp_person_id_fkey |
|
|
Restrict delete | ||
| type_fkey |
|
|
Restrict delete | ||
| library_chado_organism_id_fkey |
|
|
Restrict delete | ||
| unigene_id_fk |
|
|
Restrict delete | ||
| ssr_id_fk |
|
|
Restrict delete | ||
| organismgroup_member_organism_id_fkey |
|
|
Restrict delete | ||
| organismgroup_member_organismgroup_id_fkey |
|
|
Restrict delete | ||
| organismprop_common_name_id_fkey |
|
|
Restrict delete | ||
| organismprop_type_id_fkey |
|
|
Restrict delete | ||
| marker_type_fk |
|
|
Restrict delete | ||
| blast_db_blast_db_group_blast_db_group_id_fkey |
|
|
Restrict delete | ||
| blast_db_blast_db_group_blast_db_id_fkey |
|
|
Restrict delete | ||
| accession_id_fk |
|
|
Restrict delete | ||
| pcr_exp_accession_stock_id_fkey |
|
|
Restrict delete | ||
| pcr_experiment_id_fk |
|
|
Cascade on delete | ||
| map_ancestor_fkey |
|
|
Restrict delete | ||
| map_parent1_stock_id_fkey |
|
|
Restrict delete | ||
| map_population_id_fkey |
|
|
Cascade on delete | ||
| map_parent_1_fkey |
|
|
Restrict delete | ||
| map_parent2_stock_id_fkey |
|
|
Restrict delete | ||
| map_parent_2_fkey |
|
|
Restrict delete | ||
| map_population_stock_id_fkey |
|
|
Restrict delete | ||
| interpro_go_go_accession_fkey |
|
|
Cascade on delete | ||
| interpro_go_interpro_accession_fkey |
|
|
Cascade on delete | ||
| domain_dbxref_id_fkey |
|
|
Restrict delete | ||
| domain_metadata_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| unigene_build_blast_db_id_fkey |
|
|
Restrict delete | ||
| unigene_build_superseding_build_id_fkey |
|
|
Restrict delete | ||
| unigene_build_organism_group_id_fkey |
|
|
Restrict delete | ||
| unigene_build_latest_build_id_fkey |
|
|
Restrict delete | ||
| unigene_build_next_build_id_fkey |
|
|
Restrict delete | ||
| blast_db_blast_db_group_id_fkey |
|
|
Restrict delete | ||
| family_family_build_id_fkey |
|
|
Cascade on delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| primer_id_fwd_fk |
|
|
Restrict delete | ||
| map_id_fk |
|
|
Restrict delete | ||
| primer_id_rev_fk |
|
|
Restrict delete | ||
| pcr_experiment_stock_id_fkey |
|
|
Restrict delete | ||
| experiment_type_id_fk |
|
|
Restrict delete | ||
| temp_marker_correspondence_old_marker_id_fkey |
|
|
Restrict delete | ||
| snp_sequence_right_id_fkey |
|
|
Restrict delete | ||
| snp_metadata_id_fkey |
|
|
Restrict delete | ||
| snp_marker_id_fkey |
|
|
Restrict delete | ||
| snp_stock_id_fkey |
|
|
Restrict delete | ||
| snp_reference_stock_id_fkey |
|
|
Restrict delete | ||
| snp_sequence_left_id_fkey |
|
|
Restrict delete | ||
| unigene_unigene_build_id_fkey |
|
|
Restrict delete | ||
| unigene_unigene_consensi_id_fkey |
|
|
Restrict delete | ||
| marker_collectible_marker_id_fkey |
|
|
Restrict delete | ||
| marker_collectible_mc_id_fkey |
|
|
Restrict delete | ||
| pcr_experiment_sequence_sequence_id_fkey |
|
|
Cascade on delete | ||
| pcr_experiment_sequence_pcr_experiment_id_fkey |
|
|
Cascade on delete | ||
| pcr_experiment_sequence_type_id_fkey |
|
|
Restrict delete | ||
| blast_db_organism_organism_id_fkey |
|
|
Restrict delete | ||
| blast_db_organism_blast_db_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| confidence_fk |
|
|
Restrict delete | ||
| loc_id_fk |
|
|
Cascade on delete | ||
| domain_match_domain_id_fkey |
|
|
Cascade on delete | ||
| domain_match_metadata_id_fkey |
|
|
Restrict delete | ||
| domain_match_cds_id_fkey |
|
|
Cascade on delete | ||
| read_id_fkey |
|
|
Restrict delete | ||
| temp_map_correspondence_old_map_id_fkey |
|
|
Restrict delete | ||
| temp_map_correspondence_map_version_id_fkey |
|
|
Restrict delete | ||
| marker_experiment_marker_id_fkey |
|
|
Restrict delete | ||
| marker_experiment_pcr_experiment_id_fkey |
|
|
Restrict delete | ||
| marker_experiment_location_id_fkey |
|
|
Cascade on delete | ||
| marker_experiment_rflp_experiment_id_fkey |
|
|
Restrict delete | ||
| snpprop_type_id_fkey |
|
|
Restrict delete | ||
| snpprop_snp_id_fkey |
|
|
Restrict delete | ||
| author_id_fk |
|
|
Restrict delete | ||
| blast_hits_blast_annotation_id_fkey |
|
|
Cascade on delete | ||
| lg_id_fk |
|
|
Restrict delete | ||
| map_id_fk |
|
|
Restrict delete | ||
| linkage_group_south_location_id_fkey |
|
|
Restrict delete | ||
| linkage_group_map_version_id_fkey |
|
|
Cascade on delete | ||
| linkage_group_north_location_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| map_version_metadata_id_fkey |
|
|
Cascade on delete | ||
| map_version_default_threshold_fkey |
|
|
Restrict delete | ||
| map_version_map_id_fkey |
|
|
Cascade on delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| tm_id_fk |
|
|
Restrict delete | ||
| map_id_fk |
|
|
Restrict delete | ||
| marker_derived_from_marker_id_fkey |
|
|
Restrict delete | ||
| marker_derived_from_derived_from_source_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| facility_id_fk |
|
|
Restrict delete | ||
| clone_id_fk |
|
|
Restrict delete | ||
| fish_result_clone_id_fkey |
|
|
Restrict delete | ||
| fish_experimenter_id_fkey |
|
|
Restrict delete | ||
| map_id_fkey |
|
|
Restrict delete | ||
| fish_result_attribution_id_fkey |
|
|
Restrict delete | ||
| map_id_fk |
|
|
Restrict delete | ||
| organism_id_fk |
|
|
Restrict delete | ||
| est_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| est_dbxref_est_id_fkey |
|
|
Restrict delete | ||
| accession_id_fk |
|
|
Restrict delete | ||
| marker_alias_marker_id_fkey |
|
|
Restrict delete | ||
| apply_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| ssr_id_fk |
|
|
Restrict delete | ||
| enzyme_id_fk |
|
|
Restrict delete | ||
| pcr_exp_accession_id_fk |
|
|
Cascade on delete | ||
| fish_result_image_image_id_fkey |
|
|
Restrict delete | ||
| fish_result_image_fish_result_id_fkey |
|
|
Cascade on delete | ||
| marker_location_confidence_id_fkey |
|
|
Restrict delete | ||
| marker_location_lg_id_fkey |
|
|
Cascade on delete | ||
| marker_location_map_version_id_fkey |
|
|
Cascade on delete | ||
| organism_chado_organism_id_fkey |
|
|
Restrict delete | ||
| organism_genus_tax_fkey |
|
|
Restrict delete | ||
| organism_order_tax_fkey |
|
|
Restrict delete | ||
| common_name_id_fk |
|
|
Restrict delete | ||
| organism_family_tax_fkey |
|
|
Restrict delete | ||
| organism_subfamily_tax_fkey |
|
|
Restrict delete | ||
| chadoprop_type_id_fkey |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| reverse_seq_id_fk |
|
|
Restrict delete | ||
| forward_seq_id_fk |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| primer_unigene_match_unigene_id_fkey |
|
|
Restrict delete | ||
| foriegn |
|
|
Restrict delete | ||
| family_member_family_id_fkey |
|
|
Cascade on delete | ||
| unigene_id_fk |
|
|
Restrict delete | ||
| rflp_seq_id_fk |
|
|
Restrict delete | ||
| est_id_fk |
|
|
Restrict delete | ||
| library_id_fk |
|
|
Restrict delete | ||
| marker_id_fk |
|
|
Restrict delete | ||
| est_id_fkey |
|
|
Restrict delete | ||
| unigene_member_unigene_id_fkey |
|
|
Restrict delete | ||
| metadata_modified_person_id_fkey |
|
|
Restrict delete | ||
| metadata_create_person_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| fish_karyotype_constants | chromo_arm_enum | (((chromo_arm = 'P'::text) OR (chromo_arm = 'Q'::text))) |
| map | map_map_type_check | (((map_type = 'genetic'::text) OR (map_type = 'fish'::text) OR (map_type = 'sequence'::text) OR (map_type = 'QTL'::text))) |
| map | map_units_check | (((units = 'cM'::text) OR (units = 'Mb'::text))) |
| cosii_ortholog | cosii_ortholog_copies_check | ((((copies)::text = 'S'::text) OR ((copies)::text = 'M'::text))) |
| cosii_ortholog | cosii_ortholog_database_name_check | ((((database_name)::text = 'SGN'::text) OR ((database_name)::text = 'Arabidopsis'::text) OR ((database_name)::text = 'Coffee'::text))) |
| unigene_build | unigene_build_status_check | (((status = 'C'::bpchar) OR (status = 'D'::bpchar) OR (status = 'P'::bpchar))) |
| blast_db | blast_db_file_base_check | (((file_base)::text !~~ '/%'::text)) |
| blast_db | blast_db_info_url_check | (((info_url IS NULL) OR ((info_url)::text ~ similar_escape('(ftp|http|https)://%'::text, NULL::text)))) |
| blast_db | blast_db_lookup_url_check | (((lookup_url IS NULL) OR ((lookup_url)::text ~ similar_escape('(ftp|http|https)://%%s%'::text, NULL::text)))) |
| blast_db | blast_db_source_url_check | (((source_url IS NULL) OR ((source_url)::text ~ similar_escape('(ftp|http|https|cxgn-resource|file)://%'::text, NULL::text)))) |
| blast_db | blast_db_type_check | ((((type)::text = 'protein'::text) OR ((type)::text = 'nucleotide'::text))) |
| blast_db | blast_db_update_freq_check | ((((update_freq)::text = 'daily'::text) OR ((update_freq)::text = 'weekly'::text) OR ((update_freq)::text = 'monthly'::text) OR ((update_freq)::text = 'manual'::text))) |
| pcr_experiment | different_primers | (((primer_id_fwd IS NULL) OR (primer_id_rev IS NULL) OR (NOT (primer_id_fwd = primer_id_rev)))) |
| pcr_experiment | primer_type_enum | ((((primer_type)::text = 'iUPA'::text) OR ((primer_type)::text = 'eUPA'::text) OR (primer_type IS NULL))) |
| unigene | unigene_database_name_check | ((((database_name)::text = 'SGN'::text) OR ((database_name)::text = 'CGN'::text))) |
| unigene | unigene_nr_members_iff_consensi_id | ((((nr_members > 1) AND (consensi_id IS NOT NULL)) OR ((nr_members = 1) AND (consensi_id IS NULL)))) |
| organismgroup | organismgroup_type_check | ((((type)::text = 'common name'::text) OR ((type)::text = 'unigene build'::text) OR ((type)::text = ''::text))) |
| marker_experiment | marker_experiment_check | (((rflp_experiment_id IS NOT NULL) OR (pcr_experiment_id IS NOT NULL) OR (location_id IS NOT NULL))) |
| marker_experiment | marker_experiment_check1 | ((((pcr_experiment_id IS NOT NULL) AND (rflp_experiment_id IS NULL)) OR ((pcr_experiment_id IS NULL) AND (rflp_experiment_id IS NOT NULL)) OR ((pcr_experiment_id IS NULL) AND (rflp_experiment_id IS NULL) AND (location_id IS NOT NULL)))) |
| marker_experiment | marker_experiment_protocol_check | (((protocol = 'AFLP'::text) OR (protocol = 'CAPS'::text) OR (protocol = 'RAPD'::text) OR (protocol = 'SNP'::text) OR (protocol = 'SSR'::text) OR (protocol = 'RFLP'::text) OR (protocol = 'PCR'::text) OR (protocol = 'dCAPS'::text) OR (protocol = 'DART'::text) OR (protocol = 'OPA'::text) OR (protocol = 'unknown'::text) OR (protocol = 'ASPE'::text) OR (protocol = 'INDEL'::text) OR (protocol = 'QTL'::text))) |
| marker_experiment | marker_experiment_rflp_protocol_consistency | ((((protocol = 'RFLP'::text) AND (pcr_experiment_id IS NULL)) OR ((protocol <> 'RFLP'::text) AND (rflp_experiment_id IS NULL)))) |
| fish_result_composite | fish_result_composite_chromo_arm_check | ((((chromo_arm)::text = 'P'::text) OR ((chromo_arm)::text = 'Q'::text))) |
| fish_result_composite | fish_result_composite_het_or_eu_check | ((((het_or_eu)::text = 'H'::text) OR ((het_or_eu)::text = 'E'::text))) |
| fish_result | fish_result_chromo_arm_check | ((((chromo_arm)::text = 'P'::text) OR ((chromo_arm)::text = 'Q'::text))) |
| fish_chromatin_density_constants | fish_chromatin_density_constants_arm_check | ((((arm)::text = 'E'::text) OR ((arm)::text = 'H'::text))) |
| pcr_product | band_size_or_multiple_check | ((((band_size IS NOT NULL) OR (multiple_flag IS NOT NULL)) AND (NOT ((band_size IS NOT NULL) AND (multiple_flag IS NOT NULL))))) |
| pcr_product | multiple_flag_null_or_1 | (((multiple_flag = 1) OR (multiple_flag IS NULL))) |
| marker_location | marker_location_subscript_check | (((subscript = 'A'::bpchar) OR (subscript = 'B'::bpchar) OR (subscript = 'C'::bpchar) OR (subscript IS NULL))) |
| rflp_markers | clone_name_not_null_check | ((clone_name IS NOT NULL)) |
| rflp_markers | cutting_site_not_null_check | ((cutting_site IS NOT NULL)) |
| rflp_markers | drug_resistance_not_null_check | ((drug_resistance IS NOT NULL)) |
| rflp_markers | insert_size_not_null_check | ((insert_size IS NOT NULL)) |
| rflp_markers | marker_prefix_not_null_check | ((marker_prefix IS NOT NULL)) |
| rflp_markers | marker_suffix_not_null_check | ((marker_suffix IS NOT NULL)) |
| rflp_markers | vector_not_null_check | ((vector IS NOT NULL)) |
| deprecated_maps | maps_map_type_check | ((((map_type)::text = 'genetic'::text) OR ((map_type)::text = 'fish'::text))) |