Table topp.wc2.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
deployid text 2147483647  √  null
ptt int4 10  √  null
depthsensor float8 17,17  √  null
instr text 2147483647  √  null
sw text 2147483647  √  null
rtc text 2147483647  √  null
received text 2147483647  √  null
time_offset timestamptz 35,6  √  null
locationquality text 2147483647  √  null
latitude float8 17,17  √  null
longitude float8 17,17  √  null
type text 2147483647  √  null
hauledout int4 10  √  null
brokenthermistor int4 10  √  null
brokenlink bool 1  √  null
transmits int4 10  √  null
battvoltage float8 17,17  √  null
transmitvoltage float8 17,17  √  null
transmitcurrent float8 17,17  √  null
temperature float8 17,17  √  null
depth float8 17,17  √  null
maxdepth float8 17,17  √  null
zerodepthoffset int4 10  √  null
lightlevel bool 1  √  null
nodawndusk bool 1  √  null
releasetype bool 1  √  null
releasetime timestamptz 35,6  √  null
initiallybroken bool 1  √  null
burnminutes bool 1  √  null
releasedepth bool 1  √  null
fastgpspower bool 1  √  null
twicpower bool 1  √  null
powerlimit bool 1  √  null
wetdry int4 10  √  null
minwetdry int4 10  √  null
maxwetdry int4 10  √  null
wetdrythreshold int4 10  √  null
statusword int4 10  √  null
transmitpower bool 1  √  null
resets bool 1  √  null
prereleasetilt bool 1  √  null
prereleasetiltsd bool 1  √  null
prereleasetiltcount bool 1  √  null
xmitqueue int4 10  √  null
fastgpslocnumber int4 10  √  null
fastgpsfailures int4 10  √  null
battdiscon bool 1  √  null
wc_id text 2147483647  √  null

Table contained 1,916 rows at Wed Dec 27 13:28 PST 2017