Constraints

46 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
clone_validation_log_sp_person_id_fkey
clone_validation_log.sp_person_id
sp_person.sp_person_id
Restrict delete
clone_validation_log_clone_id_fkey
clone_validation_log.clone_id
clone.clone_id
Restrict delete
sp_project_il_mapping_clone_log_sp_project_id_fkey
sp_project_il_mapping_clone_log.sp_project_id
sp_project.sp_project_id
Restrict delete
sp_project_il_mapping_clone_log_clone_id_fkey
sp_project_il_mapping_clone_log.clone_id
clone.clone_id
Restrict delete
sp_project_il_mapping_clone_log_sp_person_id_fkey
sp_project_il_mapping_clone_log.sp_person_id
sp_person.sp_person_id
Restrict delete
sp_group_member_sp_group_id_fkey
sp_group_member.sp_group_id
sp_group.sp_group_id
Cascade on delete
sp_group_member_sp_person_id_fkey
sp_group_member.sp_person_id
sp_person.sp_person_id
Cascade on delete
sp_person_roles_sp_person_id_fkey
sp_person_roles.sp_person_id
sp_person.sp_person_id
Cascade on delete
sp_person_roles_sp_role_id_fkey
sp_person_roles.sp_role_id
sp_roles.sp_role_id
Cascade on delete
person_id_fk
bac_status_log.person_id
sp_person.sp_person_id
Restrict delete
person_id_fk
forum_topic.person_id
sp_person.sp_person_id
Restrict delete
forum_topic_id_fk
forum_post.forum_topic_id
forum_topic.forum_topic_id
Restrict delete
person_id_fk
forum_post.person_id
sp_person.sp_person_id
Restrict delete
sp_order_order_to_id_fkey
sp_order.order_to_id
sp_person.sp_person_id
Restrict delete
sp_order_order_from_id_fkey
sp_order.order_from_id
sp_person.sp_person_id
Restrict delete
clone_verification_log_clone_id_fkey
clone_verification_log.clone_id
clone.clone_id
Restrict delete
clone_verification_log_sp_person_id_fkey
clone_verification_log.sp_person_id
sp_person.sp_person_id
Restrict delete
user_map_sp_person_id_fkey
user_map.sp_person_id
sp_person.sp_person_id
Restrict delete
user_map_parent2_accession_id_fkey
user_map.parent2_accession_id
accession.accession_id
Restrict delete
user_map_parent1_accession_id_fkey
user_map.parent1_accession_id
accession.accession_id
Restrict delete
sp_token_sp_person_id_fkey
sp_token.sp_person_id
sp_person.sp_person_id
Restrict delete
person_id_fk
bac_status.person_id
sp_person.sp_person_id
Restrict delete
sp_dataset_sp_person_id_fkey
sp_dataset.sp_person_id
sp_person.sp_person_id
Restrict delete
listprop_list_id_fkey
listprop.list_id
list.list_id
Restrict delete
listprop_type_id_fkey
listprop.type_id
cvterm.cvterm_id
Restrict delete
sp_clone_il_mapping_segment_log_clone_id_fkey
sp_clone_il_mapping_segment_log.clone_id
clone.clone_id
Restrict delete
sp_clone_il_mapping_segment_log_sp_person_id_fkey
sp_clone_il_mapping_segment_log.sp_person_id
sp_person.sp_person_id
Restrict delete
sp_clone_il_mapping_segment_log_individual_id_fkey
sp_clone_il_mapping_segment_log.individual_id
individual.individual_id
Restrict delete
clone_il_mapping_bin_log_clone_id_fkey
clone_il_mapping_bin_log.clone_id
clone.clone_id
Restrict delete
clone_il_mapping_bin_log_genotype_region_id_fkey
clone_il_mapping_bin_log.genotype_region_id
genotype_region.genotype_region_id
Restrict delete
clone_il_mapping_bin_log_sp_person_id_fkey
clone_il_mapping_bin_log.sp_person_id
sp_person.sp_person_id
Restrict delete
sp_orderprop_sp_order_id_fkey
sp_orderprop.sp_order_id
sp_order.sp_order_id
Restrict delete
sp_orderprop_type_id_fkey
sp_orderprop.type_id
cvterm.cvterm_id
Restrict delete
person_id_fk
sp_papers.person_id
sp_person.sp_person_id
Restrict delete
list_item_list_id_fkey
list_item.list_id
list.list_id
Cascade on delete
person_id_fk
sp_organization_person.sp_person_id
sp_person.sp_person_id
Restrict delete
person_id_fk
sp_person_organisms.sp_person_id
sp_person.sp_person_id
Restrict delete
user_map_data_marker_id_fkey
user_map_data.marker_id
marker.marker_id
Restrict delete
user_map_data_user_map_id_fkey
user_map_data.user_map_id
user_map.user_map_id
Restrict delete
user_map_data_sp_person_id_fkey
user_map_data.sp_person_id
sp_person.sp_person_id
Restrict delete
list_dbxref_list_id_fkey
list_dbxref.list_id
list.list_id
Cascade on delete
list_dbxref_dbxref_id_fkey
list_dbxref.dbxref_id
dbxref.dbxref_id
Cascade on delete
sp_project_person_sp_project_id_fkey
sp_project_person.sp_project_id
sp_project.sp_project_id
Restrict delete
person_id_fk
sp_project_person.sp_person_id
sp_person.sp_person_id
Restrict delete
list_owner_fkey
list.owner
sp_person.sp_person_id
Cascade on delete
list_type_id_fkey
list.type_id
cvterm.cvterm_id
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)))