Table zfindb.informix.journal 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
jrnl_zdb_id varchar 50
publication.pub_jrnl_zdb_id pub_journal_foreign_key R
zdb_active_source.zactvs_zdb_id journal_zdb_active_source_foreign_key C
jrnl_name varchar 255
jrnl_abbrev varchar 255  √  null
jrnl_is_nice boolean 1  √  null
jrnl_publisher varchar 100  √  null
jrnl_name_lower varchar 255
jrnl_abbrev_lower varchar 255
jrnl_print_issn varchar 100  √  null
jrnl_online_issn varchar 100  √  null
jrnl_nlmid varchar 100  √  null
jrnl_medabbrev varchar 255  √  null
jrnl_isoabbrev varchar 255  √  null

Table contained 2,448 rows at Tue Dec 20 09:53 PST 2016

Indexes:
Column(s) Type Sort Constraint Name
jrnl_is_nice + jrnl_name Must be unique Asc/Asc journal_alternate_key_index
jrnl_is_nice + jrnl_zdb_id Must be unique Asc/Asc journal_primary_key_index
jrnl_is_nice + jrnl_abbrev_lower Must be unique Asc/Asc jrnl_abbrev_lower_index
jrnl_is_nice + jrnl_name_lower Must be unique Asc/Asc jrnl_name_lower_index

Close relationships  within of separation: