View topp.public.tblpbft_deploy_rec_all 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
fgadkey int4 10  √  null
toppid int4 10  √  null
seriesname text 2147483647  √  null
taggingdate timestamp 29,6  √  null
tagcode text 2147483647  √  null
ptt int4 10  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null
len1 float8 17,17  √  null
mass text 2147483647  √  null
progpopdate text 2147483647  √  null
successful text 2147483647  √  null
recdate timestamp 29,6  √  null
harvdate timestamp 29,6  √  null
popdate timestamp 29,6  √  null
rdateestimated text 2147483647  √  null
poppositiontype text 2147483647  √  null
actpoplat float8 17,17  √  null
actpoplon float8 17,17  √  null
tagreturned text 2147483647  √  null
recvsourcetype text 2147483647  √  null
reclocation text 2147483647  √  null
rlatdd float8 17,17  √  null
rlondd float8 17,17  √  null
tagtype text 2147483647  √  null
recvlen1 text 2147483647  √  null
recvlen1type text 2147483647  √  null
recvmass text 2147483647  √  null
masstype text 2147483647  √  null
recvcomment text 2147483647  √  null
recpositionestimated text 2147483647  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
unknowndeploy text 2147483647  √  null
geolocated text 2147483647  √  null
ssm_complete text 2147483647  √  null
ssm_version text 2147483647  √  null
transpac text 2147483647  √  null
geolocation_days int4 10  √  null
geo_daterange_days int4 10  √  null
lab_recdate text 2147483647  √  null
deployage numeric 131089  √  null
recpop_age numeric 131089  √  null
releasetype text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017