port

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
port_id int4 10 null
trip.end_port_id trip_end_port_id_fkeyR
trip.start_port_id trip_start_port_id_fkeyR

Numeric ID for this entry
name varchar 1024 null
port.t_group port_t_group_fkeyR

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

Value grouping (short name)
latitude float4 8,8 √ null

Latitude
longitude float4 8,8 √ null

Longitude
institute_id int4 10 √ null
institute.institute_id port_institute_id_fkeyR

Institute (or country) responsible for port

Indexes

Constraint Name Type Sort Column(s)
port_pkey Primary key Asc port_id
port_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation