Table zfindb.informix.person Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
owner varchar 50  √  null
zdb_id varchar 50
company.contact_person company_contact_person_foreign_key R
company.owner company_owner_foreign_key R
construct.construct_owner_zdb_id construct_owner_zdb_id R
curation.cur_curator_zdb_id cur_curator_zdb_id_foreign_key R
curator_session.cs_person_zdb_id curator_session_person_zdb_id_foreign_key_odc C
data_note.dnote_curator_zdb_id dnote_curator_zdb_id_foreign_key R
image.img_owner_zdb_id img_owner_zdb_id_foreign_key R
int_person_company.source_id int_person_company_source_id_foreign_key C
int_person_lab.source_id int_person_lab_source_id_foreign_key C
int_person_pub.source_id int_person_pub_source_id_foreign_key C
lab.contact_person lab_contact_person_foreign_key R
lab.owner lab_owner_foreign_key R
linkage.lnkg_submitter_zdb_id lnkgs_submitter_zdb_id_foreign_key R
linkage_old.lnkg_submitter_zdb_id lnkg_submitter_zdb_id_foreign_key R
mapped_marker.owner owner_person_zdb_id_foreign_key_odc R
marker.mrkr_owner mrkr_owner_foreign_key R
marker_go_term_evidence.mrkrgoev_contributed_by mrkrgoev_contributed_by_fk R
marker_go_term_evidence.mrkrgoev_modified_by mrkrgoev_modified_by_fk R
panels.owner mappanel_owner_foreign_key R
panels.producer mappanel_producer_foreign_key R
person_author.persauth_connected_by persauth_connected_by_fk R
person_author.persauth_person_zdb_id persauth_person_zdb_id_fk R
pub_tracking_history.pth_claimed_by pth_claimed_by_foreign_key R
pub_tracking_history.pth_status_set_by pth_status_set_by_fk R
publication_contact_tracking.pct_curator_zdb_id pct_curator_zdb_id_foreign_key C
publication_correspondence.pubcorr_curator_zdb_id pubcorr_curator_zdb_id_foreign_key C
publication_note.pnote_curator_zdb_id pnote_curator_zdb_id_foreign_key R
zdb_submitters.zdb_id zdb_submitters_zdb_id_foreign_key C
zdb_active_source.zactvs_zdb_id person_zdb_id_foreign_key C
nonzf_pubs clob 2147483647  √  null
pers_bio lvarchar 12000  √  null
nicknames varchar 200  √  null
full_name varchar 150
snapshot blob 2147483647  √  null
url varchar 150  √  null
email varchar 150  √  null
fax varchar 100  √  null
phone varchar 100  √  null
address lvarchar 450  √  null
name varchar 150  √  null
entry_time datetime year to fraction(3) 23  √  null
on_dist_list boolean 1  √  null
first_name varchar 100
last_name varchar 100
orcid_id varchar 20  √  null
pers_is_deceased boolean 1 f

Table contained 7,727 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
address + nonzf_pubs + on_dist_list + pers_bio + pers_is_deceased + snapshot + zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc person_primary_key_index

Close relationships  within of separation: