Table topp.deprecated.deployments 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
tageventid int4 10  √  null
tagevents.tageventid $1 R
deploymentid int4 10  √  null
speciescode varchar 2  √  null
species.speciescode $2 R
startdate date 13  √  null
enddate date 13  √  null
pttnumber int4 10  √  null
ptts.pttnumber $3 R
actualpopupdate date 13  √  null
deploymenttypeid int4 10  √  null
deploymenttypes.deploymenttypeid $4 R
clockdrift float4 8,8  √  null
track text 2147483647  √  null
provisional bool 1  √  null
programmingeventid int4 10  √  null
tagevents.tageventid $5 R
tabid int4 10  √  null

Table contained 1,128 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
deploymentid Must be unique Asc deployments_deploymentid_key This unique column is also nullable

Close relationships  within of separation: