Table zfindb.public.pub_tracking_status 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
pts_pk_id bigserial 19  √  nextval('pub_tracking_status_pts_pk_id_seq'::regclass)
pub_tracking_history.pth_status_id pth_status_fk R
pts_status text 2147483647  √  null
pts_terminal_status bool 1 true
pts_status_display text 2147483647
pts_status_qualifier text 2147483647  √  null
pts_pipeline_pull_down_order int8 19
pts_hidden_status bool 1 false
pts_definition text 2147483647  √  null

Table contained 21 rows at Wed Sep 15 00:41 PDT 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
pts_pk_id Primary key Asc pts_primary_key  
pts_status + pts_status_qualifier Must be unique Asc/Asc pts_status_alternate_key_index These unique columns are also nullable

Close relationships  within of separation: