Table topp.public.tbltmarchival
This is the management table for archival tags. Typically joins will be made to the tagnumber field. Important fields used as query filters are tagmodel, tagstatus, 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
tk0 serial 10  √  nextval('tbltmarchival_tk0_seq'::regclass) Unique ID serial primary key field.
comments text 2147483647  √  null Any comments about the tag including past locations.
hardwareversion text 2147483647  √  null Specific to Wildlife Computers tags. The hardware revision number of the tag.
invoicedate date 13  √  null What is the date on the shipping invoice?
ordernumber text 2147483647  √  null The order number.
physicallocation text 2147483647  √  null Duplicated by tagstatus and comments. Should be merged into them and deprecated.
startdate date 13  √  null Not sure about this one. Candidate for deprecation.
taglabel text 2147483647  √  null Generic reference to label style and content. Generally either Pacific or Atlantic.
tagmodel text 2147483647  √  null Manufacturer model number of tag.
tagnumber text 2147483647  √  null The manufacturer serial number.
tagstatus text 2147483647  √  null The current location and/or status of the tag.
rewardamount text 2147483647  √  null What is the reward amount printed on the tag?
suture text 2147483647  √  null Belongs in the deployment or programming table. Candidate for deprecation.
rma_number text 2147483647  √  null RMA number associated with tag return to manufacturer.
rma_request text 2147483647  √  null The requested action associated with rma_number.
tagware text 2147483647  √  null Wildlife Computers specific. The tag firmware/software version number.
warranty_requested text 2147483647  √  null Was a warranty replacement requested for this tag?
warranty_replaced text 2147483647  √  null Was the tag replaced under warranty?
free_test text 2147483647  √  null Is this a free and/or test tag?
warranty_denied text 2147483647  √  null Was warranty replacement denied for this tag?
owner text 2147483647  √  null Who owns the tag?
eventid int4 10  √  null The eventid assigned to the tag if it was deployed. The most recent eventid if it was deployed multiple times.
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?
eventid_prev text 2147483647  √  null Previous eventids if the tag was deployed multiple times. Still trying to decide if this field is useful.
tagmodel_num text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
tk0 Primary key Asc tbltmarchival_pkey