Table topp.public.tblsgspotprogramming
This table contains programming metadata for SPOT satellite tagged fishgroup animals. There are similarities to the other satellite programming tables though it is simpler due to SPOTS having fewer parameters. Typically joins will be made to the sgdepkey field. There are 14 histogram bin fields, b1low to b12high, that define how temperature data will be summarized. All date fields should be converted from type text to date or timestamp.

 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('tblsgspotprogramming_tkey_seq'::regclass)
sgdepkey int4 10 This field should be called eventid. It joins to sgdepkey in tblsharkdeployment as well as any other place eventid works for SPOT tags.
toppid text 2147483647  √  null Same as toppid in deployment table.
tagnumber text 2147483647  √  null Manufacturer serial number of tag.
hardversion text 2147483647  √  null Manufacturer hardware revision number.
tagsoft text 2147483647  √  null The tag firmware/software version number.
argosid int4 10  √  null The Argos PTT number for the tag.
tt text 2147483647  √  null The total number of historical transmissions made by the tag.
progsw text 2147483647  √  null Programming software revision number.
localdate date 13  √  null Local date of programming.
_localtime time 15,6  √  null Local time of programming.
tagdate date 13  √  null Date of programming from the tag.
tagtime time 15,6  √  null
acctime text 2147483647  √  null Not consistently used. Y indicates a time difference of less than 4 seconds between tag clock and internet synchronized computer. Why is the name different than the MK10 programming table.
battvolts text 2147483647  √  null Live reading of battery voltage.
depthtemp text 2147483647  √  null Live reading of the depth associated temperature sensor.
cond text 2147483647  √  null Live conductivity reading.
transperday text 2147483647  √  null Maximum number of transmissions per day.
add2next text 2147483647  √  null Whether or not the previous days unused transmissions should be added to the next days quota.
cthreshold text 2147483647  √  null Number representing conductivity threshold.
hours text 2147483647  √  null Selected hours of the day the tag can transmit. The field otherhours is used for custom hourly selections.
days text 2147483647  √  null Selected days of the month the tag can transmit.
months text 2147483647  √  null Selected months of the year the tag can transmit.
repratefast text 2147483647  √  null The maximum transmission repetition rate.
reprateslow text 2147483647  √  null The minimum transmission repetition rate.
check4dry text 2147483647  √  null The frequency in seconds the tag checks to see if it is dry.
change2slow text 2147483647  √  null The number of consecutive dry readings required before switching to slow repetition rate.
pauseafter text 2147483647  √  null The number of consecutive hours dry required before suspending transmissions to conserve battery.
restartafter text 2147483647  √  null The number of consecutive seconds wet required to resume transmissions after a pause.
updatebutton text 2147483647  √  null Was the update button pushed? Is this field necessary?
transyes text 2147483647  √  null Was the tag transmitting at time of programming?
repfilename text 2147483647  √  null Name of the exported programming report file.
progcomments text 2147483647  √  null Any comments not covered by other fields. For some reason the name is slightly different than MK10 programming table.
histenabled text 2147483647  √  null Will time at temperature histograms be generated?
b1low int4 10  √  null
b1high int4 10  √  null
b2high int4 10  √  null
b3high int4 10  √  null
b4high int4 10  √  null
b5high int4 10  √  null
b6high int4 10  √  null
b7high int4 10  √  null
b8high int4 10  √  null
b9high int4 10  √  null
b10high int4 10  √  null
b11high int4 10  √  null
b12low int4 10  √  null
b12high int4 10  √  null
uplinklutid text 2147483647  √  null An ID used in an LUT system to locate a detached tag.
programmedby text 2147483647  √  null Who programmed the tag.

Table contained 262 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsgspotprogramming_pkey