Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
unique identifier of the MSC fishery per SFP systems |
||
| name | varchar | 255 | null |
|
|
name of the MSC fishery. https://www.msc.org/ |
||
| status | varchar | 40 | null |
|
|
5 possible categories that indicate the status of the fishery the last time it was updated in the FishSource Database (1) MSC Certified (2) MSC Full Assessment (3) MSC Recertified (4) Not certified (5) withdrawn. https://www.msc.org/ |
||
| url | text | 2147483647 | null |
|
|
webpage of the MSC fishery. https://www.msc.org/ |
||
| certification_date | date | 13 | √ | null |
|
|
certification date (in YYYY-MM-DD format) of the MSC fishery. https://www.msc.org/ |
|
| db_version_year | int4 | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| mscs_pkey | Primary key | Asc/Asc | id + db_version_year |
Diagram producer might be missing
No diagrams were produced please see application output for any errors