Table zfindb.informix.pub_tracking_history 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
pth_pk_id serial8 19  √ 
pth_pub_zdb_id varchar 50
publication.zdb_id pth_pub_fk R
pth_status_id int8 19
pub_tracking_status.pts_pk_id pth_status_fk R
pth_location_id int8 19  √  null
pub_tracking_location.ptl_pk_id pth_location_fk R
pth_status_set_by varchar 50
person.zdb_id pth_status_set_by_fk R
pth_claimed_by varchar 50  √  null
person.zdb_id pth_claimed_by_foreign_key R
pth_status_insert_date datetime year to second 19 current
pth_status_is_current boolean 1 f
pth_status_made_non_current_date datetime year to second 19  √  null
pth_days_in_status int 10  √  null

Table contained 70,992 rows at Thu Jun 22 08:42 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name
pth_status_is_current + pth_claimed_by Performance Asc/Asc 420_1761
pth_status_is_current + pth_location_id Performance Asc/Asc pth_location_fk_index
pth_status_is_current + pth_pub_zdb_id Performance Asc/Asc pth_pub_zdb_id_fk_index
pth_status_is_current + pth_status_id Performance Asc/Asc pth_status_fk_index
pth_status_is_current + pth_status_set_by Performance Asc/Asc pth_status_set_by_fk_index
pth_status_is_current + pth_pk_id Must be unique Asc/Asc pub_tracking_history_primary_key_index

Close relationships  within of separation: