planting_seasons

-1 rows


Description

Named planting seasons for planting sites, with start and end dates.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
withdrawals.planting_season_id withdrawals_planting_season_id_fkey N
planting_season_allocated_species.planting_season_id planting_season_allocated_species_planting_season_id_fkey C
planting_season_species_targets.planting_season_id planting_season_species_targets_planting_season_id_fkey C
scheduled_planting_dates.planting_season_id scheduled_planting_dates_planting_season_id_fkey C
planting_site_id int8 19 null
planting_sites.id planting_seasons_planting_site_id_fkey1 C
name text 2147483647 null
start_date date 13 null
end_date date 13 null
status_id int4 10 null
planting_season_statuses.id planting_seasons_status_id_fkey R
created_by int8 19 null
users.id planting_seasons_created_by_fkey R
created_time timestamptz 35,6 null
modified_by int8 19 null
users.id planting_seasons_modified_by_fkey R
modified_time timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
planting_seasons_pkey Primary key Asc id
planting_seasons_planting_site_id_idx Performance Asc planting_site_id
planting_seasons_planting_site_id_name_key Must be unique Asc/Asc planting_site_id + name

Check Constraints

Constraint Name Constraint
planting_seasons_check (end_date >= start_date)

Relationships

Close relationships within degrees of separation