Table topp.deprecated.fishencounterdata 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
encounterid int4 10  √  null
encounters.encounterid $1 R
transfercaptainid int4 10  √  null
agents.agentid $2 R
transfervesselid int4 10  √  null
vessels.vesselid $3 R
caudallength float4 8,8  √  null
precaudallength float4 8,8  √  null
curvedforklength float4 8,8  √  null
halfgirthcm float4 8,8  √  null
easeuptoboat varchar 40  √  null
bait varchar 40  √  null
numberofhooks float4 8,8  √  null
fishingdepth float4 8,8  √  null
linetest varchar 40  √  null
leadertest varchar 40  √  null
soakfighttime time 15,6  √  null
pullstarttime time 15,6  √  null
setstarttime time 15,6  √  null
surgerytime time 15,6  √  null
surgerycomment text 2147483647  √  null
surgeryboatid int4 10  √  null
vessels.vesselid $4 R
hooktype varchar 40  √  null
departcoast date 13  √  null
buttonsuture1 varchar 80  √  null
buttonsuture2 varchar 80  √  null
closingsuture varchar 80  √  null

Table contained 0 rows at Wed Dec 27 13:21 PST 2017


Close relationships  within of separation: