gear

147 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
gear_id int4 10 null
predator.gear_id predator_gear_id_fkeyR
sample.gear_id sample_gear_id_fkeyR

Numeric ID for this entry

name varchar 1024 null
gear.t_group gear_t_group_fkeyR

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

t_group varchar 1024 null
gear.name gear_t_group_fkeyR

Value grouping (short name)

description varchar 1024 null

Long description

mesh_size float4 8,8 null

Mesh size (mm)

mesh_size_min float4 8,8 null

Minimum mesh size (mm)

mesh_size_max float4 8,8 null

Maximum mesh size (mm)

Indexes

Constraint Name Type Sort Column(s)
gear_pkey Primary key Asc gear_id
gear_name_key Must be unique Asc name

Relationships