Table topp.public.tbltgarchivaldeployment 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
adkey serial 10  √  nextval('tbltgarchivaldeployment_adkey_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
capcomments text 2147483647  √  null
capcondition text 2147483647  √  null
caplocation text 2147483647  √  null
capmethod text 2147483647  √  null
capvessel text 2147483647  √  null
carpcondition text 2147483647  √  null
commonname text 2147483647  √  null
daybetweennests text 2147483647  √  null
dlatdeg text 2147483647  √  null
dlatmin text 2147483647  √  null
dlondeg text 2147483647  √  null
dlonmin text 2147483647  √  null
ew text 2147483647  √  null
encounteractivity text 2147483647  √  null
enddate text 2147483647  √  null
endtime text 2147483647  √  null
entwatertime text 2147483647  √  null
envcomment text 2147483647  √  null
gpsused text 2147483647  √  null
gender text 2147483647  √  null
handcomments text 2147483647  √  null
handlingtime text 2147483647  √  null
id1 text 2147483647  √  null
injuries text 2147483647  √  null
lpitnumber text 2147483647  √  null
lpitposition text 2147483647  √  null
lpittype 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
prevtags text 2147483647  √  null
rpitnumber text 2147483647  √  null
rpitposition text 2147483647  √  null
rpittype 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
tag1position text 2147483647  √  null
tag1progdate text 2147483647  √  null
tag2attach text 2147483647  √  null
tag2code text 2147483647  √  null
tag2comment text 2147483647  √  null
tag2position text 2147483647  √  null
tag2progdate text 2147483647  √  null
tag3attach text 2147483647  √  null
tag3code text 2147483647  √  null
tag3comment text 2147483647  √  null
tag3position text 2147483647  √  null
tag3progdate text 2147483647  √  null
tagapplocation text 2147483647  √  null
tagattachment text 2147483647  √  null
tageventcomment text 2147483647  √  null
tagteam text 2147483647  √  null
toppid text 2147483647  √  null
trip2beach text 2147483647  √  null
tgadkey text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
adkey Primary key Asc tbltgarchivaldeployment_pkey