species_problems

0 rows


Description

Problems found in species data. Rows are deleted from this table when the problem is marked as ignored by the user or the user accepts the suggested fix.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
species_id int8 19 null
species.id species_problems_species_id_fkeyC
field_id int4 10 null
species_problem_fields.id species_problems_field_id_fkeyR
type_id int4 10 null
species_problem_types.id species_problems_type_id_fkeyR
created_time timestamptz 35,6 null
suggested_value text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
species_problems_pkey Primary key Asc id
species_problems_species_id_idx Performance Asc species_id

Check Constraints

Constraint Name Constraint
species_problems_suggested_value_check ((suggested_value !~ similar_to_escape(' *'::text)))

Relationships

Close relationships within degrees of separation