Table topp.public.atn_track_qc
This table was initially created to track reprocessing of low quality SSM tracks found on the ATN. It has been expanded to include additional controls for track display on the ATN.

 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
tkey serial 10  √  nextval('atn_track_qc_tkey_seq'::regclass)
eventid int4 10  √  null
toppid int4 10  √  null
ptt int4 10  √  null
priority int4 10  √  null Values from 0 to 3 where 3 is the highest priority for reprocessing.
ssm_tr int4 10  √  null Is the track on the ATN an SSM track?
vis_prob int4 10  √  0 Does the layer control for this track on the ATN function correctly?
rerun int4 10  √  0 Has the track been reprocessed?
atn_replaced int4 10  √  0 Has the track been replaced with a higher quality version?
comments text 2147483647  √  null
contact text 2147483647  √  null
embargountil date 13  √  null
vis_filter int4 10  √  0 A value of 1 removes the track from ATN display.
embargolon float4 8,8  √  null
embargolat float4 8,8  √  null
plot_points int4 10  √  0 Only plot_points on the ATN. For use with cleaned SSM tracks that have gaps.
plot_dashes int4 10  √  0
plot_icon int4 10  √  0

Table contained 6,287 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc atn_track_qc_pkey