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

Close relationships within degrees of separation