Table zfindb.public.mapped_marker 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
company.zdb_id Implied Constraint R
marker_id text 2147483647  √  null
zdb_active_data.zactvd_zdb_id mm_marker_id_foreign_key C
refcross_id text 2147483647
zdb_active_data.zactvd_zdb_id mm_refcross_id_foreign_key C
submitter text 2147483647  √  null
lab text 2147483647  √  null
owner text 2147483647  √  null
person.zdb_id owner_person_zdb_id_foreign_key_odc R
comments text 2147483647  √  null
entry_date timestamp 26,3  √  null
scoring_data text 2147483647  √  null
marker_type text 2147483647
marker_types.marker_type Implied Constraint R
framework_t bool 1  √  null
metric text 2147483647  √  null
map_metric.mapmetric_code mapped_marker_metric_foreign_key R
map_name text 2147483647  √  null
mm_chromosome text 2147483647
chromosome.chrom_name mapped_marker_chromosome_foreign_key R
mm_chrom_location numeric 8,2  √  null

Table contained 26,973 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name
zdb_id Primary key Asc mapped_marker_primary_key
mm_chromosome Performance Asc mapped_marker_chromosome_index
marker_id Performance Asc mapped_marker_marker_id_index
marker_type Performance Asc mapped_marker_marker_type_index
metric Performance Asc mapped_marker_metric_index
refcross_id Performance Asc mapped_markers_refcross_id_index
owner Performance Asc owner_person_zdb_id_fk_odc_index

Close relationships  within of separation: