Table zfindb.public.publication 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
zdb_id text 2147483647
author_publication.authorpub_pub_zdb_id authorpub_pub_zdb_id_fk R
curation.cur_pub_zdb_id cur_pub_zdb_id_foreign_key C
doi_attempts.doia_pub_zdb_id doi_attempts_pub_zdb_id_foreign_key C
expression_experiment2.xpatex_source_zdb_id expression_experiment2_source_foreign_key C
expression_pattern_infrastructure.xpatinf_pub_zdb_id xpatinf_pub_foreign_key R
htp_dataset_publication.hdp_pub_zdb_id hdp_pub_zdb_id_fk C
int_person_pub.target_id int_person_pub_target_id_foreign_key C
mesh_heading.mh_pub_zdb_id mesh_heading_pub_foreign_key_odc C
ortholog_evidence.oev_pub_zdb_id oevn_pub_zdb_id_foreign_key C
pub_correspondence_received_email.pubcre_pub_zdb_id pub_correspondence_received_email_pub_fk_odc C
pub_correspondence_sent_email.pubcse_pub_zdb_id pubcse_pub_zdb_id_foreign_key_odc C
pub_correspondence_sent_tracker.pubcst_pub_zdb_id pub_correspondence_sent_tracker_pub_zdb_id_fk_odc C
pub_db_xref.pdx_pub_zdb_id pub_db_xref_pub_fk R
pub_tracking_history.pth_pub_zdb_id pth_pub_fk_odc C
publication_contact_tracking.pct_pub_zdb_id pct_pub_zdb_id_foreign_key C
publication_correspondence.pubcorr_pub_zdb_id pubcorr_pub_zdb_id_foreign_key C
publication_file.pf_pub_zdb_id pf_pub_zdb_id_fk_odc C
publication_note.pnote_pub_zdb_id pnote_pub_zdb_id_foreign_key C
publication_processing_checklist.ppc_pub_zdb_id ppc_pub_zdb_id_fk R
pubmed_publication_author.ppa_publication_zdb_id ppa_publication_fk C
run.run_nomen_pub_zdb_id run_nomen_pub_foreign_key_odc C
run.run_relation_pub_zdb_id run_relation_pub_foreign_key_odc C
zebrashare_data_edit_permission.zdep_pub_zdb_id zdep_pub_fk C
zebrashare_submission_metadata.zsm_pub_zdb_id zem_pub_fk C
zdb_active_source.zactvs_zdb_id publication_zdb_id_foreign_key C
authors text 2147483647
pub_date date 13  √  null
title text 2147483647  √  null
keywords text 2147483647  √  null
pub_errata_and_notes text 2147483647  √  null
accession_no int4 10  √  null
status text 2147483647  √  null
owner text 2147483647  √  null
pubmed_authors text 2147483647  √  null
jtype text 2147483647
pub_mini_ref text 2147483647  √  null
pub_arrival_date timestamp 29,6 now()
pub_completion_date timestamp 29,6  √  null
pub_jrnl_zdb_id text 2147483647
journal.jrnl_zdb_id pub_journal_foreign_key R
pub_can_show_images bool 1 false
pub_authors_lower text 2147483647
pub_volume text 2147483647  √  null
pub_pages text 2147483647  √  null
pub_acknowledgment text 2147483647  √  null
pub_doi text 2147483647  √  null
pub_is_indexed bool 1 false
pub_indexed_date timestamp 29,6  √  null
pub_abstract text 2147483647  √  null
pub_last_correspondence_date timestamp 29,6  √  null
pub_indexed_by text 2147483647  √  null
person.zdb_id pub_indexer_foreign_key R
pub_is_curatable bool 1 true
pub_pmc_id text 2147483647  √  null
pub_mid text 2147483647  √  null
pub_goref_id text 2147483647  √  null

Table contained 46,550 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
zdb_id Primary key Asc publication_primary_key
pub_jrnl_zdb_id Performance Asc publication_journal_foreign_key_index

Close relationships  within of separation: