system_types

0 rows


Description

System type as defined by the system owner. Multiple systems may share the same system type. For example, the New Zealand Hake Quota Management Area is the system type Quota Management Area.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
systems.system_type_id systems_system_type_id_fkeyR
type varchar 2147483647 null

System type as defined by the system owner.
E.g., the New Zealand Hake Quota Management Area is the system type Quota Management Area.

code varchar 2147483647 null
system_owners.code Implied ConstraintR

Code as defined by the system owner.
E.g., the New Zealand Hake Quota Management Area is the system type code QMA.

Indexes

Constraint Name Type Sort Column(s)
system_types_pkey Primary key Asc id
system_types_type_key Must be unique Asc type

Relationships