participant_project_species

-1 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_fkey C
species_id int8 19 √ null
species.id participant_project_species_species_id_fkey C
submission_status_id int4 10 null
submission_statuses.id participant_project_species_submission_status_id_fkey R
feedback text 2147483647 √ null
rationale text 2147483647 √ null
created_by int8 19 √ null
users.id participant_project_species_created_by_fkey R
modified_by int8 19 √ null
users.id participant_project_species_modified_by_fkey R
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_fkey R

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