Table cxgn.sgn_people.sp_person

Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
sp_person_id serial 10  √  nextval('sp_person_sp_person_id_seq'::regclass)
bac_status.person_id person_id_fk
bac_status_log.person_id person_id_fk
clone_il_mapping_bin_log.sp_person_id clone_il_mapping_bin_log_sp_person_id_fkey
clone_validation_log.sp_person_id clone_validation_log_sp_person_id_fkey
clone_verification_log.sp_person_id clone_verification_log_sp_person_id_fkey
forum_post.person_id person_id_fk
forum_topic.person_id person_id_fk
list.owner list_owner_fkey
sp_clone_il_mapping_segment_log.sp_person_id sp_clone_il_mapping_segment_log_sp_person_id_fkey
sp_group_member.sp_person_id sp_group_member_sp_person_id_fkey
sp_organization_person.sp_person_id person_id_fk
sp_papers.person_id person_id_fk
sp_person_organisms.sp_person_id person_id_fk
sp_project_il_mapping_clone_log.sp_person_id sp_project_il_mapping_clone_log_sp_person_id_fkey
sp_project_person.sp_person_id person_id_fk
user_map.sp_person_id user_map_sp_person_id_fkey
user_map_data.sp_person_id user_map_data_sp_person_id_fkey
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

Table contained 1,027 rows at Wed May 20 02:02 EDT 2009

Indexes:
Column(s) Type Sort Constraint Name Anomalies
sp_person_id Primary key Asc sp_person_pkey  
cookie_string Must be unique Asc cookie_string_unique This unique column is also nullable
cookie_string Must be unique Asc cookie_unique This unique column is also nullable
country Performance Asc country_idx  
last_name + first_name Performance Asc/Asc name_idx  
organization Performance Asc organization_idx  
username Must be unique Asc sp_person_username_key This unique column is also nullable

Close relationships  within one two degrees of separation :