Table zfindb.informix.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 varchar 50
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
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 R
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_note.pnote_pub_zdb_id pnote_pub_zdb_id_foreign_key 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
zdb_active_source.zactvs_zdb_id publication_zdb_id_foreign_key C
authors lvarchar 3000
pub_date date 10  √  null
title lvarchar 400  √  null
keywords lvarchar 2200  √  null
pub_errata_and_notes lvarchar 3000  √  null
accession_no int 10  √  null
status varchar 30  √  null
num_auths int 10  √  null
owner varchar 50  √  null
pubmed_authors lvarchar 400  √  null
jtype varchar 20
pub_mini_ref varchar 60  √  null
pub_arrival_date datetime year to day 10 current
pub_completion_date datetime year to day 10  √  null
pub_jrnl_zdb_id varchar 50
journal.jrnl_zdb_id pub_journal_foreign_key R
pub_can_show_images boolean 1 f
pub_authors_lower lvarchar 1500
pub_volume varchar 60  √  null
pub_pages varchar 35  √  null
pub_acknowledgment lvarchar 2048  √  null
pub_doi varchar 70  √  null
pub_is_indexed boolean 1 f
pub_indexed_date datetime year to day 10  √  null
pub_abstract clob 2147483647  √  null
pub_last_sent_email_date datetime year to second 19  √  null

Table contained 30,595 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
authors + keywords + pub_abstract + pub_acknowledgment + pub_authors_lower + pub_can_show_images + pub_errata_and_notes + pub_is_indexed + pubmed_authors + title + pub_jrnl_zdb_id Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc publication_journal_foreign_key_index
authors + keywords + pub_abstract + pub_acknowledgment + pub_authors_lower + pub_can_show_images + pub_errata_and_notes + pub_is_indexed + pubmed_authors + title + zdb_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc publication_primary_key_index

Close relationships  within of separation: