Table topp.deprecated.vessels 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
vesselid int4 10
fishencounterdata.surgeryboatid $4 R
fishencounterdata.transfervesselid $3 R
trips.vesselid $3 R
ownerid int4 10  √  null
agents.agentid $1 R
vesselname varchar 160  √  null
vesseltype varchar 160  √  null
displacementmt float4 8,8  √  null
lengthm float4 8,8  √  null
vesselcomment text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
vesselid Primary key Asc vessels_pkey

Close relationships  within of separation: