Table zfindb.public.mesh_heading Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
mh_pk_id bigserial 19  √  nextval('mesh_heading_mh_pk_id_seq'::regclass)
mesh_heading_qualifier
mh_pub_zdb_id text 2147483647
publication
mh_mesht_mesh_descriptor_id text 2147483647
mesh_term
mh_descriptor_is_major_topic bool 1 false

Table contained 478,408 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort
mh_pk_id Primary key Asc
mh_mesht_mesh_descriptor_id Performance Asc
mh_pub_zdb_id Performance Asc
mh_pub_zdb_id + mh_mesht_mesh_descriptor_id Must be unique Asc/Asc

Close relationships  within of separation: