Table topp.public.tblsgmk10programming
This table contains programming metadata for later generation (MK10, miniPAT) satellite tagged sharkgroup animals. Typically joins will be made to the sgdepkey field. There are 14 bin fields for depth and temperature each. The histogram bin values, in order from lowest to highest, can be found in these fields in incremental order starting with bin1. These same values are concatenated into the depth_bins and temp_bins fields, as well as stored in tblprogbin_depth and tblprogbin_temp. The idea of using the progbin tables is to make this programming table simpler. Some fields are MK10 or miniPAT specific. Many are not required for a successful deployment. Some have carried over from tblpatprogramming and should be eliminated.

 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('tblsgmk10programming_tkey_seq'::regclass)
sgdepkey int4 10 This field should be called eventid. It joins to sgdepkey in tblsharkdeployment and tblsharkrecovery, and sgdkey in tblsgprocessingstatus.
progsw text 2147483647  √  null Programming software revision number.
progby text 2147483647  √  null Who programmed the tag.
localdate date 13  √  null Local date of programming.
tagdate date 13  √  null Date of programming from the tag.
_localtime time 15,6  √  null Local time of programming.
tagtime time 15,6  √  null Time at programming from the tag.
tagnumber text 2147483647  √  null Manufacturer serial number of tag.
argosid int4 10  √  null The Argos PTT number for the tag.
uplinklutid text 2147483647  √  null An ID used in an LUT system to locate a detached tag.
reprate text 2147483647  √  null Repetition interval for signal transmission.
tagsoft text 2147483647  √  null The tag firmware/software version number.
hardversion text 2147483647  √  null Manufacturer hardware revision number.
sampdepth text 2147483647  √  null Archive sampling rate for depth sensor data.
sampinttemp text 2147483647  √  null Archive sampling rate from internal temperature sensor data.
sampexttemp text 2147483647  √  null Archive sampling rate from external temperature sensor data.
sampdepthtemp text 2147483647  √  null Archive sampling rate from the depth associated temperature sensor.
samplight text 2147483647  √  null Archive sampling rate for light level data.
sampbattvolts text 2147483647  √  null Archive sampling rate for battery voltage.
isensthresh text 2147483647  √  null Threshold value for wet/dry determinations. Defaults to dynamic.
samplemode text 2147483647  √  null Wet or dry sampling mode. WetDry is the only value stored in this field.
depthcorrmethod text 2147483647  √  null Method to calibrate depth sensor (usually shallow depth).
datainterval text 2147483647  √  null The histogram data aggravation interval in hours.
bin1depth text 2147483647  √  null
bin2depth text 2147483647  √  null
bin3depth text 2147483647  √  null
bin4depth text 2147483647  √  null
bin5depth text 2147483647  √  null
bin6depth text 2147483647  √  null
bin7depth text 2147483647  √  null
bin8depth text 2147483647  √  null
bin9depth text 2147483647  √  null
bin10depth text 2147483647  √  null
bin11depth text 2147483647  √  null
bin12depth text 2147483647  √  null
bin13depth text 2147483647  √  null
bin14depth text 2147483647  √  null
bin1temp text 2147483647  √  null
bin2temp text 2147483647  √  null
bin3temp text 2147483647  √  null
bin4temp text 2147483647  √  null
bin5temp text 2147483647  √  null
bin6temp text 2147483647  √  null
bin7temp text 2147483647  √  null
bin8temp text 2147483647  √  null
bin9temp text 2147483647  √  null
bin10temp text 2147483647  √  null
bin11temp text 2147483647  √  null
bin12temp text 2147483647  √  null
bin13temp text 2147483647  √  null
bin14temp text 2147483647  √  null
patdtprofile text 2147483647  √  null Will the tag transmit PDT data?
lllocations text 2147483647  √  null Will the tag record light level locations?
samphistogram text 2147483647  √  null Not used. Carry over from tblpatprogramming. Candidate for deprecation.
daystorelease text 2147483647  √  null The number of days after which the tag will release. Measured from tag activation/deployment date.
popdate date 13  √  null The programmed popup date.
popuphour time 15,6  √  null The programmed hour of popup.
prematdepth text 2147483647  √  null The minimum depth to start premature release detection.
premathours text 2147483647  √  null Consecutive hours at constant depth before premature release is initiated.
prematoutliers text 2147483647  √  null Allow a few outliers in the constant depth data?
prematsurface text 2147483647  √  null Does the tag have to be at surface to initiate premature release?
savedrepname text 2147483647  √  null Name of the exported programming report file.
shrinkid text 2147483647  √  null ID on leader heat shrink.
shrinklength text 2147483647  √  null Length of the leader heat shrink in inches.
actualsequence text 2147483647  √  null A MK10 setting. Ratio of light level location transmissions to other transmissions (i.e. histograms and PDTs) after popup.
bobbin text 2147483647  √  null What type of bobbin is on the tag? Generally either black or orange.
dart text 2147483647  √  null What type of dart was used, e.g., deck, nylon, OTS titanium.
daysdblprior text 2147483647  √  null Number of days of data just prior to a premature release that will be transmitted with double priority. Rarely used. Could be deprecated.
daysmemoryfilled text 2147483647  √  null Number of days from deployment until the memory on the tag will be filled.
deployed text 2147483647  √  null Was the tag put in deployment mode? This is duplicated by the exitmode field. Good candidate for deprecation.
exitmode text 2147483647  √  null What state is the tag in? Deployed, standby or shutdown? This field essentially duplicated the deployed field.
_float text 2147483647  √  null Style of the float. Probably not necessary. Candidate for deprecation.
ibattvolts text 2147483647  √  null Live reading of battery voltage.
idepth text 2147483647  √  null Live reading of depth sensor.
idepthtemp text 2147483647  √  null Live reading of the depth associated temperature sensor.
iexttemp text 2147483647  √  null Live reading of the external temperature sensor.
iinttemp text 2147483647  √  null Live reading of the internal temperature sensor.
ilight text 2147483647  √  null Live reading of the light sensor.
iwetdry text 2147483647  √  null Live reading of wet/dry sensor. If tag is dry should read 255.
leaderlength text 2147483647  √  null The length of the tag leader in inches.
locationpriority text 2147483647  √  null Transmission priority for location data, e.g., none, low or high.
_offset text 2147483647  √  null Time offset from UTC for histogram sampling period. Affects PDT data period also.
poptime time 15,6  √  null The programmed time of popup. Defaults to 12:00.
predetectdepth text 2147483647  √  null Not used. Duplicate of prematdepth. The minimum depth to start premature release detection.
prematdayspr text 2147483647  √  null Not used. Carry over from tblpatprogramming. Candidate for deprecation.
progcomments text 2147483647  √  null Any comments not covered by other fields.
progcycle text 2147483647  √  null Not used anymore. Good candidate for deprecation. Counting from 1, the current number of times the tag has been programmed for current project.
pswdchanged text 2147483647  √  null Was the password changed? Not generally used. Candidate for deprecation.
sameaswake text 2147483647  √  null Not used. Carry over from tblpatprogramming. Candidate for deprecation.
sampwetdry text 2147483647  √  null Archive sampling rate for wet/dry data.
tagprobs text 2147483647  √  null Duplicate of progcomments. They should be merged and this field can be deprecated.
timeacc text 2147483647  √  null Not consistently used. Y indicates a time difference of less than 4 seconds between tag clock and internet synchronized computer.
verifymode text 2147483647  √  null Not generally used anymore. Was exit mode verified with a magnet?
depthvar text 2147483647  √  null Acceptable variation in depth within which the tag is considered to be at a constant value.
ts_depth_transmit text 2147483647  √  null MiniPAT specific. Will the tag transmit depth time series data?
ts_temp_transmit text 2147483647  √  null MiniPAT specific. Will the tag transmit temperature time series data?
transmit_mlt text 2147483647  √  null MiniPAT specific. Will the tag transmit data on mixed layer stats?
transmit_histo text 2147483647  √  null MiniPAT specific. Will the tag transmit depth and temperature histrogram data?
homing_pinger text 2147483647  √  null MiniPAT specific. Was the homing pinger activated?
sample_int text 2147483647  √  null Time in seconds for time series sample interval.
bin_id_d int4 10  √  null Integer ID that links to tblprogbins_depth in order to retrieve bin values.
bin_id_t int4 10  √  null Integer ID that links to tblprogbins_temp in order to retrieve bin values.
depth_bins text 2147483647  √  null A string concatenation of the depth bin fields.
temp_bins text 2147483647  √  null A string concatenation of the temp bin fields.
leader_cuff text 2147483647  √  null Type of construction used to build the leader cuff.
leader_type text 2147483647  √  null Type and size of material used to construct leader.
leaderer text 2147483647  √  null Who built the leader?

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

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