planting_season_species_targets

-1 rows


Description

Target quantities of each species to plant in each substratum for a planting season.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
planting_season_id int8 19 null
planting_seasons.id planting_season_species_targets_planting_season_id_fkey C
substratum_id int8 19 null
substrata.id planting_season_species_targets_substratum_id_fkey C
species_id int8 19 null
species.id planting_season_species_targets_species_id_fkey C
quantity int4 10 null
created_by int8 19 null
users.id planting_season_species_targets_created_by_fkey R
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id planting_season_species_targets_modified_by_fkey R
modified_time timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
planting_season_species_targets_pkey Primary key Asc/Asc/Asc planting_season_id + substratum_id + species_id
planting_season_species_targets_species_id_idx Performance Asc species_id
planting_season_species_targets_substratum_id_idx Performance Asc substratum_id

Check Constraints

Constraint Name Constraint
planting_season_species_targets_quantity_check (quantity >= 0)

Relationships

Close relationships within degrees of separation