144 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| accession_chado_organism_id_fkey |
|
|
Restrict delete | ||
| accession_id_fk |
|
|
Restrict delete | ||
| accession_id_fk |
|
|
Restrict delete | ||
| accession_name_id_fk |
|
|
Restrict delete | ||
| apply_id_fkey |
|
|
Restrict delete | ||
| author_id_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 | ||
| blast_db_blast_db_group_id_fkey |
|
|
Restrict delete | ||
| blast_db_organism_blast_db_id_fkey |
|
|
Restrict delete | ||
| blast_db_organism_organism_id_fkey |
|
|
Restrict delete | ||
| blast_hits_blast_annotation_id_fkey |
|
|
Cascade on delete | ||
| cds_protein_feature_id_fkey |
|
|
Restrict delete | ||
| cds_unigene_id_fkey |
|
|
Cascade on delete | ||
| chadoprop_type_id_fkey |
|
|
Restrict delete | ||
| clone_id_fk |
|
|
Restrict delete | ||
| clone_id_fk |
|
|
Restrict delete | ||
| common_name_id_fk |
|
|
Restrict delete | ||
| confidence_fk |
|
|
Restrict delete | ||
| domain_dbxref_id_fkey |
|
|
Restrict delete | ||
| domain_match_cds_id_fkey |
|
|
Cascade on delete | ||
| domain_match_domain_id_fkey |
|
|
Cascade on delete | ||
| domain_match_metadata_id_fkey |
|
|
Restrict delete | ||
| domain_metadata_id_fkey |
|
|
Restrict delete | ||
| enzyme_id_fk |
|
|
Restrict delete | ||
| est_dbxref_dbxref_id_fkey |
|
|
Restrict delete | ||
| est_dbxref_est_id_fkey |
|
|
Restrict delete | ||
| est_id_fk |
|
|
Restrict delete | ||
| est_id_fkey |
|
|
Restrict delete | ||
| experiment_type_id_fk |
|
|
Restrict delete | ||
| facility_id_fk |
|
|
Restrict delete | ||
| family_family_build_id_fkey |
|
|
Cascade on delete | ||
| family_member_family_id_fkey |
|
|
Cascade on delete | ||
| family_tree_family_id_fkey |
|
|
Restrict delete | ||
| fish_experimenter_id_fkey |
|
|
Restrict delete | ||
| fish_result_attribution_id_fkey |
|
|
Restrict delete | ||
| fish_result_clone_id_fkey |
|
|
Restrict delete | ||
| fish_result_image_fish_result_id_fkey |
|
|
Cascade on delete | ||
| fish_result_image_image_id_fkey |
|
|
Restrict delete | ||
| foriegn |
|
|
Restrict delete | ||
| foriegn |
|
|
Restrict delete | ||
| forward_seq_id_fk |
|
|
Restrict delete | ||
| interpro_go_go_accession_fkey |
|
|
Cascade on delete | ||
| interpro_go_interpro_accession_fkey |
|
|
Cascade on delete | ||
| lg_id_fk |
|
|
Restrict delete | ||
| library_chado_organism_id_fkey |
|
|
Restrict delete | ||
| library_id_fk |
|
|
Restrict delete | ||
| library_sp_person_id_fkey |
|
|
Restrict delete | ||
| linkage_group_map_version_id_fkey |
|
|
Cascade on delete | ||
| linkage_group_north_location_id_fkey |
|
|
Restrict delete |
Processing...
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| 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))) |
| 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))) |
| deprecated_maps | maps_map_type_check | ((((map_type)::text = 'genetic'::text) OR ((map_type)::text = 'fish'::text))) |
| fish_chromatin_density_constants | fish_chromatin_density_constants_arm_check | ((((arm)::text = 'E'::text) OR ((arm)::text = 'H'::text))) |
Processing...