Table topp.public.acoustic_foreign
This table tracks ID codes of unknown, non-Block Lab tags detected on our network.

 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_foreign_akey_seq'::regclass) Unique ID serial primary key field.
idcode int4 10  √  null This is the basic identification code for an acoustic tag.
receiver text 2147483647  √  null The detection receiver. Can be multiple receivers.
contact text 2147483647  √  null The tag owner or contact.
address text 2147483647  √  null The mailing address for owner.
email text 2147483647  √  null The email address for owner.
phone text 2147483647  √  null The phone number for owner.
date_ownercontact text 2147483647  √  null When was the owner contacted?
species text 2147483647  √  'unknown'::text Species or common name of tagged animal.
date_detect text 2147483647  √  null Date ranges for detections. Can be multiple ranges.
latdd float8 17,17  √  null Latitude of receiver.
londd float8 17,17  √  null Longitude of receiver.
data2owner text 2147483647  √  null Was the data sent to the owner?
comments text 2147483647  √  null General comments not easily fitting in other fields.
hits text 2147483647  √  null A count of detections for the ID.
date_2vemco text 2147483647  √  null
vemco_contact text 2147483647  √  null Who was the data sent to at Vemco or who responded with owner ID?
codespace text 2147483647  √  null Additional ID information that when combined with code in theory creates the complete unique tag ID.

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

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