Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| fip_uuid | varchar | 36 | null |
|
|
unique identifier of the FIP from SFP systems |
||
| stage_number | int4 | 10 | null |
|
|
an integer score (1-6) developed to show whether improvement efforts are producing in water results; Stage 1 is FIP Development (these are called pre-FIPs), Stage 2 is FIP Launch (the first rating for a formal FIP), Stage 3 is FIP Implementation, Stage 4 is Improvements in Fishing Practices and Fishery Management, Stage 5 is Improvements on the Water, Stage 6 is Certification (MSC, MarinTrust, CSC RFM). https://www.fishsource.org/improvement-project; https://www.fishsource.org/faq; http://solutionsforseafood.org/wp-content/uploads/2015/03/Alliance-FIP-Guidelines-3.7.15.pdf |
||
| date_stage | date | 13 | null |
|
|
Date (in YYYY-MM-DD format) a given stage was first achieved. https://www.fishsource.org/improvement-project. In some cases, the date a stage was achieved might be prior to the formal FIP start date; this is due to the time it takes for a FIP to publicly launch. In these cases (only 2), the number of months to stage 3 were not considered in the “Average number of months to stage 3” analysis and visual in the Tableau dashboard. In 2023, the data in this field for stage 2 was revised to fix a previous glitch in the database. |
||
| created_at | timestamp | 29,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fips_stages_pkey | Primary key | Asc/Asc | fip_uuid + stage_number |
Diagram producer might be missing
No diagrams were produced please see application output for any errors