Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| isscfg | varchar | 10 | null |
|
|
gear code per FAO’s International Standard Statistical Classification of Fishing Gear (ISSCFG; http://www.fao.org/3/a-bt987e.pdf); if a gear type was not recognized by FAO, then the code refers to a SFP internal code. E.g., ‘SFP-18’ for Mechanized lines |
||||||||||||||||||||||||
| group_isscfg | varchar | 10 | √ | null |
|
|
gear code adopted by FAO; if a gear type was not recognized by FAO, then the code refers to a SFP internal code. http://www.fao.org/3/a-bt987e.pdf |
|||||||||||||||||||||||
| name | text | 2147483647 | null |
|
|
fishing gear name according to FAO’s ISSCFG classification |
||||||||||||||||||||||||
| abbreviation | varchar | 5 | null |
|
|
gear abbreviation per FAO’s ISSCFG; if a gear type was not recognized by FAO, then the abbreviation refers to a SFP internal code. http://www.fao.org/3/a-bt987e.pdf |
||||||||||||||||||||||||
| created_at | timestamp | 29,6 | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gears_pkey | Primary key | Asc | isscfg |