Table topp.public.tblabft_geodata 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 text 2147483647  √  null
seriesname text 2147483647  √  null
tagcode text 2147483647  √  null
tagtype text 2147483647  √  null
positiontype text 2147483647  √  null
day_ text 2147483647  √  null
date_ text 2147483647  √  null
breedingst text 2147483647  √  null
latitude float8 17,17  √  null
longitude float8 17,17  √  null
comments text 2147483647  √  null
month_ int4 10  √  null
year_ int4 10  √  null
sst float8 17,17  √  null
length float8 17,17  √  null
age float8 17,17  √  null
tkey serial 10  √  nextval('tblabft_geodata_tkey_seq'::regclass)

Table contained 42,371 rows at Wed Dec 27 13:25 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
tkey Primary key Asc tblabft_geodata_pkey