Table topp.deprecated.archdeployments_nogroup 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
ngkey serial 10  √  nextval('deprecated.archdeployments_nogroup_ngkey_seq'::regclass)
archprogramming_nogroup.ngkey Implied Constraint R
angler text 2147483647  √  null
capcomments text 2147483647  √  null
capvessel text 2147483647  √  null
commonname text 2147483647  √  null
contag1number text 2147483647  √  null
contag1position text 2147483647  √  null
contag1type text 2147483647  √  null
contag2number text 2147483647  √  null
contag2position text 2147483647  √  null
contag2type text 2147483647  √  null
correctedsst text 2147483647  √  null
daystartlat text 2147483647  √  null
daystartlong text 2147483647  √  null
daystarttimelocal text 2147483647  √  null
daystartsst text 2147483647  √  null
deploycomment text 2147483647  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
ew text 2147483647  √  null
gpsused text 2147483647  √  null
injuries text 2147483647  √  null
leadtagger text 2147483647  √  null
len1 text 2147483647  √  null
len1type text 2147483647  √  null
len2 text 2147483647  √  null
len2type text 2147483647  √  null
mass text 2147483647  √  null
masstype text 2147483647  √  null
ns text 2147483647  √  null
project text 2147483647  √  null
releasetype text 2147483647  √  null
seastate text 2147483647  √  null
seriesname text 2147483647  √  null
sex text 2147483647  √  null
species text 2147483647  √  null
sst text 2147483647  √  null
sstdate text 2147483647  √  null
ssttime text 2147483647  √  null
sstprobe text 2147483647  √  null
sstalgorithm text 2147483647  √  null
successful text 2147483647  √  null
tageventcomment text 2147483647  √  null
taggingdate text 2147483647  √  null
taggingtime text 2147483647  √  null
tagcode text 2147483647  √  null
tagposition text 2147483647  √  null
tagteam text 2147483647  √  null
tagapplocation text 2147483647  √  null
tagreleasecomment text 2147483647  √  null
toppid text 2147483647  √  null
weather text 2147483647  √  null
addtag text 2147483647  √  null
datesstcorrected text 2147483647  √  null
tagmodel text 2147483647  √  null
tagtype text 2147483647  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
ngkey Primary key Asc archdeployments_nogroup_pkey

Close relationships: