Table topp.deprecated.projects 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
projectid int4 10
cases.projectid $1 R
files.projectid Implied Constraint R
projectaliases.projectid $1 R
projectspeciesassociations.projectid $1 R
projecttagtypeassociations.projectid $1 R
trips.projectid $1 R
projectname varchar 80  √  null
ownerid int4 10  √  null
agents.agentid $1 R
areaname varchar 40  √  null
year varchar 4  √  null
numberoftags int4 10  √  null
generallocation varchar 80  √  null
projectcomment text 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
projectid Primary key Asc projects_pkey

Close relationships  within of separation: