Table topp.deprecated.new_atn_track_qc_row 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
eventid int4 10  √  null
minimal_deploys.eventid Implied Constraint R
tagcode text 2147483647  √  null
tagnumber text 2147483647  √  null
tagdate date 13  √  null
end_date timestamptz 35,6  √  null
tagmodel text 2147483647  √  null
commonname text 2147483647  √  null
genus text 2147483647  √  null
species text 2147483647  √  null
lsdname text 2147483647  √  null
toppid int4 10  √  null
ptt int4 10  √  null
seriesname text 2147483647  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null
deplength text 2147483647  √  null
deplen_type text 2147483647  √  null
tagtype text 2147483647  √  null
reclon float8 17,17  √  null
reclat float8 17,17  √  null
poplon float8 17,17  √  null
poplat float8 17,17  √  null
modpoplon float8 17,17  √  null
modpoplat float8 17,17  √  null
rdateestimated text 2147483647  √  null
recpositionestimated text 2147483647  √  null
fish_recaptured text 2147483647  √  null
reclength text 2147483647  √  null
reclen_type text 2147483647  √  null
geolocated text 2147483647  √  null
ssm_complete text 2147483647  √  null
ssm_version text 2147483647  √  null
findlats_outfile text 2147483647  √  null
wc_id text 2147483647  √  null
owner text 2147483647  √  null
contact text 2147483647  √  null
speciescode int4 10  √  null
priority int4 10  √  null
ssm_tr int4 10  √  null
vis_prob int4 10  √  null
rerun int4 10  √  null
atn_replaced int4 10  √  null
embargountil date 13  √  null
embargolon float4 8,8  √  null
embargolat float4 8,8  √  null
vis_filter int4 10  √  null
plot_points int4 10  √  null

Table contained 0 rows at Wed Dec 27 13:21 PST 2017


Close relationships: