scheduled_planting_date_species

-1 rows


Description

Species and substratum quantities planned for a scheduled planting date.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
scheduled_planting_date_id int8 19 null
scheduled_planting_dates.id scheduled_planting_date_species_scheduled_planting_date_id_fkey C
substratum_id int8 19 null
substrata.id scheduled_planting_date_species_substratum_id_fkey C
species_id int8 19 null
species.id scheduled_planting_date_species_species_id_fkey C
quantity int4 10 null

Indexes

Constraint Name Type Sort Column(s)
scheduled_planting_date_species_pkey Primary key Asc/Asc/Asc scheduled_planting_date_id + substratum_id + species_id
scheduled_planting_date_species_species_id_idx Performance Asc species_id
scheduled_planting_date_species_substratum_id_idx Performance Asc substratum_id

Check Constraints

Constraint Name Constraint
scheduled_planting_date_species_quantity_check (quantity >= 0)

Relationships

Close relationships within degrees of separation