planting_season_allocated_species

-1 rows


Description

Quantities of each species allocated 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_allocated_species_planting_season_id_fkey C
species_id int8 19 null
species.id planting_season_allocated_species_species_id_fkey C
quantity int4 10 null
created_by int8 19 null
users.id planting_season_allocated_species_created_by_fkey R
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id planting_season_allocated_species_modified_by_fkey R
modified_time timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
planting_season_allocated_species_pkey Primary key Asc/Asc planting_season_id + species_id
planting_season_allocated_species_species_id_idx Performance Asc species_id

Check Constraints

Constraint Name Constraint
planting_season_allocated_species_quantity_check (quantity > 0)

Relationships

Close relationships within degrees of separation