Table topp.public.tblsgconvdeployment 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
tkey serial 10  √  nextval('tblsgconvdeployment_tkey_seq'::regclass)
sgcdepkey int4 10
toppid int4 10  √  null
contagnum text 2147483647  √  null
contag2num text 2147483647  √  null
taggingdate date 13  √  null
taggingtime time 15,6  √  null
seriesname text 2147483647  √  null
length_cfl float4 8,8  √  null
length_pcl text 2147483647  √  null
dna_yn text 2147483647  √  null
dnanumber text 2147483647  √  null
copepods_yn text 2147483647  √  null
copepodnumber text 2147483647  √  null
dlatdd float4 8,8  √  null
dlondd float4 8,8  √  null
sst text 2147483647  √  null
comments text 2147483647  √  null
project text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
sgcdepkey Primary key Asc tblsgconvdeployment_pkey