Table topp.public.tblfgspotprogramming
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 fgsdkey field. 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
fgsdkey serial 10  √  nextval('tblfgspotprogramming_fgsdkey_seq'::regclass) This field should be called eventid. It joins to fgsdkey in tblfgsatdeployments as well as any other place eventid works for SPOT tags.
tagnum 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 text 2147483647  √  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.
pstdate text 2147483647  √  null Local date of programming in PST. Basically duplicated by localdate. Candidate for deprecation.
tagdate text 2147483647  √  null Date of programming from the tag.
tagclockgmt text 2147483647  √  null Time at programming from the tag. Why is the name different than the MK10 programming table?
psttime text 2147483647  √  null Local time of programming in PST. Basically duplicated by timelocal. Candidate for deprecation.
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.
otherhours text 2147483647  √  null Not used much. Custom transmit hours selected.
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.
progcomment text 2147483647  √  null
histenabled text 2147483647  √  null Will time at temperature histograms be generated?
enteredby text 2147483647  √  null Who programmed the tag. Why is the name different than the MK10 programming table?
phone text 2147483647  √  null Phone number of tag programmer.
email text 2147483647  √  null The email address of tag programmer.
localdate text 2147483647  √  null Local date of programming.
timelocal text 2147483647  √  null Local time of programming. Why is the name different than the MK10 programming table?

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

Indexes:
Column(s) Type Sort Constraint Name
fgsdkey Primary key Asc tblfgspotprogramming_pkey