Table srdb.srdb.assessment
Assesment-level details, defines ASSESSID.

 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
assessid varchar 200
bioparams.assessid Implied Constraint R
brptots.assessid brptots_assessid_fkey R
mostrecent.assessid Implied Constraint R
reference_point_units_view.assessid Implied Constraint R
reference_point_values_view.assessid Implied Constraint R
referencedoc.assessid referencedoc_assessid_fkey R
timeseries.assessid timeseries_assessid_fkey R
timeseries_units_view.assessid Implied Constraint R
timeseries_values_view.assessid Implied Constraint R
tsrelative_explicit_view.assessid Implied Constraint R
assessorid varchar 40  √  null
assessor.assessorid assessment_assessorid_fkey R
stockid varchar 40  √  null
stock.stockid assessment_stockid_fkey R
recorder varchar 40  √  null
recorder.nameinxls assessment_recorder_fkey R
daterecorded date 13  √  null
dateloaded date 13  √  null
assessyear varchar 9  √  null
assesssource varchar 1000  √  null
contacts varchar 300  √  null
notes varchar 1000  √  null
pdffile varchar 300  √  null
assess int4 10  √  null
refpoints int4 10  √  null
assessmethod varchar 200  √  null
assessmethod.methodshort assessment_assessmethod_fkey R
assesscomments varchar 1000  √  null
xlsfilename varchar 100  √  null
mostrecent varchar 3  √  null

Table contained 361 rows at Fri Dec 09 15:00 PST 2011

Indexes:
Column(s) Type Sort Constraint Name
assessid Primary key Asc assessment_pkey
assessid Performance Asc assessment_index_assessid

Close relationships  within of separation: