Table topp.public.acoustic_recovery
This table contains recovery info for acoustic receivers affiliated with Block Lab acoustic detection data. Generally the only important fields are receiver, receiver_dnum and recdatetime. It joins to acoustic_deployment with receiver and receiver_dnum.

 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
akey serial 10  √  nextval('acoustic_recovery_akey_seq'::regclass) Unique ID serial primary key field.
rlatdd float8 17,17  √  null Decimal degree latitude position at recovery.
rlondd float8 17,17  √  null Decimal degree longitude position at recovery.
data_download text 2147483647  √  null Not really used. What the data downloaded?
status_out text 2147483647  √  null Was the receiver functioning at time of recovery.
time_offset text 2147483647  √  null Not currently used.
comments text 2147483647  √  null General comments not easily fitting in other fields.
receiver_dnum int4 10  √  null This value reflects a specific deployment event for an individual receiver. Used along with receiver field to join with acoustic_deployment table.
receiver int4 10  √  null Unique ID of recovered receiver. Each receiver can be recovered multiple times.
downloadid int8 19  √  null A unique date time generated ID associated with a specific file ingestion.
recdatetime timestamp 29,6  √  null The date with or without time at recovery. Local time.

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

Indexes:
Column(s) Type Sort Constraint Name
akey Primary key Asc acoustic_recovery_pkey