Table zfindb.informix.paneled_markers 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 varchar 50  √  null
zdb_active_data.zactvd_zdb_id r467_1739 C
abbrev varchar 40  √  null
mtype varchar 10  √  null
or_lg varchar 2  √  null
lg_location decimal 8,2  √  null
metric varchar 5  √  null
target_abbrev varchar 20  √  null
mghframework boolean 1  √  null
target_id varchar 50  √  null
map_name varchar 40  √  null

Table contained 38,522 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
mghframework + mtype Performance Asc/Asc paneled_markers_mtype_index_a2
mghframework + target_abbrev + or_lg + mtype + zdb_id Performance Asc/Asc/Asc/Asc/Asc paneled_markers_target_abbrev_etc_index_a2
mghframework + zdb_id Performance Asc/Asc paneled_markers_zdb_id_index_a2

Close relationships  within of separation: