SchemaSpy - View topp.public.recoveryview

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
tagnumber	varchar	80	√	null
toppid	varchar	20	√	null
modelname	varchar	40	√	null
speciescode	varchar	2	√	null
speciesname	varchar	80	√	null
projectid	int4	10	√	null
projectname	varchar	80	√	null
returned	bool	1	√	null
tagcondition	varchar	160	√	null
recoverymethod	varchar	160	√	null
recovertime	timestamptz	35,6	√	null
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
masskg	float4	8,8	√	null
lengthcm	float4	8,8	√	null
latitude	float4	8,8	√	null
longitude	float4	8,8	√	null

Analyzed at Wed Dec 27 13:25 PST 2017