Table zfindb.public.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 text 2147483647  √  null
zdb_id text 2147483647
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
feature_community_contribution.fcc_added_by fcc_person_fk_odc C
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.pub_indexed_by pub_indexer_foreign_key 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
publication_processing_checklist.ppc_person_zdb_id ppc_person_zdb_id_fk R
zdb_submitters.zdb_id zdb_submitters_zdb_id_foreign_key C
zebrashare_data_edit_permission.zdep_person_zdb_id zdep_person_fk C
zebrashare_submission_metadata.zsm_submitter_zdb_id zem_submitter_fk C
zdb_active_source.zactvs_zdb_id person_zdb_id_foreign_key C
nonzf_pubs text 2147483647  √  null
pers_bio text 2147483647  √  null
nicknames text 2147483647  √  null
full_name text 2147483647
url text 2147483647  √  null
email text 2147483647  √  null
fax text 2147483647  √  null
phone text 2147483647  √  null
address text 2147483647  √  null
name text 2147483647  √  null
entry_time timestamp 29,6  √  now()
on_dist_list bool 1  √  null
first_name text 2147483647
last_name text 2147483647
orcid_id text 2147483647  √  null
pers_is_deceased bool 1 false
person_country text 2147483647  √  null
image text 2147483647  √  null
pers_is_hidden bool 1 false

Table contained 9,587 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
zdb_id Primary key Asc person_primary_key  
email Must be unique Asc email_index This unique column is also nullable

Close relationships  within of separation: