backend/model/

entity.rs

//! Contains all entities used in `PermaplanT`.

pub mod application_settings_impl;
pub mod areas;
pub mod areas_impl;
pub mod base_layer_images;
pub mod base_layer_images_impl;
pub mod drawing_properties;
pub mod drawing_properties_impl;
pub mod drawings;
pub mod drawings_impl;
pub mod guided_tour_impl;
pub mod layers;
pub mod layers_impl;
pub mod map_collaborator_impl;
pub mod map_impl;
pub mod plant_layer;
pub mod plantings;
pub mod plantings_impl;
pub mod plants_impl;
pub mod seed_impl;
pub mod timeline;

use chrono::NaiveDate;
use chrono::NaiveDateTime;

use diesel::AsChangeset;
use diesel::QueryableByName;
use diesel::{Identifiable, Insertable, Queryable};
use postgis_diesel::types::Point;
use postgis_diesel::types::Polygon;
use uuid::Uuid;

use crate::schema::{
    application_settings, guided_tour_progress, guided_tour_states, map_collaborators, maps,
    plants, seeds,
};

use super::r#enum::{
    herbaceous_or_woody::HerbaceousOrWoody, life_cycle::LifeCycle,
    light_requirement::LightRequirement, privacy_access_control::PrivacyAccessControl,
    quality::Quality, quantity::Quantity, shade::Shade, soil_texture::SoilTextureEnum,
    taxonomic_rank::TaxonomicRank, water_requirement::WaterRequirementEnum,
};

/// The `Plants` entity builds up an hierarchical structure, see `/doc/database/hierarchy.md`:
///
#[doc = include_str!("../../../doc/database/hierarchy.md")]
///
#[derive(Debug, Identifiable, Queryable, QueryableByName)]
#[diesel(table_name = plants)]
pub struct Plants {
    /// - The internal id of the plant.
    /// - *Fill ratio:* 100%
    pub id: i64,

    /// - The unique name of the plant.
    /// - The structure is described above (`doc/database/hierarchy.md`).
    /// - *Fill ratio:* 100%
    pub unique_name: String,

    /// - The list of the common names of the plant in English.
    /// - *Fetched from* `PracticalPlants` and Permapeople.
    /// - *Fill ratio:* 90%
    pub common_name_en: Option<Vec<Option<String>>>,

    /// - The list of the common names of the plant in German.
    /// - *Fetched from* Wikidata API if not present in any source datasets.
    /// - *Fill ratio:* 25%
    pub common_name_de: Option<Vec<Option<String>>>,

    // /// - The edible use of the plant, answering: Which food type can be produced from this plant, e.g. oil?
    // /// - Interesting for search functionality.
    // /// - *Fetched from* Permapeople as `edible_uses` and merged with Reinsaat.
    // /// - *Fill ratio:* 6%
    // pub edible_uses_en: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* PracticalPlants as `medicinal_uses` and merged with Permapeople.
    // /// - *Fill ratio:* 1%
    //pub medicinal_uses: Option<String>,

    // /// - Only for references.
    // /// - *Fetched from* PracticalPlants)
    // /// - *Fill ratio:* 34%
    // pub material_uses_and_functions: Option<String>,

    // /// - Only for references.
    // /// - *Fetched from* PracticalPlants)
    // /// - *Fill ratio:* 63%
    // pub botanic: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* PracticalPlants
    // /// - Plants are not only used for food but also for other uses, e.g. fiber to produce paper.
    // /// - *Fill ratio:* 1%
    // pub material_uses: Option<String>,
    //
    /// - *Used* for search ranking (diversity) and to be displayed in plant attributes.
    /// - ecological and environmental function of the plant, especially nitrogen fixer is relevant for `PermaplanT`.
    /// - *Fetched from* `PracticalPlants`)
    /// - *Fill ratio:* 13%
    pub functions: Option<String>,

    // /// - Not used.
    // /// - Use `hardiness_zone` instead.
    // /// - indication of the heat range a plant endures.
    // /// - *Fetched from* `PracticalPlants`.
    // /// - *Fill ratio:* 0.05%
    // pub heat_zone: Option<i16>,
    //
    /// - Shade tolerance of the plant, to be used together with `light_requirement`.
    /// - *Used* in shade layer.
    /// - *For example* a plant that has "no shade", should get a warning if placed in a shade.
    /// - No shade: full sun exposure
    /// - Light shade: moderately shaded throughout the day
    /// - Partial shade: about 3-6 hours of direct sunlight
    /// - Permanent shade: less than 3 hours of direct sunlight
    /// - Shade indicates the shade tolerance. Plants obviously grow better with better light conditions.
    /// - Warnings should only show if a plant is moved into a too dark spot.
    ///   No warning should be shown when moved into a lighter spot.
    /// - *Fetched from* `PracticalPlants`.
    /// - *Fill ratio:* 63%
    pub shade: Option<Shade>,

    // /// - Currently unused (maybe later used in pH layer).
    // /// - *See* explanation in `/doc/architecture/context.md`
    // /// - Soil PH can be tested by the user with simple means (e.g. litmus).
    // /// - *Fetched from* `PracticalPlants` and Permapeople (merged between Permapeople and `PracticalPlants`).
    // /// - *Fill ratio:* 1%
    // pub soil_ph: Option<Vec<Option<SoilPh>>>,
    //
    /// - *See* explanation in `/doc/architecture/context.md`
    /// - *Used* in soil layer.
    /// - *Fetched from* `PracticalPlants` and Permapeople (merged with `soil_type` of Permapeople).
    /// - *Fill ratio:* 88%
    pub soil_texture: Option<Vec<Option<SoilTextureEnum>>>,

    // /// - *NOT used* in hydrology layer
    // ///   as it has poor quality and no additional data compared to water_requirement
    // /// - *Fill ratio:* 37%
    // /// - *Fetched from* PracticalPlants
    // /// - wet = drowned, (often) flooded or in general very moist, e.g. swamp
    // /// - moist = humid, can hold some water, e.g. flat bed with humus
    // /// - well drained = dry, low capacity to hold water, e.g. sandhill.
    // pub soil_water_retention: Option<Vec<Option<SoilWaterRetention>>>,

    // /// - Only informational.
    // /// - *Fetched from* PracticalPlants
    // /// - gives information about environmental conditions, such as drought or wind tolerance
    // /// - *Fill ratio:* 15%
    //pub environmental_tolerances: Option<Vec<Option<String>>>,

    // /// - Not used.
    // /// - *Fetched from* PracticalPlants
    // /// - *Fill ratio:* 0.2%
    //pub native_geographical_range: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* `PracticalPlants`
    // /// - *Fill ratio:* 0.1%
    //pub native_environment: Option<String>,

    // /// - Interesting for search functionality.
    // /// - *Fetched from* `PracticalPlants`
    // /// - informs about the (vertical) layer, that the plant usually inhabits, e.g. soil surface or canopy
    // /// - *Fill ratio:* 16%
    // pub ecosystem_niche: Option<String>,

    // /// - Only informational.
    // /// - deciduous = plants loose leaves in winter.
    // /// - evergreen = Plants don't throw leaves (e.g. pine tree).
    // /// - Not applicable for annual plants.
    // /// - *Fetched from* `PracticalPlants` and merged with `leaves` of Permapeople.
    // /// - *Fill ratio:* 30%
    // pub deciduous_or_evergreen: Option<DeciduousOrEvergreen>,
    /// - *Used* Displayed in the plant attributes.
    /// - Only informational.
    /// - Fetched from `PracticalPlants`
    /// - informs about the plant physiology
    /// - woody = grows woody parts
    /// - herbaceous = doesn't grow wood, shoots remain soft/green.
    /// - *Fill ratio:* 26%
    pub herbaceous_or_woody: Option<HerbaceousOrWoody>,

    /// - Use in search and attribute
    /// - Determines life span of the plant.
    /// - *Fetched from* `PracticalPlants` and Permapeople (merged with `life_cycle` of Permapeople).
    /// - *Fill ratio:* 68%
    pub life_cycle: Option<Vec<Option<LifeCycle>>>,

    // /// - Only informational.
    // /// - *Fetched from* `PracticalPlants` and Permapeople (merged with `growth` of Permapeople).
    // /// - *Fill ratio:* 30%
    // pub growth_rate: Option<Vec<Option<GrowthRate>>>,
    //
    /// - Only informational, is in rw attribute
    /// - *Fetched from* `PracticalPlants` as `mature_size_height` and merged with Permapeople.
    /// - informs about the maximum height that the plant gains in cm
    /// - *Fill ratio:* 80%
    pub height: Option<i32>,

    // /// - Determines how large the plant can grow in diameter.
    // /// - Other plants should get a warning if planted within this area.
    // /// - *TODO:* replaced with spread, will keep this for now for information
    // /// - *Fetched from* `PracticalPlants` as `mature_size_width` and merged with Permapeople.
    // /// - *Fill ratio:* 22%
    //pub width: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* `PracticalPlants`
    // /// - *Fill ratio:* 18%
    // pub fertility: Option<Vec<Option<Fertility>>>,

    // /// - Only informational.
    // /// - *Fetched from* PracticalPlants
    // /// - *Fill ratio:* 0.5%
    //pub flower_colour: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* PracticalPlants
    // /// - a plant can contain flowers of two different sexes, male or female (monoecious), a plant can contain only flowers of one specific sex and therefore needs at least another plant of the other sex to reproduce (dioecious) or can contain flowers that have both the sexes within the same flower (hermaphrodite).
    // /// - *Fill ratio:* 62%
    // pub flower_type: Option<FlowerType>,
    /// - Is readonly in attribute
    /// - The creation date of the entry (actual time).
    /// - Only for administration.
    /// - *Fill ratio:* 100%
    pub created_at: NaiveDateTime,

    /// - Is readonly in attribute
    /// - The last update date of the entry (actual time).
    /// - Only for administration.
    /// - *Fill ratio:* 100%
    pub updated_at: NaiveDateTime,

    /// - *Used* so that an icon can be shown in the search results. Also displayed in the plant attributes.
    /// - Will be used in watering layer.
    /// - Fetched from `PracticalPlants` and merged with `has_drought_tolerance` of Permapeople.
    /// - *Fill ratio:* 57%
    pub has_drought_tolerance: Option<bool>,

    // /// - *Fetched from* `PracticalPlants`.
    // /// - *Fill ratio:* 10%
    // pub tolerates_wind: Option<bool>,

    // /// - The list of the references of the plant.
    // /// - `references` items link to these items.
    // /// - Only informational.
    // /// - *Fill ratio:* 58%
    // pub plant_references: Option<Vec<Option<String>>>,

    // /// - Boolean value indicating whether the plant is a tree.
    // /// - Plants with `is_tree == true` can be used in the tree layer.
    // /// - In plants layer all plants can be used.
    // /// - *Initial value* is to `True` if  herbaceous_or_woody (woody) and life_cycle (perennial)
    // /// - *Fill ratio:* 0.1%
    // pub is_tree: Option<bool>,

    // /// - Only informational.
    // /// - *Initial value* is to `light feeder` if "Nutritionally poor soil" in `environmental_tolerances` is present.
    // /// - *Fill ratio:* 0.04%
    // pub nutrition_demand: Option<NutritionDemand>,

    // /// - Not used.
    // /// - Number value between -1..6 (-1 should be printed as 00)
    // /// - *Fill ratio:* 0%
    // pub preferable_permaculture_zone: Option<i16>,

    // /// - When article was modified last time.
    // /// - Only for administration.
    // /// - Date value fetched from `PracticalPlants` page showing the last modification date of the plant.
    // /// - *Fill ratio:* 63%
    // pub article_last_modified_at: Option<NaiveDateTime>,
    //
    /// - *Used* To diplay an icon in the search results.
    /// - USDA Hardiness Zone (without subranges).
    /// - Important information.
    /// - Fetched from `PracticalPlants` and Permapeople (merged with `usda_hardiness_zone` of Permapeople).
    /// - *Fill ratio:* 63%
    pub hardiness_zone: Option<String>,

    /// - Shade tolerance of the plant, to be used together with shade.
    /// - *Used* in shade layer.
    /// - *For example* a plant that has "Full sun", should get a warning if placed in a shade.
    /// - **Fetched from*** `PracticalPlants` and Permapeople (merged with `sun` of `PracticalPlants`)
    /// - Full sun: full sun exposure
    /// - Partial sun/shade: about 3-6 hours of direct sunlight or moderately shaded throughout the day
    /// - Full shade: less than 3 hours of direct sunlight or almost no sunlight/no direct sunlight
    /// - *Fill ratio:* 88%
    pub light_requirement: Option<Vec<Option<LightRequirement>>>,

    /// - *Used* in hydrology layer.
    /// - *Fetched from* `PracticalPlants` and Permapeople (merged with `water` of `PracticalPlants`).
    /// - water = completely aquatic;
    /// - wet = drowned, (often) flooded or in general very moist, e.g. swamp;
    /// - moist = humid, regular water supply, e.g. flat bed with humus;
    /// - well drained = dry, little water input.
    /// - *Fill ratio:* 88%
    pub water_requirement: Option<Vec<Option<WaterRequirementEnum>>>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople (renamed from `propagation`)
    // /// - How to reproduce a plant: cuttings = cut pieces of wood; layering = let low branches reach the soil to root; Seed - direct sow = sow directly the seeds; division = split the rhizomes (roots) into pieces; Spores = plant reproduces via spores (e.g. ferns, funghi); seed - transplant = raise indoors from seed and transplant to outdoors later
    // /// - *Fill ratio:* 0.9%
    // pub propagation_method: Option<Vec<Option<PropagationMethod>>>,

    // /// - Only informational.
    // /// - May be used in search functionality (low priority).
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 35%
    // pub alternate_name: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.02%
    //pub diseases: Option<String>,
    //
    /// - *Used* so that an icon can be shown in the search results. Also displayed in the plant attributes.
    /// - Important information.
    /// - *Fetched from* Permapeople.
    /// - *Fill ratio:* 62%
    pub edible: Option<bool>,

    /// - Only informational.
    /// - *Used* Displayed in the plant attributes.
    /// - *Fetched from* Permapeople.
    /// - which organ of the plant can be eaten, e.g. root, leaves.
    /// - *Fill ratio:* 61%
    pub edible_parts: Option<Vec<Option<String>>>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - Reinsaat: `Keimtemperatur` should be copied to `germination_temperature`
    // /// - Germination means that all conditions are right for a seed to start growing. Temperature is one essential factor.
    // /// - *Fill ratio:* 2%
    //pub germination_temperature: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 36%
    //pub introduced_into: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople as \`layer\` and renamed.
    // /// - Habitus describes the shape of a plant.
    // /// - *Fill ratio:* 48%
    //pub habitus: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.1%
    //pub medicinal_parts: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 80%
    //pub native_to: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 86%
    //pub plants_for_a_future: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 86%
    //pub plants_of_the_world_online_link: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 15%
    //pub plants_of_the_world_online_link_synonym: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* PracticalPlants as `pollinators` and merged with `pollination` of Permapeople.
    // /// - Pollination is the process that the pollen (male part) gets united with the pistil (female part), e.g. via bees, wind.
    // /// - *Fill ratio:* 48%
    //pub pollination: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.1%
    //pub propagation_transplanting_en: Option<String>,

    // /// - Not used.
    // /// - Nearly empty.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.01%
    //pub resistance: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - Root type describes the shape of the roots.
    // /// - *Fill ratio:* 0.24%
    //pub root_type: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople as `seed_planting_depth` and renamed.
    // /// - Reinsaat: `Sowing depth` should be copied to `seed_planting_depth_en`
    // /// - When sowing each plant has a specific value how deep the seeds should be covered with soil.
    // /// - *Fill ratio:* 0.07%
    //pub seed_planting_depth_en: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - expected average life span (in years) of a seed of a certain specie.
    // /// - *Fill ratio:* 0.6%
    //pub seed_viability: Option<String>,

    // /// - Not used.
    // /// - The final part of the URL of the plant on the Permapeople website.
    // /// - This field can be potentially used to construct the `external_url` field traversing through all the parents given by `parent_id`.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 90%
    //pub slug: Option<String>,
    //
    /// - **Used**
    /// - How far a plant spreads (The 'width' of a plant) in cm
    /// - *Fetched from* Permapeople.
    /// - *Fill ratio:* 0.1%
    pub spread: Option<i32>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 2%
    //pub utility: Option<String>,
    //
    /// - *Used* so that an icon can be shown in the search results. Also displayed in the plant attributes.
    /// - Important information.
    /// - *Fetched from* Permapeople.
    /// - specific warnings for eather human, animal or environmental well-being, e.g. toxic, invasive.
    /// - *Fill ratio:* 8%
    pub warning: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.06%
    //pub when_to_plant_cuttings_en: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.07%
    //pub when_to_plant_division_en: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.2%
    //pub when_to_plant_transplant_en: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.23%
    //pub when_to_sow_indoors_en: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople as `when_to_sow_outdoors` and renamed.
    // /// - Reinsaat: `Sowing` or `Direct Sowing` or `Sowing outdoors` or `Sowing Direct Outdoors` should be copied to `sowing_outdoors_en`
    // /// - *Fill ratio:* 0.36%
    //pub sowing_outdoors_en: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.56%
    //pub when_to_start_indoors_weeks: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.12%
    //pub when_to_start_outdoors_weeks: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - Stratification is the process that a seed must go through to get triggered for germination, e.g. by a certain threshold of minus degrees.
    // /// - *Fill ratio:* 0.03%
    //pub cold_stratification_temperature: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - Suggested change
    // /// - *Fetched from* Permapeople.
    // /// - Stratification is the process that a seed must go through to get triggered for germination, e.g. by a certain amount of time under cold temperatures.
    // /// - *Fill ratio:* 0.05%
    //pub cold_stratification_time: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - Reinsaat: `1st harvest` should be copied to `days_to_harvest`
    // /// - *Fill ratio:* 0.1%
    //pub days_to_harvest: Option<String>,

    // /// - Needed for occupied space and in attributes
    // /// - *TODO:* should be number and then be used for calender
    //pub life_cycle_days: Option<int>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.2%
    //pub habitat: Option<String>,

    // /// - One number means it is spacing between plants and rows. Two numbers means first is spacing between plants, second between rows.
    // /// - Only informational.
    // /// - *Fetched from* Permapeople as `spacing` and from Reinsaat as `Distances` and renamed.
    // /// - Reinsaat: `Distances` or `Spacing` should be copied to `spacing_en`
    // /// - *Fill ratio:* 0.7%
    //pub spacing_en: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* Permapeople as `wikipedia` and renamed.
    // /// - *Fill ratio:* 47%
    //pub wikipedia_url: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.3%
    //pub days_to_maturity: Option<String>,

    // /// - Not used.
    // /// - Nearly empty.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 0.03%
    //pub pests: Option<String>,
    //
    /// - Only for administration.
    /// - The version of the entry.
    /// - To be incremented after every relevant change.
    /// - *Fetched from* Permapeople.
    /// - *Fill ratio:* 90%
    pub version: Option<i16>,

    // /// - Only informational.
    // /// - *Fetched from* Permapeople.
    // /// - Germination time describes the time (days, weeks, months) that a seed needs to germinate given the right conditions.
    // /// - *Fill ratio:* 0.5%
    //pub germination_time: Option<String>,

    // /// - Not used.
    // /// - The description of the entry.
    // /// - *Fetched from* Permapeople.
    // /// - *Fill ratio:* 5%
    //pub description: Option<String>,

    // /// - TODO: (not yet in database) add to attributes
    // /// - Short important information to shown.
    //pub info: Option<String>,

    // /// - Not used.
    // /// - *Fetched from* permapeople id of the parent entry pointing to the `external_id` column.
    // /// - *Fill ratio:* 2%
    //pub parent_id: Option<String>,

    // /// - Not used.
    // /// - Enum value indicating the source of the entry.
    // /// - *Fill ratio:* 100%
    // pub external_source: Option<ExternalSource>,

    // /// - Not used.
    // /// - The external id of the entry used in combination with the `external_source` column.
    // /// - *Fill ratio:* 90%
    //pub external_id: Option<String>,

    // /// - Not used.
    // /// - The external URL provided by the origin source.
    // /// - *Fill ratio:* 9%
    //pub external_url: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* PracticalPlants as `root_zone_tendency` and merged with root_depth of Permapeople.
    // /// - Root depth can be considered when planning polycultures, e.g. combining shallow roots with deep roots.
    // /// - *Fill ratio:* 0.2%
    //pub root_depth: Option<String>,

    // /// - Not used.
    // /// - The article number `Artikelnummer` of the plant in the Reinsaat database.
    // /// - *Fill ratio:* 7%
    //pub external_article_number: Option<String>,

    // /// - Not used.
    // /// - `Portionsinhalt` should be called `external_portion_content`
    // /// - *Fetched from* Reinsaat.
    // /// - *Fill ratio:* 7%
    //pub external_portion_content: Option<String>,

    // /// - Only informational.
    // /// - *Fetched from* Reinsaat as \`Direktsaat\` and renamed.
    // /// - `Direktsaat` or `Aussaat` should be called `sowing_outdoors_de`
    // /// - *Fill ratio:* 3%
    //pub sowing_outdoors_de: Option<String>,
    //
    /// - *Used* Displayed in the plant attributes.
    /// - String array of numbers representing a time period.
    /// - The year is divided into 24 periods of half a month each.
    /// - *For example* "\[8,9,10\]" means from the 2nd half of April to the 2nd half of May incl.
    /// - *Fetched from* Reinsaat
    /// - `Aussaat/ Pflanzung Freiland` should be called `sowing_outdoors`
    /// - *Fill ratio:* 5%
    pub sowing_outdoors: Option<Vec<Option<i16>>>,

    /// - *Used* Displayed in the plant attributes.
    /// - String array of numbers representing a time period.
    /// - The year is divided into 24 periods of half a month each.
    /// - *For example* "\[8,9,10\]" means from the 2nd half of April to the 2nd half of May incl.
    /// - `Ernte` should be called `harvest_time`
    /// - *Fetched from* Reinsaat
    /// - *Fill ratio:* 6%
    pub harvest_time: Option<Vec<Option<i16>>>,
    /*
    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - `Abstände` should be called `spacing_de`
    /// - *Fill ratio:* 4%
    //pub spacing_de: Option<String>,

    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - *Fill ratio:* 4%
    /// - `Saatgutbedarf` should be called `required_quantity_of_seeds_de`
    //pub required_quantity_of_seeds_de: Option<String>,

    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - `Required quantity of seeds` should be called `required_quantity_of_seeds_en`
    /// - *Fill ratio:* 3%
    //pub required_quantity_of_seeds_en: Option<String>,

    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - `Saattiefe` should be called `seed_planting_depth_de`
    /// - When sowing, each plant has a specific value how deep the seeds should be covered with soil.
    /// - *Fill ratio:* 5%
    //pub seed_planting_depth_de: Option<String>,

    /// - German version of thousand grain weight (German: Tausendkornmasse)
    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - Called `Tausendkornmasse` in Reinsaat
    /// - *Fill ratio:* 4%
    //pub seed_weight_1000_de: Option<String>,

    /// - English version of thousand grain weight (German: Tausendkornmasse)
    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - Called `Thousand seeds mass` in Reinsaat
    /// - *Fill ratio:* 3%
    //pub seed_weight_1000_en: Option<String>,

    /// - Number for thousand grain weight (German: Tausendkornmasse)
    /// - *Used* in `doc/usecases/buy_seeds.md` to calculate seed weight based on number of plants.
    /// - *Fetched from* Permapeople as `1000_seed_weight_g` and renamed.
    /// - *TODO:* merge with data from reinsaat: `Tausendkorngewicht (TKG)` should be copied to `seed_weight` (remove ` g`)
    /// - *Fill ratio:* 4%
    // pub seed_weight_1000: Option<f64>,

    /// - Only informational.
    /// - *Fetched from* Reinsaat.
    /// - `Suitable for professional cultivation` should be called `machine_cultivation_possible`
    /// - *Fill ratio:* 9%
    //pub machine_cultivation_possible: Option<bool>,

    /// - *Fetched from* Reinsaat.
    /// - *Used* for plant search and informational.
    /// - `subcategory` from Reinsaat should be copied to `edible_uses_de` and `edible_uses_en` respectively (DE and EN version)
    /// - *Fill ratio:* 6%
    //pub edible_uses_de: Option<String>,
    */
    /// - Hierarchy fields
    /// - Either *Fetched from* `PracticalPlants` and Permapeople
    /// - Or determined from the unique name
    /// - Or set by scraper overrides
    pub rank: TaxonomicRank,
    pub family: Option<i64>,
    pub genus: Option<i64>,
    pub species: Option<i64>,
    pub variety: Option<i64>,

    /// - The path to the icon of the plant.
    pub icon_path: Option<String>,
}
/// The `Seed` entity.
#[derive(Identifiable, Queryable)]
#[diesel(table_name = seeds)]
pub struct Seed {
    /// The record id of the seed.
    pub id: i64,
    /// An additional name for the seed.
    pub name: String,
    /// When the seeds were harvested.
    pub harvest_year: i16,
    /// When the seeds should be used by.
    pub use_by: Option<NaiveDate>,
    /// Where the seeds came from.
    pub origin: Option<String>,
    /// What the seeds taste like.
    pub taste: Option<String>,
    /// The yield of the seeds.
    pub yield_: Option<String>,
    /// How many seeds there are.
    pub quantity: Quantity,
    /// The quality of the seeds.
    pub quality: Option<Quality>,
    /// How much the seeds cost.
    pub price: Option<i16>,
    /// How many generations the seeds have been grown.
    pub generation: Option<i16>,
    /// Notes about the seeds.
    pub notes: Option<String>,
    /// The id of the plant this seed belongs to.
    pub plant_id: Option<i64>,
    /// The id of the creator of the seed.
    pub created_by: Uuid,
    /// Timestamp indicating when the seed was archived.
    /// Empty if the seed was not archived.
    pub archived_at: Option<NaiveDateTime>,
}

/// The `NewSeed` entity.
#[allow(clippy::missing_docs_in_private_items)] // TODO: See #97.
#[derive(Insertable)]
#[diesel(table_name = seeds)]
pub struct NewSeed {
    pub name: String,
    pub plant_id: Option<i64>,
    pub harvest_year: i16,
    pub use_by: Option<NaiveDate>,
    pub origin: Option<String>,
    pub taste: Option<String>,
    pub yield_: Option<String>,
    pub quantity: Quantity,
    pub quality: Option<Quality>,
    pub price: Option<i16>,
    pub generation: Option<i16>,
    pub notes: Option<String>,
    pub created_by: Uuid,
}

/// The `Map` entity.
#[derive(Identifiable, Queryable)]
#[diesel(table_name = maps)]
pub struct Map {
    /// The id of the map.
    pub id: i64,
    /// The name of the map.
    pub name: String,
    /// The date the map is supposed to be deleted.
    pub deletion_date: Option<NaiveDate>,
    /// The date the last time the map view was opened by any user.
    pub last_visit: Option<NaiveDate>,
    /// A flag indicating if this map is marked for deletion.
    pub is_inactive: bool,
    /// The zoom factor of the map.
    pub zoom_factor: i16,
    /// An enum indicating if this map is private or not.
    pub privacy: PrivacyAccessControl,
    /// The description of the map.
    pub description: Option<String>,
    /// The location of the map as a latitude/longitude point.
    pub location: Option<Point>,
    /// The id of the creator of the map.
    pub created_by: Uuid,
    /// The geometry of the map.
    pub geometry: Polygon<Point>,
    /// When the map was created.
    pub created_at: NaiveDateTime,
    /// When a map was last modified, e.g., by modifying plantings.
    pub modified_at: NaiveDateTime,
    /// By whom the map was last modified.
    pub modified_by: Uuid,
}

/// The `NewMap` entity.
#[derive(Insertable)]
#[diesel(table_name = maps)]
pub struct NewMap {
    /// The name of the map.
    pub name: String,
    /// For a new map the same as `created_by`.
    pub deletion_date: Option<NaiveDate>,
    /// The date the last time the map view was opened by any user.
    pub last_visit: Option<NaiveDate>,
    /// A flag indicating if this map is marked for deletion.
    pub is_inactive: bool,
    /// The zoom factor of the map.
    pub zoom_factor: i16,
    /// An enum indicating if this map is private or not.
    pub privacy: PrivacyAccessControl,
    /// The description of the map.
    pub description: Option<String>,
    /// The location of the map as a latitude/longitude point.
    pub location: Option<Point>,
    /// The id of the creator of the map.
    pub created_by: Uuid,
    /// The geometry of the map.
    pub geometry: Polygon<Point>,
    /// The user who last modified the planting.
    pub modified_by: Uuid,
}

/// The `UpdateMap` entity.
#[derive(AsChangeset)]
#[diesel(table_name = maps)]
pub struct UpdateMap {
    /// The name of the map.
    pub name: Option<String>,
    /// An enum indicating if this map is private or not.
    pub privacy: Option<PrivacyAccessControl>,
    /// The description of the map.
    pub description: Option<String>,
    /// The location of the map as a latitude/longitude point.
    pub location: Option<Point>,
}

/// The `UpdateMapGeometry` entity.
#[derive(AsChangeset)]
#[diesel(table_name = maps)]
pub struct UpdateMapGeometry {
    /// New Map Bounds
    pub geometry: Polygon<Point>,
}

/// The `GuidedTourProgress` entity.
#[derive(Identifiable, Queryable)]
#[diesel(primary_key(user_id, step_key), table_name = guided_tour_progress)]
pub struct GuidedTourProgress {
    /// ID of the user who completed the tour step
    pub user_id: Uuid,
    /// Human readable id of the step the user completed
    pub step_key: String,
    /// Time of completion
    pub completed_at: NaiveDateTime,
}

/// Insertable for `guided_tour_progress` (`completed_at` uses DB default).
#[derive(Insertable)]
#[diesel(table_name = guided_tour_progress)]
pub struct NewGuidedTourProgress {
    /// ID of the user who is completing the step
    pub user_id: Uuid,
    /// Human readable id of the step the user is completing
    pub step_key: String,
}

/// The `GuidedTourState` entity.
#[derive(Insertable, Identifiable, Queryable)]
#[diesel(primary_key(user_id), table_name = guided_tour_states)]
pub struct GuidedTourState {
    /// ID of the user
    pub user_id: Uuid,
    /// When the tour was paused
    pub paused_at: Option<NaiveDateTime>,
    /// How often the user has paused the tour already
    pub pause_count: i32,
}

/// The `ApplicationSetting` entity.
#[derive(Identifiable, Queryable)]
#[diesel(primary_key(id), table_name = application_settings)]
pub struct ApplicationSetting {
    /// The id of the setting
    pub id: i32,
    /// The unique key of the setting
    pub key: String,
    /// The value of the setting
    pub value: String,
}

/// The [`MapCollaborator`] entity.
#[derive(Insertable, Identifiable, Queryable)]
#[diesel(primary_key(map_id, user_id), table_name = map_collaborators)]
pub struct MapCollaborator {
    pub map_id: i64,
    pub user_id: Uuid,
    pub created_at: NaiveDateTime,
}