SchemaSpy Analysis of cxgn.sgn_people - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Wed May 20 02:02 EDT 2009
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
cxgn.sgn_people contains 179 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
abstract user_map text 2147483647  √  null
address sp_organization text 2147483647  √  null
address sp_person text 2147483647  √  null
author_list sp_papers text 2147483647  √  null
bac_id bac_status int8 19  √  null
bac_id bac_status_log int8 19  √  null
bac_status_id bac_status bigserial 19  √  nextval('bac_status_bac_status_id_seq'::regclass)
bac_status_log_id bac_status_log bigserial 19  √  nextval('bac_status_log_bac_status_log_id_seq'::regclass)
censor sp_person int8 19  √  0
chromosome clone_il_mapping_bin_log int4 10  √  null
clone_id clone_il_mapping_bin_log int4 10  √  null
clone_id clone_validation_log int4 10  √  null
clone_id clone_verification_log int4 10  √  null
clone_id sp_clone_il_mapping_segment_log int4 10  √  null
clone_id sp_project_il_mapping_clone_log int4 10  √  null
clone_validation_log_id clone_validation_log serial 10  √  nextval('clone_validation_log_clone_validation_log_id_seq'::regclass)
clone_verification_log_id clone_verification_log serial 10  √  nextval('clone_verification_log_clone_verification_log_id_seq'::regclass)
confidence user_map_data varchar 20  √  null
confirm_code sp_login_old varchar 20  √  null
confirm_code sp_person varchar 20  √  null
contact_email sp_organization varchar 255  √  null
contact_email sp_person varchar 255  √  null
contact_update sp_person date 13  √  null
content list_item text 2147483647  √  null
cookie_string sp_person text 2147483647  √  null
country sp_organization varchar 255  √  null
country sp_person varchar 255  √  null
create_date user_map timestamptz 35,6  √  null
create_date user_map_data timestamptz 35,6  √  null
created clone_il_mapping_bin_log timestamp 29,6  √  now()
created clone_validation_log timestamp 29,6  √  now()
created clone_verification_log timestamp 29,6  √  now()
created sp_clone_il_mapping_segment_log timestamp 29,6  √  now()
created sp_project_il_mapping_clone_log timestamp 29,6  √  now()
department sp_organization varchar 255  √  null
description list text 2147483647  √  null
description sp_group text 2147483647  √  null
description sp_organization text 2147483647  √  null
description sp_project text 2147483647  √  null
developer_settings sp_person varchar 4096  √  null
disabled sp_login_old int8 19  √  null
disabled sp_person varchar 20  √  null
fax sp_organization varchar 40  √  null
fax sp_person varchar 40  √  null
first_name sp_person varchar 63  √  null
formatted_interests sp_person text 2147483647  √  null
forum_post_id forum_post serial 10  √  nextval('forum_post_forum_post_id_seq'::regclass)
forum_topic_id forum_post int4 10  √  null
forum_topic.forum_topic_id forum_topic_id_fk
forum_topic_id forum_topic serial 10  √  nextval('forum_topic_forum_topic_id_seq'::regclass)
forum_post.forum_topic_id forum_topic_id_fk
genbank_status bac_status varchar 5  √  null
genbank_status bac_status_log varchar 5  √  null
genotype_region_id clone_il_mapping_bin_log int4 10  √  null
individual_id sp_clone_il_mapping_segment_log int4 10  √  null
is_current clone_il_mapping_bin_log bool 1  √  true
is_current clone_validation_log bool 1  √  true
is_current clone_verification_log bool 1  √  true
is_current sp_clone_il_mapping_segment_log bool 1  √  true
is_current sp_project_il_mapping_clone_log bool 1  √  true
is_hotlist list bool 1  √  false
is_public user_map bool 1  √  null
journal sp_papers text 2147483647  √  null
keywords sp_papers text 2147483647  √  null
last_access_time sp_person timestamp 29,6  √  now()
last_name sp_person varchar 63  √  null
linkage_group user_map_data varchar 20  √  null
list_id list bigserial 19  √  nextval('list_list_id_seq'::regclass)
list_item.list_id list_item_list_id_fkey
list_id list_item int4 10  √  null
list.list_id list_item_list_id_fkey
list_item_id list_item bigserial 19  √  nextval('list_item_list_item_id_seq'::regclass)
long_name user_map varchar 100  √  null
marker_id user_map_data int8 19  √  null
marker_name user_map_data varchar 50  √  null
modified_date user_map timestamptz 35,6  √  null
modified_date user_map_data timestamptz 35,6  √  null
name list varchar 128  √  null
name sp_group varchar 2147483647
name sp_organization varchar 255
name sp_project varchar 80  √  null
notes clone_il_mapping_bin_log text 2147483647  √  null
obsolete user_map bool 1  √  null
obsolete user_map_data bool 1  √  null
organism_id sp_organisms serial 10  √  nextval('sp_organisms_organism_id_seq'::regclass)
organism_id sp_person_organisms int4 10 0
organism_name sp_organisms varchar 255  √  null
organization sp_person varchar 255  √  null
owner list int4 10  √  null
sp_person.sp_person_id list_owner_fkey
page_object_id forum_topic int8 19  √  null
page_type forum_topic varchar 10  √  null
pages sp_papers varchar 16  √  null
parent1 user_map varchar 100  √  null
parent1_accession_id user_map int8 19  √  null
parent2 user_map varchar 100  √  null
parent2_accession_id user_map int8 19  √  null
parent_post_id forum_post int8 19  √  null
parent_topic forum_topic int8 19  √  null
password sp_login_old varchar 255  √  null
password sp_person varchar 255  √  null
pending_email sp_login_old varchar 255  √  null
pending_email sp_person varchar 255  √  null
person_id bac_status int8 19  √  null
sp_person.sp_person_id person_id_fk
person_id bac_status_log int8 19  √  null
sp_person.sp_person_id person_id_fk
person_id forum_post int8 19  √  null
sp_person.sp_person_id person_id_fk
person_id forum_topic int8 19  √  null
sp_person.sp_person_id person_id_fk
person_id sp_papers int4 10 0
sp_person.sp_person_id person_id_fk
phone_number sp_organization varchar 40  √  null
phone_number sp_person varchar 40  √  null
position user_map_data numeric 20,4  √  null
post_text forum_post text 2147483647  √  null
post_time forum_post timestamp 22 ('now'::text)::timestamp(6) with time zone
private_email sp_login_old varchar 255  √  null
private_email sp_person varchar 255  √  null
protocol user_map_data varchar 50  √  null
research_interests sp_person text 2147483647  √  null
research_keywords sp_person text 2147483647  √  null
research_update sp_person date 13  √  null
salutation sp_person varchar 8  √  null
sent_by list int4 10  √  null
short_name user_map varchar 40  √  null
shortname sp_organization varchar 20
sort_order forum_topic varchar 10  √  null
sp_clone_il_mapping_bin_log_id clone_il_mapping_bin_log serial 10  √  nextval('clone_il_mapping_bin_log_sp_clone_il_mapping_bin_log_id_seq'::regclass)
sp_clone_il_mapping_segment_log_id sp_clone_il_mapping_segment_log serial 10  √  nextval('sp_clone_il_mapping_segment_l_sp_clone_il_mapping_segment_l_seq'::regclass)
sp_group_id sp_group serial 10  √  nextval('sp_group_sp_group_id_seq'::regclass)
sp_group_member.sp_group_id sp_group_member_sp_group_id_fkey
sp_group_id sp_group_member int8 19  √  null
sp_group.sp_group_id sp_group_member_sp_group_id_fkey
sp_login_id sp_login_old serial 10  √  nextval('sp_login_old_sp_login_id_seq'::regclass)
sp_login_id sp_person int8 19  √  null
sp_organization_id sp_organization serial 10  √  nextval('sp_organization_sp_organization_id_seq'::regclass)
sp_organization_id sp_organization_person int8 19  √  null
sp_organization_id sp_project_organization int8 19  √  null
sp_organization_person_id sp_organization_person serial 10  √  nextval('sp_organization_person_sp_organization_person_id_seq'::regclass)
sp_paper_id sp_papers serial 10  √  nextval('sp_papers_sp_paper_id_seq'::regclass)
sp_person_id clone_il_mapping_bin_log int4 10  √  null
sp_person.sp_person_id clone_il_mapping_bin_log_sp_person_id_fkey
sp_person_id clone_validation_log int4 10  √  null
sp_person.sp_person_id clone_validation_log_sp_person_id_fkey
sp_person_id clone_verification_log int4 10  √  null
sp_person.sp_person_id clone_verification_log_sp_person_id_fkey
sp_person_id sp_clone_il_mapping_segment_log int4 10  √  null
sp_person.sp_person_id sp_clone_il_mapping_segment_log_sp_person_id_fkey
sp_person_id sp_group_member int8 19  √  null
sp_person.sp_person_id sp_group_member_sp_person_id_fkey
sp_person_id sp_organization_person int8 19  √  null
sp_person.sp_person_id person_id_fk
sp_person_id sp_person 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
sp_person_id sp_person_organisms int8 19  √  null
sp_person.sp_person_id person_id_fk
sp_person_id sp_project_il_mapping_clone_log int4 10  √  null
sp_person.sp_person_id sp_project_il_mapping_clone_log_sp_person_id_fkey
sp_person_id sp_project_person int8 19  √  null
sp_person.sp_person_id person_id_fk
sp_person_id user_map int8 19  √  null
sp_person.sp_person_id user_map_sp_person_id_fkey
sp_person_id user_map_data int8 19  √  null
sp_person.sp_person_id user_map_data_sp_person_id_fkey
sp_person_organisms_id sp_person_organisms serial 10  √  nextval('sp_person_organisms_sp_person_organisms_id_seq'::regclass)
sp_project_id sp_project serial 10  √  nextval('sp_project_sp_project_id_seq'::regclass)
sp_project_il_mapping_clone_log.sp_project_id sp_project_il_mapping_clone_log_sp_project_id_fkey
sp_project_person.sp_project_id sp_project_person_sp_project_id_fkey
sp_project_id sp_project_il_mapping_clone_log int4 10  √  null
sp_project.sp_project_id sp_project_il_mapping_clone_log_sp_project_id_fkey
sp_project_id sp_project_organization int8 19  √  null
sp_project_id sp_project_person int8 19  √  null
sp_project.sp_project_id sp_project_person_sp_project_id_fkey
sp_project_il_mapping_clone_log_id sp_project_il_mapping_clone_log serial 10  √  nextval('sp_project_il_mapping_clone_l_sp_project_il_mapping_clone_l_seq'::regclass)
sp_project_organization_id sp_project_organization serial 10  √  nextval('sp_project_organization_sp_project_organization_id_seq'::regclass)
sp_project_person_id sp_project_person serial 10  √  nextval('sp_project_person_sp_project_person_id_seq'::regclass)
status bac_status varchar 13  √  null
status bac_status_log varchar 13  √  null
status sp_group_member varchar 2147483647 'active'::character varying
subject forum_post varchar 255  √  null
timestamp bac_status timestamp 29,6 ('now'::text)::timestamp(6) with time zone
timestamp bac_status_log timestamp 29,6 ('now'::text)::timestamp(6) with time zone
title sp_papers text 2147483647  √  null
topic_class forum_topic varchar 255  √  null
topic_description forum_topic text 2147483647  √  null
topic_name forum_topic varchar 255  √  null
type sp_project_person varchar 6  √  null
unit sp_organization varchar 255  √  null
upload_account_name sp_organization varchar 40  √  null
user_format sp_person varchar 8  √  null
user_map_data_id user_map_data serial 10  √  nextval('user_map_data_user_map_data_id_seq'::regclass)
user_map_id user_map serial 10  √  nextval('user_map_user_map_id_seq'::regclass)
user_map_data.user_map_id user_map_data_user_map_id_fkey
user_map_id user_map_data int8 19  √  null
user_map.user_map_id user_map_data_user_map_id_fkey
user_prefs sp_person varchar 4096  √  null
user_type sp_login_old varchar 9  √  'user'::character varying
user_type sp_person varchar 20  √  'user'::character varying
username sp_login_old varchar 255  √  null
username sp_person varchar 255  √  null
val_bac_ends clone_validation_log bool 1 false
val_overgo clone_validation_log bool 1 false
ver_bac_end clone_verification_log bool 1 false
ver_int_read clone_verification_log bool 1 false
volume sp_papers int8 19  √  null
webpage sp_organization varchar 255  √  null
webpage sp_person varchar 255  √  null