46 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| clone_il_mapping_bin_log_clone_id_fkey |
|
|
Restrict delete | ||
| clone_il_mapping_bin_log_genotype_region_id_fkey |
|
|
Restrict delete | ||
| clone_il_mapping_bin_log_sp_person_id_fkey |
|
|
Restrict delete | ||
| clone_validation_log_clone_id_fkey |
|
|
Restrict delete | ||
| clone_validation_log_sp_person_id_fkey |
|
|
Restrict delete | ||
| clone_verification_log_clone_id_fkey |
|
|
Restrict delete | ||
| clone_verification_log_sp_person_id_fkey |
|
|
Restrict delete | ||
| forum_topic_id_fk |
|
|
Restrict delete | ||
| list_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
| list_dbxref_list_id_fkey |
|
|
Cascade on delete | ||
| list_item_list_id_fkey |
|
|
Cascade on delete | ||
| list_owner_fkey |
|
|
Cascade on delete | ||
| list_type_id_fkey |
|
|
Restrict delete | ||
| listprop_list_id_fkey |
|
|
Restrict delete | ||
| listprop_type_id_fkey |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| person_id_fk |
|
|
Restrict delete | ||
| sp_clone_il_mapping_segment_log_clone_id_fkey |
|
|
Restrict delete | ||
| sp_clone_il_mapping_segment_log_individual_id_fkey |
|
|
Restrict delete | ||
| sp_clone_il_mapping_segment_log_sp_person_id_fkey |
|
|
Restrict delete | ||
| sp_dataset_sp_person_id_fkey |
|
|
Restrict delete | ||
| sp_group_member_sp_group_id_fkey |
|
|
Cascade on delete | ||
| sp_group_member_sp_person_id_fkey |
|
|
Cascade on delete | ||
| sp_order_order_from_id_fkey |
|
|
Restrict delete | ||
| sp_order_order_to_id_fkey |
|
|
Restrict delete | ||
| sp_orderprop_sp_order_id_fkey |
|
|
Restrict delete | ||
| sp_orderprop_type_id_fkey |
|
|
Restrict delete | ||
| sp_person_roles_sp_person_id_fkey |
|
|
Cascade on delete | ||
| sp_person_roles_sp_role_id_fkey |
|
|
Cascade on delete | ||
| sp_project_il_mapping_clone_log_clone_id_fkey |
|
|
Restrict delete | ||
| sp_project_il_mapping_clone_log_sp_person_id_fkey |
|
|
Restrict delete | ||
| sp_project_il_mapping_clone_log_sp_project_id_fkey |
|
|
Restrict delete | ||
| sp_project_person_sp_project_id_fkey |
|
|
Restrict delete | ||
| sp_token_sp_person_id_fkey |
|
|
Restrict delete | ||
| user_map_data_marker_id_fkey |
|
|
Restrict delete | ||
| user_map_data_sp_person_id_fkey |
|
|
Restrict delete | ||
| user_map_data_user_map_id_fkey |
|
|
Restrict delete | ||
| user_map_parent1_accession_id_fkey |
|
|
Restrict delete | ||
| user_map_parent2_accession_id_fkey |
|
|
Restrict delete | ||
| user_map_sp_person_id_fkey |
|
|
Restrict delete |
Processing...
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| bac_status | chk_bac_status_genbank_status | ((((genbank_status)::text = 'htgs1'::text) OR ((genbank_status)::text = 'htgs2'::text) OR ((genbank_status)::text = 'htgs3'::text) OR ((genbank_status)::text = 'htgs4'::text) OR ((genbank_status)::text = ''::text) OR (genbank_status IS NULL))) |
| bac_status | chk_bac_status_status | ((((status)::text = 'not_sequenced'::text) OR ((status)::text = 'in_progress'::text) OR ((status)::text = 'complete'::text) OR ((status)::text = ''::text) OR (status IS NULL))) |
| bac_status_log | chk_bac_status_log_genbank_status | ((((genbank_status)::text = 'htgs1'::text) OR ((genbank_status)::text = 'htgs2'::text) OR ((genbank_status)::text = 'htgs3'::text) OR ((genbank_status)::text = 'htgs4'::text) OR ((genbank_status)::text = ''::text) OR (genbank_status IS NULL))) |
| bac_status_log | chk_bac_status_log_status | ((((status)::text = 'not_sequenced'::text) OR ((status)::text = 'in_progress'::text) OR ((status)::text = 'complete'::text) OR ((status)::text = ''::text) OR (status IS NULL))) |
| forum_topic | person_id_check | ((person_id IS NOT NULL)) |
| sp_login_old | chk_sp_login_user_type | ((((user_type)::text = 'user'::text) OR ((user_type)::text = 'submitter'::text) OR ((user_type)::text = 'curator'::text) OR ((user_type)::text = 'sequencer'::text) OR ((user_type)::text = ''::text) OR (user_type IS NULL))) |
| sp_organization | sp_organization_shortname_check | (((shortname IS NULL) OR (lower((shortname)::text) = (shortname)::text))) |
| sp_person | first_name_check | ((first_name IS NOT NULL)) |
| sp_person | if_disabled_no_cookie_for_you | ((((disabled IS NOT NULL) AND (cookie_string IS NULL)) OR (disabled IS NULL))) |
| sp_person | last_name_check | ((last_name IS NOT NULL)) |
Processing...