Table topp.public.tbltgsatdeployment 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
sdkey serial 10  √  nextval('tbltgsatdeployment_sdkey_seq'::regclass)
beachmarker text 2147483647  √  null
beachname text 2147483647  √  null
clength text 2147483647  √  null
clengthtype text 2147483647  √  null
cwidth text 2147483647  √  null
cwidthtype text 2147483647  √  null
capcomment text 2147483647  √  null
capcondition text 2147483647  √  null
capmethod text 2147483647  √  null
carpcondition text 2147483647  √  null
comments text 2147483647  √  null
commonname text 2147483647  √  null
dlatdeg text 2147483647  √  null
dlatmin text 2147483647  √  null
dlondeg text 2147483647  √  null
dlonmin text 2147483647  √  null
dnanumber text 2147483647  √  null
dnasamplelocation text 2147483647  √  null
ew text 2147483647  √  null
encounteractivity text 2147483647  √  null
enddate text 2147483647  √  null
endtime text 2147483647  √  null
entwatertime text 2147483647  √  null
gpsused text 2147483647  √  null
gender text 2147483647  √  null
handcomments text 2147483647  √  null
injuries text 2147483647  √  null
lpitnumber text 2147483647  √  null
lpitposition text 2147483647  √  null
leadtagger text 2147483647  √  null
mass text 2147483647  √  null
masstype text 2147483647  √  null
ns text 2147483647  √  null
nestnumber text 2147483647  √  null
neststatus text 2147483647  √  null
nestzone text 2147483647  √  null
origtagid text 2147483647  √  null
pop1date text 2147483647  √  null
pop2date text 2147483647  √  null
prevtags text 2147483647  √  null
prog1date text 2147483647  √  null
prog2date text 2147483647  √  null
rpitnumber text 2147483647  √  null
rpitposition text 2147483647  √  null
releasecomments text 2147483647  √  null
releaselocation text 2147483647  √  null
sst text 2147483647  √  null
scarslocations text 2147483647  √  null
seriesname text 2147483647  √  null
species text 2147483647  √  null
startdate text 2147483647  √  null
starttime text 2147483647  √  null
tag1attach text 2147483647  √  null
tag1code text 2147483647  √  null
tag1comment text 2147483647  √  null
tag1ptt text 2147483647  √  null
tag1position text 2147483647  √  null
tag2attach text 2147483647  √  null
tag2code text 2147483647  √  null
tag2comment text 2147483647  √  null
tag2ptt text 2147483647  √  null
tag2position text 2147483647  √  null
tag3attach text 2147483647  √  null
tag3code text 2147483647  √  null
tag3comment text 2147483647  √  null
tag3position text 2147483647  √  null
tagteam text 2147483647  √  null
toppid text 2147483647  √  null
trip2beach text 2147483647  √  null
weather text 2147483647  √  null
tgsdkey text 2147483647  √  null
tagts timestamp 29,6  √  null
dlatdd float8 17,17  √  null
dlondd float8 17,17  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
sdkey Primary key Asc tbltgsatdeployment_pkey