species

1483 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
species_id int8 19 null
predator.species_id predator_species_id_fkeyR
prey.species_id prey_species_id_fkeyR
sample.species_id sample_species_id_fkeyR

Numeric ID for this entry

name varchar 1024 null
species.t_group species_t_group_fkeyR

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

t_group varchar 1024 null
species.name species_t_group_fkeyR

Value grouping (short name)

description varchar 1024 null

Long description

Indexes

Constraint Name Type Sort Column(s)
species_pkey Primary key Asc species_id
species_name_key Must be unique Asc name

Relationships