46 Foreign Key Constraints
Constraint Name | Child Column | Parent Column | Delete Rule | ||
---|---|---|---|---|---|
clone_validation_log_sp_person_id_fkey |
|
|
Restrict delete | ||
clone_validation_log_clone_id_fkey |
|
|
Restrict delete | ||
sp_project_il_mapping_clone_log_sp_project_id_fkey |
|
|
Restrict 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_group_member_sp_group_id_fkey |
|
|
Cascade on delete | ||
sp_group_member_sp_person_id_fkey |
|
|
Cascade on delete | ||
sp_person_roles_sp_person_id_fkey |
|
|
Cascade on delete | ||
sp_person_roles_sp_role_id_fkey |
|
|
Cascade on delete | ||
person_id_fk |
|
|
Restrict delete | ||
person_id_fk |
|
|
Restrict delete | ||
forum_topic_id_fk |
|
|
Restrict delete | ||
person_id_fk |
|
|
Restrict delete | ||
sp_order_order_to_id_fkey |
|
|
Restrict delete | ||
sp_order_order_from_id_fkey |
|
|
Restrict delete | ||
clone_verification_log_clone_id_fkey |
|
|
Restrict delete | ||
clone_verification_log_sp_person_id_fkey |
|
|
Restrict delete | ||
user_map_sp_person_id_fkey |
|
|
Restrict delete | ||
user_map_parent2_accession_id_fkey |
|
|
Restrict delete | ||
user_map_parent1_accession_id_fkey |
|
|
Restrict delete | ||
sp_token_sp_person_id_fkey |
|
|
Restrict delete | ||
person_id_fk |
|
|
Restrict delete | ||
sp_dataset_sp_person_id_fkey |
|
|
Restrict delete | ||
listprop_list_id_fkey |
|
|
Restrict delete | ||
listprop_type_id_fkey |
|
|
Restrict delete | ||
sp_clone_il_mapping_segment_log_clone_id_fkey |
|
|
Restrict delete | ||
sp_clone_il_mapping_segment_log_sp_person_id_fkey |
|
|
Restrict delete | ||
sp_clone_il_mapping_segment_log_individual_id_fkey |
|
|
Restrict delete | ||
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 | ||
sp_orderprop_sp_order_id_fkey |
|
|
Restrict delete | ||
sp_orderprop_type_id_fkey |
|
|
Restrict delete | ||
person_id_fk |
|
|
Restrict delete | ||
list_item_list_id_fkey |
|
|
Cascade on delete | ||
person_id_fk |
|
|
Restrict delete | ||
person_id_fk |
|
|
Restrict delete | ||
user_map_data_marker_id_fkey |
|
|
Restrict delete | ||
user_map_data_user_map_id_fkey |
|
|
Restrict delete | ||
user_map_data_sp_person_id_fkey |
|
|
Restrict delete | ||
list_dbxref_list_id_fkey |
|
|
Cascade on delete | ||
list_dbxref_dbxref_id_fkey |
|
|
Cascade on delete | ||
sp_project_person_sp_project_id_fkey |
|
|
Restrict delete | ||
person_id_fk |
|
|
Restrict delete | ||
list_owner_fkey |
|
|
Cascade on delete | ||
list_type_id_fkey |
|
|
Restrict delete |
Check Constraints
Table | Constraint Name | Constraint |
---|---|---|
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)) |
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_organization | sp_organization_shortname_check | (((shortname IS NULL) OR (lower((shortname)::text) = (shortname)::text))) |
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))) |
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_project_person | chk_sp_project_person_type | ((((type)::text = 'PI'::text) OR ((type)::text = 'co-PI'::text) OR ((type)::text = 'Member'::text) OR ((type)::text = ''::text) OR (type IS NULL))) |