tow

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tow_id int4 10 null
predator.tow_id predator_tow_id_fkeyR
sample.tow_id sample_tow_id_fkeyR

Numeric ID for this entry

name varchar 1024 null
tow.t_group tow_t_group_fkeyR

Short name used in data files / output data (in ltree notation)

t_group varchar 1024 null
tow.name tow_t_group_fkeyR

Value grouping (short name)

latitude float4 8,8 null

Latutide of sample

longitude float4 8,8 null

Longitude of sample

end_latitude float4 8,8 null

Latutide of sample end

end_longitude float4 8,8 null

Longitude of sample end

start timestamptz 35,6 null

Time tow started

depth float4 8,8 null

Tow depth (m)

length float4 8,8 null

Tow length (m)

duration float4 8,8 null

Tow duration (hours)

hook_count int4 10 null

Hook count (e.g. for long lines)

bait_type_id int4 10 null
bait_type.bait_type_id tow_bait_type_id_fkeyR

Bait type used (e.g. for long lines)

net_count int4 10 null

Number of nets used (e.g. for gillnets)

net_type_id int4 10 null
net_type.net_type_id tow_net_type_id_fkeyR

Net type used (e.g. for gillnets)

mesh_size float4 8,8 null

Mesh size (mm) (e.g. for gillnets)

Indexes

Constraint Name Type Sort Column(s)
tow_pkey Primary key Asc tow_id
tow_name_key Must be unique Asc name

Relationships