Table topp.public.tbltmacoustic
This is the management table for acoustic tags, receivers and related equipment. Typically joins will be made to one of the idcode fields. Joining to the acoustic_data table requires both idcode and codespace1. Important fields used as query filters are tagfamily, interval_min and max, taglocation, invoicedate and owner. 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('tbltmacoustic_tkey_seq'::regclass) Unique ID serial primary key field.
tagfamily text 2147483647  √  null A basic code describing the tag or receiver.
serialnum text 2147483647  √  null The manufacturer serial number.
idcode int4 10  √  null The primary acoustic transmitting code for a tag. It combines with codespace1 to form a complete identification code for a tag. On older tags this was for identification only. If the tag included environmental sensors then they would be associated with secondary idcodes. On newer tags identification and sensors can be combined.
idcode2 int4 10  √  null A secondary transmitting code. Will always be associated with sensor data. It combines with codespace2 to form a complete identification code for a tag.
frequency text 2147483647  √  null The transmitting frequency of the tag. Either 69 or 81 kHz.
freqtype1 text 2147483647  √  null The submap type for idcode, e.g., S256 or R64K.
freqtype2 text 2147483647  √  null The submap type for idcode2, e.g., S256 or R64K.
freqsync1 text 2147483647  √  null Not sure about this field. I think it is related to the code map.
freqsync2 text 2147483647  √  null Not sure about this field. I think it is related to the code map.
bin text 2147483647  √  null Not sure about this field. I think it is related to the code map.
interval_min text 2147483647  √  null The minimum timing in seconds at which the tag will transmit.
interval_max text 2147483647  √  null The maximum timing in seconds at which the tag will transmit.
est_taglife text 2147483647  √  null The estimated number of days the tag battery will last once the tag is activated.
sensor text 2147483647  √  null What is the first sensor installed on the tag, e.g., pressure, temperature or accelerometer.
range text 2147483647  √  null What range of values can the sensor detect. The units depends on the sensor type.
slope float4 8,8  √  null The slope value for converting raw sensor data.
intercept float4 8,8  √  null The intercept value for converting raw sensor data.
deployed text 2147483647  √  null Has the tag been deployed? Not used very often. Basically duplicated by deploykey.
taglocation text 2147483647  √  null What is the current location of the tag/receiver?
comments text 2147483647  √  null Any comments about the tag including past locations.
invoicedate text 2147483647  √  null What is the date on the shipping invoice?
idcode3 int4 10  √  null A secondary transmitting code. Will always be associated with sensor data. It combines with codespace3 to form a complete identification code for a tag.
freqtype3 text 2147483647  √  null The submap type for idcode3, e.g., S256 or R64K.
freqsync3 text 2147483647  √  null Not sure about this field. I think it is related to the code map.
sensor2 text 2147483647  √  null What is the second sensor installed on the tag?.
range2 text 2147483647  √  null What range of values can the sensor detect. The units depends on the sensor type.
slope2 float4 8,8  √  null The slope value for converting raw sensor data.
intercept2 float4 8,8  √  null The intercept value for converting raw sensor data.
deploykey int4 10  √  null This should be called eventid. The eventid assigned to the tag if it was deployed.
pulse_width text 2147483647  √  null Not sure about this field. Rarely if ever used.
code_type text 2147483647  √  null Not sure about this field. Possible duplicate of freqtype.
map_name text 2147483647  √  null Not used much. What code map is the receiver using?
submap_id text 2147483647  √  null Not used much. Not sure about it.
dart text 2147483647  √  null Not used much. Would normally be in a programming table. Could be deprecated.
chaffing text 2147483647  √  null Not used much. Would normally be in a programming table. Could be deprecated.
leader text 2147483647  √  null Not used much. Would normally be in a programming table. Could be deprecated.
ordernumber text 2147483647  √  null The order number.
codespace1 text 2147483647  √  null A combination of frequency and space, e.g., A69-1303 or A69-9002.
vr4_feed text 2147483647  √  null Not used consistently. Is the tag included on a VR4-Global notification list?
codespace2 text 2147483647  √  null Codespace for idcode2.
codespace3 text 2147483647  √  null Codespace for idcode3.
est_batt_update text 2147483647  √  null Vemco gave us updated battery life estimates for a particular group of tags. We could probably request this service again if necessary. What is the adjusted battery life estimate in days?
batt_update_date text 2147483647  √  null When did the new battery life update take place?
batt_replace_date text 2147483647  √  null VMT specific though it could work for any receiver. When was the battery replaced?
dead_by_date text 2147483647  √  null Based on invoice date and est_taglife when will the battery likely die?
last_detect_date text 2147483647  √  null Not used or updated regularly. On what date was the tag last detected?
owner text 2147483647  √  null Who owns the tag/receiver?
sensor3 text 2147483647  √  null What is the third sensor installed on the tag?.
range3 text 2147483647  √  null What range of values can the sensor detect. The units depends on the sensor type.
slope3 float4 8,8  √  null The slope value for converting raw sensor data.
intercept3 float4 8,8  √  null The intercept value for converting raw sensor data.
firmware_date text 2147483647  √  null When was the receiver firmware last updated?
vr4_iridium text 2147483647  √  null VR4-Global specific. Is Iridium active or suspended for the receiver. If active the receiver will be included in acoustic_vr4plan auto query to update balance_current.
vr4_dp_activedate date 13  √  null VR4-Global specific. On what date was Iridium activated for the receiver?
vr4_dataplan text 2147483647  √  null VR4-Global specific. Basic description of the Iridium data plan - date and approximate length.
vr4_dp_suspenddate date 13  √  null VR4-Global specific. On what date was Iridium suspended for the receiver?
units text 2147483647  √  null The units for sensor 1.
units2 text 2147483647  √  null The units for sensor 2.
accel_alg text 2147483647  √  null
accel_samp_persec text 2147483647  √  null
sensor_transratio text 2147483647  √  null The transmit ratio for sensor 1.
sensor2_transratio text 2147483647  √  null The transmit ratio for sensor 2.
trade_owner text 2147483647  √  null If the tag was traded between owners who is the new owner?
trade_tag text 2147483647  √  null If the tag was traded between owners what tag was it traded for?
trade_date text 2147483647  √  null If the tag was traded between owners on what date did the trade take place?
tagtype text 2147483647  √  null

Table contained 1,321 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc tbltmacoustic_pkey