Table srdb.srdb.stock
A stock consists of a species (field "tsn" from srdb.taxonomy), an area (field "areaid" from srdb.area). This table also keeps track of stocks that were in RAM's original database and the name used there if it is different from the stockid defined in the RAM Legacy database

 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
stockid varchar 40
assessment.stockid assessment_stockid_fkey R
lmetostocks.stockid lmetostocks_stockid_fkey R
mostrecent.stockid Implied Constraint R
tsn int4 10  √  null
taxonomy.tsn stock_tsn_fkey R
scientificname varchar 200  √  null
commonname varchar 200  √  null
areaid varchar 70  √  null
area.areaid stock_areaid_fkey R
stocklong varchar 200  √  null
inmyersdb int4 10  √  null
myersstockid varchar 40  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
stockid Primary key Asc stock_pkey

Close relationships  within of separation: