SchemaSpy - Table topp.public.tbltmsat

This is the management table for satellite tags. Typically joins will be made using both the tagnumber and pttnumber fields. Important fields used as query filters are tagmodel, tagmodel_num, tagstatus, invoicedate and owner. There is only one record for each tagnumber but there are multiples times where pttnumber is duplicated across different tag numbers. All date fields should be converted from type text to date or timestamp.

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default	Comments
comments	text	2147483647	√		null	Any comments about the tag including past locations.
deploykey	int4	10	√		null	This should be called eventid. The eventid assigned to the tag if it was deployed.
format	text	2147483647	√		null	The Argos transmitter formatting. Specific to tag model and requested with new PTTs from CLS America.
hexadecimal	text	2147483647	√		null	The hexadecimal number ID for an Argos PTT.
instrumentreportfiles	text	2147483647	√		null	Generic comment on how the instrument report file was received for a new tag, e.g., "hardcopy in tag shipment" or "Tag Agent".
invoicenumber	text	2147483647	√		null	The number on the shipping invoice.
pttstatus	text	2147483647	√		null	The current status of the PTT number. Is it active, recycled to another tag or been returned to Argos?
physicallocation	text	2147483647	√		null	Duplicated by tagstatus and comments. Should be merged into them and deprecated.
programnumber	int4	10	√		null	The Argos program number associated with the PTT number.
programmingreportfile	text	2147483647	√		null	Exists and belongs in the programming table. Candidate for deprecation.
repetitionperiod	text	2147483647	√		null	The repetition period for the Argos PTT. Not sure of the units.
tagsoft	text	2147483647	√		null	The tag firmware/software version number. This value could change with an upgrade on older tags (PAT 1 to PAT 5), making it difficult to get tagmodel correct.
actualpopupdate	date	13	√		null	Exists and belongs in recovery table. Candidate for deprecation.
enddate	date	13	√		null	Not sure about this one. Possible duplicate of satdeployments enddate field. Candidate for deprecation.
programmedpopdupdate	date	13	√		null	Exists and belongs in the programming table. Candidate for deprecation.
project	text	2147483647	√		null	Duplicated by tagstatus and comments. Should be merged into them and deprecated.
pttnumber	int4	10	√		null	The Argos ID/PTT number for the tag.
quotenumber	text	2147483647	√		null	Sometimes the order quote number is available. It is stored in this field.
sequentialnumber	text	2147483647	√		null	Unknown. Candidate for deprecation.
species	text	2147483647	√		null	Exists and belongs in deploy table. Candidate for deprecation.
startdate	date	13	√		null	Not sure about this one. Possible duplicate of satdeployments startdate field. Candidate for deprecation.
taglabel	text	2147483647	√		null	Generic reference to label style and content. Generally either Pacific, Atlantic, Wildlife etc.
tagmodel	text	2147483647	√		null	Manufacturer model name of the tag, e.g., PAT-MK10, miniPAT or SPOT5. Should match tagmodel field in tbltopptags. There is a major caveat with this field. Older Wildlife tags (PAT 1 to PAT 5) can change model name with a tagware upgrade! Therefore it is possible a tag might have first been deployed as a PAT 2, recovered and upgraded and deployed again but this time as a PAT 4. This field will only try and track the most recent model name. For this reason it should not be expected to always match modelname in satdeployments or tagmodel in tblfgsatdeployments. This also means that there is not a single perfect source for model name. Table satdeployments is the most logical but it is likely missing records from some older tags, meaning in some situations tblfgsatdeployments will be best. Currently tblsharkdeployment does not include a model name field.
tagnumber	text	2147483647	√		null	The manufacturer serial number.
tagowner	text	2147483647	√		null	Who owns the tag?
tagstatus	text	2147483647	√		null	The current location and/or status of the tag.
toppid	text	2147483647	√		null	Basically duplicated by deploykey. Candidate for deprecation.
rewardamount	text	2147483647	√		null	What is the reward amount printed on the tag?
dart	text	2147483647	√		null	Exists and belongs in programming and/or deploy table. Candidate for deprecation.
chaffing	text	2147483647	√		null	Exists and belongs in programming and/or deploy table. Candidate for deprecation.
invoicedate	text	2147483647	√		null	What date is on the shipping invoice.
uplinkid	text	2147483647	√		null	An ID used in an LUT system to locate a detached tag. Also found in the programming table. Maybe more appropriate in the programming table.
tkey	serial	10		√	nextval('tbltmsat_tkey_seq'::regclass)
argos_region	text	2147483647	√		null	The primary ocean region in which the PTT is expected to transmit. Not important for transmission success according to Argos. Generally either Pacific, Atlantic or Indian.
argosdirect	text	2147483647	√		null	Is the PTT currently enrolled in the Argos Direct program? Tags in Argos Direct generate emails with each new detection for a selected group of email addresses.
refurbished	text	2147483647	√		null	Was the tag returned to the manufacturer for refurbishment? Generally this would mean testing of sensors and installation of a new battery.
ordernum	text	2147483647	√		null	Customer specific like a purchase order number.
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?
igfa_invoice_num	text	2147483647	√		null	Not sure about this one. Either IGFA purchase order number, or Block lab invoice number submitted to IGFA for payment.
igfa_invoice_date	text	2147483647	√		null	The date of the IGFA invoice.
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.
tagmodel_num	text	2147483647	√		null	Probably specific to Wildlife Computers. More specific tag model information, e.g., newer Mk9s can be number 286C or 286F.

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

Indexes:

Column(s)	Type	Sort	Constraint Name
tkey	Primary key	Asc	tbltmsat_pkey