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_correspondence_received_email.pubcre_correspondence_from_person_zdb_id pub_correspondence_received_email_from_person_fk R
pub_correspondence_recipient.pubcr_recipient_person_zdb_id pub_corresspondence_recipient_person_zdb_id_fk R
pub_correspondence_sent_email.pubcse_sent_by pubcse_sent_by_foreign_key R
pub_correspondence_sent_tracker.pubcst_sent_by pub_correspondence_sent_tracker_sent_by_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 second 19  √  current
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
person_country varchar 10  √  null
image varchar 150  √  null

Table contained 8,148 rows at Thu Jun 22 08:42 PDT 2017

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: