vessel_type

21 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
vessel_type_id int4 10 null
vessel.vessel_type_id vessel_vessel_type_id_fkeyR

Numeric ID for this entry
name varchar 1024 null
vessel_type.t_group vessel_type_t_group_fkeyR

Short name used in data files / output data (in ltree notation)
t_group varchar 1024 √ null
vessel_type.name vessel_type_t_group_fkeyR

Value grouping (short name)
description varchar 1024 √ null

Long description

Indexes

Constraint Name Type Sort Column(s)
vessel_type_pkey Primary key Asc vessel_type_id
vessel_type_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation