Table topp.public.tblsgarchivalrecovery
This table is almost never used. It is rare for an archival deployment on a shark. The table structure is similar to tblfgarchivalrecovery.

 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
tkey serial 10  √  nextval('tblsgarchivalrecovery_tkey_seq'::regclass)
sgdepkey int4 10
toppid int4 10  √  null
tagcode text 2147483647  √  null
recvspecies text 2147483647  √  null
recvctag1 text 2147483647  √  null
rct1type text 2147483647  √  null
recvctag2 text 2147483647  √  null
rct2type text 2147483647  √  null
addrecvtags text 2147483647  √  null
recdate date 13  √  null
tagreturned text 2147483647  √  null
tagfunctional text 2147483647  √  null
rlatdd float8 17,17  √  null
sn text 2147483647  √  null
rlondd float8 17,17  √  null
ew text 2147483647  √  null
recvbinfile text 2147483647  √  null
recvsourcetype text 2147483647  √  null
recvsourcename text 2147483647  √  null
rewardperson text 2147483647  √  null
rewardaddress text 2147483647  √  null
paid text 2147483647  √  null
paidby text 2147483647  √  null
recvlen float4 8,8  √  null
recvlentype text 2147483647  √  null
recvmass float4 8,8  √  null
recvmasstype text 2147483647  √  null
recvgirth float4 8,8  √  null
recvgirthtype text 2147483647  √  null
sex text 2147483647  √  null
sst float4 8,8  √  null
recvcomment text 2147483647  √  null
willbeprocessed text 2147483647  √  null
reclocation text 2147483647  √  null
recvbinpwd text 2147483647  √  null
injuries text 2147483647  √  null
obtainedfrom text 2147483647  √  null
contactcomments text 2147483647  √  null
tagcomments text 2147483647  √  null
userr text 2147483647  √  null
uphone text 2147483647  √  null
uemail text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
sgdepkey Primary key Asc tblsgarchivalrecovery_pkey