participant_project_species

0 rows


Description

Species that are associated to a participant project

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
project_id int8 19 √ null
projects.id participant_project_species_project_id_fkeyC
species_id int8 19 √ null
species.id participant_project_species_species_id_fkeyC
submission_status_id int4 10 null
submission_statuses.id participant_project_species_submission_status_id_fkeyR
feedback text 2147483647 √ null
rationale text 2147483647 √ null
created_by int8 19 √ null
users.id participant_project_species_created_by_fkeyR
modified_by int8 19 √ null
users.id participant_project_species_modified_by_fkeyR
created_time timestamptz 35,6 null
modified_time timestamptz 35,6 null
internal_comment text 2147483647 √ null
species_native_category_id int4 10 √ null
species_native_categories.id participant_project_species_species_native_category_id_fkeyR

Indexes

Constraint Name Type Sort Column(s)
participant_project_species_pkey Primary key Asc id
participant_project_species_project_id_species_id_key Must be unique Asc/Asc project_id + species_id
participant_project_species_species_id_idx Performance Asc species_id

Relationships

Close relationships within degrees of separation