Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null |
|
|
unique identifier of the species/taxa per SFP systems |
||||
| fao_name | varchar | 2147483647 | √ | null |
|
|
Standard common name of the species (in English, as listed by FAO). Scientific names associated with the common names are available in the ASFIS list. http://www.fao.org/fishery/collection/asfis/en; http://www.marinespecies.org/index.php; http://www.fishbase.org/search.php; http://www.sealifebase.org/search.php |
|||
| type | varchar | 2147483647 | null |
|
|
2 possible choices which indicate the number of species in the FAO assigned name (1) single species where lowest taxa refers to a single species (2) multiple species when FAO names refers to a group containing multiple species (eg snappers nei) |
||||
| genus | varchar | 2147483647 | √ | null |
|
|
Latin genus name of the species as recorded in FishSource.org. http://www.fao.org/fishery/collection/asfis/en; http://www.marinespecies.org/index.php; http://www.fishbase.org/search.php; http://www.sealifebase.org/search.php |
|||
| specific_descriptor | varchar | 2147483647 | √ | null |
|
|
specific descriptor of the species as recorded in FishSource.org. http://www.fao.org/fishery/collection/asfis/en; http://www.marinespecies.org/index.php; http://www.fishbase.org/search.php; http://www.sealifebase.org/search.php |
|||
| common_names | varchar | 2147483647 | √ | null |
|
|
common name of the species as recorded in FishSource.org; can include local names. http://www.fao.org/fishery/collection/asfis/en; http://www.marinespecies.org/index.php; http://www.fishbase.org/search.php; http://www.sealifebase.org/search.php |
|||
| family | varchar | 2147483647 | √ | null |
|
|
Latin family name of the species as recorded in FishSource.org. http://www.fao.org/fishery/collection/asfis/en; http://www.marinespecies.org/index.php; http://www.fishbase.org/search.php; http://www.sealifebase.org/search.php |
|||
| fao_isscaap_group | varchar | 2147483647 | √ | null |
|
|
FAO ISSCAP group as recorded in FishSource.org. http://www.fao.org/fishery/collection/asfis/en; http://www.marinespecies.org/index.php; http://www.fishbase.org/search.php; http://www.sealifebase.org/search.php |
|||
| code_3a | varchar | 3 | √ | null |
|
|
FAO Species code per the ASFIS list. http://www.fao.org/fishery/collection/asfis/en |
|||
| taxocode | varchar | 2147483647 | √ | null |
|
|
||||
| created_at | timestamp | 29,6 | √ | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| species_pkey | Primary key | Asc | id |