Schemas
Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
Table
topp
.
deprecated
.
fishrecoveries
Generated by
SchemaSpy
Related columns
Constraints
Comments
Legend
Legend:
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
encounterid
int4
10
√
null
encounters
.encounterid
$1
R
recapturedate
date
13
√
null
catchinfo
varchar
255
√
null
fishingboatname
varchar
80
√
null
vesseltype
varchar
80
√
null
contactinfo
varchar
255
√
null
howobtained
varchar
80
√
null
penlocationname
varchar
160
√
null
additionaltags
varchar
80
√
null
Table contained 0 rows at Wed Dec 27 13:21 PST 2017
Close relationships
within
one
two degrees
of separation
: