system_owners

0 rows


Description

Entity responsible for definition, publication and upkeep of areas system standard.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
name_english varchar 2147483647 null

Official or directly translated name of the system owner in English
name_localized jsonb 2147483647 √ null

Official name or names of the system owner in other languages and respective locale. Country name and species name should be included only if in local name.
E.g. {fr: Commission Internationale pour la Conservation des Thonidés de l’Atlantique, es:Comisión Internacional para la Conservación del Atún Atlántico}
code varchar 2147483647 null
areas.code Implied ConstraintR
system_types.code Implied ConstraintR
systems.code Implied ConstraintR
systems.system_owner_code systems_system_owner_code_fkeyR

Abbreviation of system owner name. If one is in use in local language this is the preferred one to use. If one is in use in English this would be next choice. If none is known, create from local name.
E.g. CTMFM
code_localized jsonb 2147483647 √ null

All official known abbreviations of system owner name and respective locale.
E.g. {en: ICCAT, fr: CICTA, es:CICAA}
code_official bool 1 null
multinational bool 1 null
country varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
system_owners_pkey Primary key Asc code

Relationships

Close relationships within degrees of separation