Table zfindb.public.zmap_pub_pan_mark 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  √  null
zdb_active_data.zactvd_zdb_id zmap_pub_pan_mark_zdb_id_foreign_key_odc C
abbrevp text 2147483647
mtype text 2147483647
lg_location numeric 8,2
metric text 2147483647
map_metric.mapmetric_code zmap_pub_pan_mark_metric_foreign_key R
target_abbrev text 2147483647
mghframework bool 1
target_id text 2147483647
panel_id text 2147483647
mname text 2147483647
abbrev text 2147483647
entry_date timestamp 26,3
panel_abbrev text 2147483647  √  null
zmap_chromosome text 2147483647
chromosome.chrom_name zmap_pub_pan_mark_chromosome_foreign_key R

Table contained 35,840 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
metric Performance Asc zmap_pub_pan_mark_metric_index
mname Performance Asc zmap_pub_pan_mark_mname_index
mtype Performance Asc zmap_pub_pan_mark_mtype_index
zmap_chromosome Performance Asc zmap_pub_pan_mark_or_lg_index
panel_abbrev Performance Asc zmap_pub_pan_mark_panel_abbrev_index
zdb_id Performance Asc zmap_pub_pan_mark_zdb_id_foreign_key_index

Close relationships  within of separation: