Table topp.public.tblfgarchivalprogramming
This table contains programming metadata for archival tagged fishgroup animals. Typically joins will be made to the fgapkey 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
fgapkey serial 10  √  nextval('tblfgarchivalprogramming_fgapkey_seq'::regclass) This field should be called eventid. It joins to fgarkey in tblfgarchivalrecovery, fgdkey in tblfgprocessingstatus and fgadkey in tblfgarchivaldeployment as well as any other place eventid works for archival tags.
workgroup text 2147483647  √  null Hardly ever used. Candidate for deprecation.
fieldleader text 2147483647  √  null Hardly ever used. Candidate for deprecation.
toppid text 2147483647  √  null The basic ID number for a specific animal deployment.Matches the first 7 digits of eventid.
tagcode text 2147483647  √  null Serial number of tag with prefix identifying manufacturer and model. The prefix matches tagcode in tbltopptags. This prefix is unnecessary given the tagmodel field and will be deprecated in future.
calfile text 2147483647  √  null Not used. Unsure of original intent. Good candidate for deprecation.
reverfile text 2147483647  √  null Not used. Unsure of original intent. Good candidate for deprecation.
progdate text 2147483647  √  null UTC date of programming.
progtime text 2147483647  √  null UTC time of programming.
transtatus text 2147483647  √  null A Lotek LTD tag setting that confirmssuccessful bin file download.
etemp text 2147483647  √  null A live reading of the external temperature sensor.
itemp text 2147483647  √  null A live reading of the internal temperature sensor.
light text 2147483647  √  null A live reading of the light sensor.
depth text 2147483647  √  null A live reading of the depth sensor.
timediff text 2147483647  √  null The difference between internet synchronizedtime and tag time.
tagreset text 2147483647  √  null A Lotek LTD reference to whether or not the tag was reset.
recint text 2147483647  √  null The sampling interval in seconds.
tele text 2147483647  √  null Will the tag telescope data?
dzero text 2147483647  √  null A Lotek LTD specific setting that defaults to 50 and was probably never changed.
delay text 2147483647  √  null The number of days delay from programming date before the tag starts recording data.
password text 2147483647  √  null What is the tag password?
tagprogby text 2147483647  √  null Who programmed the tag?
jdatefile text 2147483647  √  null Related to Lotek LTD journal file. Never used. Good candidate for deprecation.
progjnlfile text 2147483647  √  null The Lotek LTD journal file saved during programming.
bdatefile text 2147483647  √  null Related to Lotek LTD bin file. Never used. Good candidate for deprecation.
progbinfile text 2147483647  √  null The Lotek LTD bin file downloaded during programming.
ppassword text 2147483647  √  null Never used. Good candidate for deprecation.
spassword text 2147483647  √  null Never used. Good candidate for deprecation.
tagprogcomments text 2147483647  √  null
battvolt text 2147483647  √  null Battery voltage at programming.
seriesname text 2147483647  √  null Duplicate from deployment table. Good candidate for deprecation.
project text 2147483647  √  null Duplicate from deployment table. Good candidate for deprecation.
localprogtime text 2147483647  √  null Local time at programming. Not commonly used. Good candidate for deprecation.
startdate text 2147483647  √  null The Lotek LAT data recording start date.
memory_percent int4 10  √  null The Lotek LAT value for percent of memory used.
memory_duration_days int4 10  √  null The Lotek LAT value for number of days until memory is full.
pressure_bits int4 10  √  null The Lotek LAT bits used to record depth data.
pressure_min int4 10  √  null The Lotek LAT minimum depth bound.
pressure_max int4 10  √  null The Lotek LAT maximum depth bound.
pressure_precision float8 17,17  √  null The Lotek LAT depth resolution in decibars.
light_bits int4 10  √  null The Lotek LAT bits used to record light date.
light_min int4 10  √  null The Lotek LAT minimum light bound.
light_max int4 10  √  null The Lotek LAT maximum light bound.
light_precision float8 17,17  √  null The Lotek LAT light resolution in 224 unit less levels.
itemp_bits int4 10  √  null The Lotek LAT bits used to record internal temperature data.
itemp_min int4 10  √  null The Lotek LAT minimum internal temperature bound.
itemp_max int4 10  √  null The Lotek LAT maximum internal temperature bound.
itemp_precision float8 17,17  √  null The Lotek LAT internal temperature resolution.
etemp_bits int4 10  √  null The Lotek LAT bits used to record external temperature data.
etemp_min int4 10  √  null The Lotek LAT minimum external temperature bound.
etemp_max int4 10  √  null The Lotek LAT maximum external temperature bound.
etemp_precision float8 17,17  √  null The Lotek LAT external temperature resolution.
start_logging text 2147483647  √  null Was logging started on the Lotek LAT tag?
tagdate text 2147483647  √  null Local tag date.
tagtime text 2147483647  √  null Local tag time. Duplication of localprogtime. One of them should be deprecated.
progsw text 2147483647  √  null The programming software version number.
tagsoft text 2147483647  √  null The tag firmware/software version number.
battpercent_used text 2147483647  √  null How much of the battery has already been used?
memory_cleared text 2147483647  √  null Was the memory cleared during programming?
daysmemoryfilled text 2147483647  √  null Wildlife version of memory_duration_days. Could probably combine them.
exitmode text 2147483647  √  null What state is the tag in? Deployed, standby or shutdown?

Table contained 2,074 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
fgapkey Primary key Asc tblfgarchivalprogramming_pkey