Table zfindb.public.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 text 2147483647
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 text 2147483647
jrnl_abbrev text 2147483647  √  null
jrnl_is_nice bool 1  √  null
jrnl_publisher text 2147483647  √  null
jrnl_name_lower text 2147483647
jrnl_abbrev_lower text 2147483647
jrnl_print_issn text 2147483647  √  null
jrnl_online_issn text 2147483647  √  null
jrnl_nlmid text 2147483647  √  null
jrnl_medabbrev text 2147483647  √  null
jrnl_isoabbrev text 2147483647  √  null

Table contained 2,938 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
jrnl_zdb_id Primary key Asc journal_primary_key
jrnl_name Must be unique Asc journal_alternate_key_index
jrnl_abbrev_lower Must be unique Asc jrnl_abbrev_lower_index
jrnl_name_lower Must be unique Asc jrnl_name_lower_index

Close relationships  within of separation: