sp_person

164 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sp_person_id serial 10 √ nextval('sgn_people.sp_person_sp_person_id_seq'::regclass)
annotation.person_id person_id_fk R
comment.person_id person_id_fk R
comp_analysis.person_id person_id_fk R
feature_set.person_id person_id_fk R
seq.person_id person_id_fk R
bs_sample.contact_id bs_sample_contact_id_order_fkey R
ge_experiment.contact_id ge_experiment_contact_id_fkey R
ge_platform.contact_id ge_platform_contact_id_fkey R
experiment_image.sp_person_id experiment_image_sp_person_id_fkey R
experiment_tag.sp_person_id experiment_tag_sp_person_id_fkey R
attribution_to.person_id person_id_fk R
md_image.sp_person_id md_image_sp_person_id_fkey R
md_image_cvterm.sp_person_id md_image_cvterm_sp_person_id_fkey R
md_image_organism.sp_person_id md_image_organism_sp_person_id_fkey R
md_metadata.create_person_id md_metadata_create_person_id_fkey R
md_metadata.modified_person_id md_metadata_modified_person_id_fkey R
md_tag.sp_person_id md_tag_sp_person_id_fkey R
md_tag_image.sp_person_id md_tag_image_sp_person_id_fkey R
allele.sp_person_id allele_sp_person_id_fkey R
allele.updated_by allele_updated_by_fkey R
allele_alias.sp_person_id allele_alias_sp_person_id_fkey R
allele_dbxref.sp_person_id allele_dbxref_sp_person_id_fkey R
allele_history.sp_person_id allele_history_sp_person_id_fkey R
allele_history.updated_by allele_history_updated_by_fkey R
genotype_experiment.sp_person_id genotype_experiment_sp_person_id_fkey R
genotype_region.sp_person_id genotype_region_sp_person_id_fkey R
germplasm.sp_person_id germplasm_sp_person_id_fkey R
individual.sp_person_id individual_sp_person_id_fkey R
individual.updated_by individual_updated_by_fkey R
individual_alias.sp_person_id individual_alias_sp_person_id_fkey R
individual_allele.sp_person_id individual_allele_sp_person_id_fkey R
individual_dbxref.sp_person_id individual_dbxref_sp_person_id_fkey R
individual_dbxref_evidence.sp_person_id individual_dbxref_evidence_sp_person_id_fkey R
individual_dbxref_evidence.updated_by individual_dbxref_evidence_updated_by_fkey R
individual_dbxref_evidence_history.sp_person_id individual_dbxref_evidence_history_sp_person_id_fkey R
individual_dbxref_evidence_history.updated_by individual_dbxref_evidence_history_updated_by_fkey R
individual_history.sp_person_id individual_history_sp_person_id_fkey R
individual_history.updated_by individual_history_updated_by_fkey R
individual_image.sp_person_id individual_image_sp_person_id_fkey R
individual_locus.sp_person_id individual_locus_sp_person_id_fkey R
is_public.owner_id is_public_owner_id_fkey R
locus.sp_person_id locus_sp_person_id_fkey R
locus.updated_by locus_updated_by_fkey R
locus2locus.sp_person_id locus2locus_sp_person_id_fkey R
locus_alias.sp_person_id locus_alias_sp_person_id_fkey R
locus_dbxref.sp_person_id locus_dbxref_sp_person_id_fkey R
locus_dbxref_evidence.sp_person_id locus_dbxref_evidence_sp_person_id_fkey R
locus_dbxref_evidence.updated_by locus_dbxref_evidence_updated_by_fkey R
locus_dbxref_evidence_history.sp_person_id locus_dbxref_evidence_history_sp_person_id_fkey R
locus_dbxref_evidence_history.updated_by locus_dbxref_evidence_history_updated_by_fkey R
locus_history.sp_person_id locus_history_sp_person_id_fkey R
locus_history.updated_by locus_history_updated_by_fkey R
locus_image.sp_person_id locus_image_sp_person_id_fkey R
locus_marker.sp_person_id locus_marker_sp_person_id_fkey R
locus_owner.granted_by locus_owner_granted_by_fkey R
locus_owner.sp_person_id locus_owner_sp_person_id_fkey R
locus_registry.sp_person_id locus_registry_sp_person_id_fkey R
locus_unigene.sp_person_id locus_unigene_sp_person_id_fkey R
locusgroup.sp_person_id locusgroup_sp_person_id_fkey R
locusgroup_member.sp_person_id locusgroup_member_sp_person_id_fkey R
phenome_genotype.sp_person_id genotype_sp_person_id_fkey R
polymorphic_fragment.sp_person_id polymorphic_fragment_sp_person_id_fkey R
population.person_id population_person_id_fkey R
population.sp_person_id population_sp_person_id_fkey R
population_dbxref.sp_person_id population_dbxref_sp_person_id_fkey N
project_owner.sp_person_id project_owner_sp_person_id_fkey R
pub_curator.assigned_to pub_curator_assigned_to_fkey R
pub_curator.curated_by pub_curator_curated_by_fkey R
pub_curator.sp_person_id pub_curator_sp_person_id_fkey R
registry.sp_person_id registry_sp_person_id_fkey R
registry.updated_by registry_updated_by_fkey R
stock_owner.sp_person_id stock_owner_sp_person_id_fkey R
user_trait.sp_person_id user_trait_sp_person_id_fkey R
manual_associations.sp_person_id manual_associations_sp_person_id_fkey1 R
blastwatch_queries.sp_person_id blastwatch_queries_sp_person_id_fkey C
bug.created_by bug_created_by_fkey R
bug.sp_person_id bug_sp_person_id_fkey R
bug.updated_by bug_updated_by_fkey R
phenotype.sp_person_id phenotype_sp_person_id_fkey N
facility.sp_person_id foriegn R
library.sp_person_id library_sp_person_id_fkey R
manual_annotations.author_id author_id_fk R
metadata.create_person_id metadata_create_person_id_fkey R
metadata.modified_person_id metadata_modified_person_id_fkey R
submit_user.sp_person_id foriegn R
bac_status.person_id person_id_fk R
bac_status_log.person_id person_id_fk R
clone_il_mapping_bin_log.sp_person_id clone_il_mapping_bin_log_sp_person_id_fkey R
clone_validation_log.sp_person_id clone_validation_log_sp_person_id_fkey R
clone_verification_log.sp_person_id clone_verification_log_sp_person_id_fkey R
forum_post.person_id person_id_fk R
forum_topic.person_id person_id_fk R
list.owner list_owner_fkey C
sp_clone_il_mapping_segment_log.sp_person_id sp_clone_il_mapping_segment_log_sp_person_id_fkey R
sp_dataset.sp_person_id sp_dataset_sp_person_id_fkey R
sp_group_member.sp_person_id sp_group_member_sp_person_id_fkey C
sp_order.order_from_id sp_order_order_from_id_fkey R
sp_order.order_to_id sp_order_order_to_id_fkey R
sp_organization_person.sp_person_id person_id_fk R
sp_papers.person_id person_id_fk R
sp_person_organisms.sp_person_id person_id_fk R
sp_person_roles.sp_person_id sp_person_roles_sp_person_id_fkey C
sp_project_il_mapping_clone_log.sp_person_id sp_project_il_mapping_clone_log_sp_person_id_fkey R
sp_project_person.sp_person_id person_id_fk R
sp_token.sp_person_id sp_token_sp_person_id_fkey R
user_map.sp_person_id user_map_sp_person_id_fkey R
user_map_data.sp_person_id user_map_data_sp_person_id_fkey R
facility.sp_person_id foriegn R
library.sp_person_id foriegn R
submit_user.sp_person_id foriegn R
censor int8 19 √ 0
salutation varchar 8 √ null
last_name varchar 63 √ null
first_name varchar 63 √ null
organization varchar 255 √ null
address text 2147483647 √ null
country varchar 255 √ null
phone_number varchar 40 √ null
fax varchar 40 √ null
contact_email varchar 255 √ null
webpage varchar 255 √ null
research_keywords text 2147483647 √ null
user_format varchar 8 √ null
research_interests text 2147483647 √ null
formatted_interests text 2147483647 √ null
contact_update date 13 √ null
research_update date 13 √ null
sp_login_id int8 19 √ null
username varchar 255 √ null
private_email varchar 255 √ null
pending_email varchar 255 √ null
password varchar 255 √ null
confirm_code varchar 20 √ null
disabled varchar 20 √ null
user_type varchar 20 √ 'user'::character varying
cookie_string text 2147483647 √ null
last_access_time timestamp 29,6 √ now()
user_prefs varchar 4096 √ null
developer_settings varchar 4096 √ null

Indexes

Constraint Name Type Sort Column(s)
sp_person_pkey Primary key Asc sp_person_id
cookie_string_unique Must be unique Asc cookie_string
cookie_unique Must be unique Asc cookie_string
country_idx Performance Asc country
name_idx Performance Asc/Asc last_name + first_name
organization_idx Performance Asc organization
sp_person_username_key Must be unique Asc username

Check Constraints

Constraint Name Constraint
first_name_check ((first_name IS NOT NULL))
last_name_check ((last_name IS NOT NULL))
if_disabled_no_cookie_for_you ((((disabled IS NOT NULL) AND (cookie_string IS NULL)) OR (disabled IS NULL)))

Relationships

Close relationships within degrees of separation