SchemaSpy Analysis of srdb.srdb | Generated by SchemaSpy |
Generated by SchemaSpy on Fri Dec 09 15:00 PST 2011 | |
Database Type: PostgreSQL - 8.4.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
Table | Children | Parents | Columns | Rows | Comments |
---|---|---|---|---|---|
area | 1 | 1 | 6 | 230 | Stock areas, used in the definition of stocks. |
assessment | 3 | 4 | 17 | 361 | Assesment-level details, defines ASSESSID. |
assessmethod | 1 | 3 | 53 | Details of assessment methods. | |
assessor | 1 | 1 | 4 | 59 | Details of assessors. An assessor must be associated with a management boby from the table srdb.management. |
biometrics | 2 | 7 | 176 | Definition of point metrics such as reference points, life-history parameters and description of timeseries (e.g. age of recruitment, ages used in F calculations, etc.). | |
bioparams | 1 | 5 | 4,676 | Values of point metrics. | |
brptots | 3 | 4 | 661 | ||
fishbasesaupcodes | 1 | 5 | 279 | ||
lmerefs | 1 | 2 | 69 | ||
lmetostocks | 2 | 3 | 456 | ||
management | 2 | 3 | 26 | Management bodies, used in the definition of stock areas and stock assessors. | |
mostrecent | 4 | 360 | Table with information about which assessment is the most recent, what it updates, whether it is a duplicate, etc.. | ||
recorder | 1 | 8 | 43 | Details for recorders of assessments. | |
reference_point_units_view | 13 | 333 | |||
reference_point_values_view | 13 | 333 | This is a view that organises the reference points into separate columns. Contains only the most recent stocks as identified in srdb.mostrecent | ||
referencedoc | 2 | 3 | 3,693 | RIS fields containing the reference document for an assessment. | |
risfields | 2 | 2 | 33 | Name of RIS fields. | |
risfieldvalues | 1 | 3 | 12 | Allowed RIS field values. | |
stock | 2 | 2 | 8 | 424 | 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 |
taxonomy | 2 | 14 | 283 | Taxonomic information obtained from the Integrated Taxonomic Information System (ITIS). Negative values for taxonomic serial number (TSN) are used in cases where a stock is of a species not present in ITIS. | |
timeseries | 2 | 4 | 82,334 | Values of timeseries | |
timeseries_units_view | 8 | 355 | |||
timeseries_values_view | 9 | 16,308 | This is a materialised view that organises the timeseries into separate columns. | ||
tsmetrics | 2 | 6 | 151 | Definition of tiemseries such as recruits, spawning stock biomass, total abundance, etc. | |
tsrelative_explicit_view | 7 | 28,977 | |||
25 Tables | 161 | 140,685 | |||
0 Views | 0 |