View topp.public.tm_archival_with_eventid
Joins management table and deploy info.

 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
eventid int4 10  √  null
tagnumber text 2147483647  √  null
tagstatus text 2147483647  √  null
comments text 2147483647  √  null
taglabel text 2147483647  √  null
invoicedate date 13  √  null
tagmodel text 2147483647  √  null
rewardamount text 2147483647  √  null
suture text 2147483647  √  null
ordernumber text 2147483647  √  null
rma_number text 2147483647  √  null
rma_request text 2147483647  √  null
taggingdate text 2147483647  √  null
seriesname text 2147483647  √  null
commonname text 2147483647  √  null
dlondd float8 17,17  √  null
dlatdd float8 17,17  √  null
len1 text 2147483647  √  null
len1type text 2147483647  √  null
mass text 2147483647  √  null
project text 2147483647  √  null
releasetype text 2147483647  √  null
toppid int4 10  √  null

Analyzed at Wed Dec 27 13:25 PST 2017