cxgn_breedbase.sgn

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)))