Table topp.deprecated.trips 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
tripid int4 10
encounters.tripid $2 R
triplogs.tripid $1 R
projectid int4 10  √  null
projects.projectid $1 R
ownerid int4 10  √  null
agents.agentid $2 R
vesselid int4 10  √  null
vessels.vesselid $3 R
captaintid int4 10  √  null
agents.agentid $4 R
tripname varchar 80  √  null
departure timestamptz 35,6  √  null
return timestamptz 35,6  √  null
tripcomment text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
tripid Primary key Asc trips_pkey

Close relationships  within of separation: