View topp.public.tblabft_deploy_all
This is a basic view that gathers all essential ABFT deploy data. Used as a source in other views.

 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
contag1number text 2147483647  √  null
contag2number text 2147483647  √  null
len1 text 2147483647  √  null
mass text 2147483647  √  null
dlatdeg text 2147483647  √  null
dlatmin text 2147483647  √  null
ns text 2147483647  √  null
dlondeg text 2147483647  √  null
dlonmin text 2147483647  √  null
ew text 2147483647  √  null
tagtype text 2147483647  √  null
successful text 2147483647  √  null
day float8 17,17  √  null
month float8 17,17  √  null
year float8 17,17  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
progpopdate text 2147483647  √  null
project text 2147483647  √  null
tagmodel text 2147483647  √  null

Analyzed at Wed Dec 27 13:25 PST 2017