Table zfindb.public.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 bigserial 19  √  nextval('pub_tracking_history_pth_pk_id_seq'::regclass)
pth_pub_zdb_id text 2147483647
publication.zdb_id pth_pub_fk_odc C
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 text 2147483647
person.zdb_id pth_status_set_by_fk R
pth_claimed_by text 2147483647  √  null
person.zdb_id pth_claimed_by_foreign_key R
pth_status_insert_date timestamp 29,6 now()
pth_status_is_current bool 1 false
pth_status_made_non_current_date timestamp 29,6  √  null
pth_days_in_status int4 10  √  null

Table contained 93,836 rows at Mon Sep 03 04:09 PDT 2018

Indexes:
Column(s) Type Sort Constraint Name
pth_pk_id Primary key Asc pth_primary_key
pth_claimed_by Performance Asc pth_claimed_by_fk_index
pth_location_id Performance Asc pth_location_fk_index
pth_pub_zdb_id Performance Asc pth_pub_zdb_id_fk_index
pth_status_id Performance Asc pth_status_fk_index
pth_status_set_by Performance Asc pth_status_set_by_fk_index

Close relationships  within of separation: