1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907 908 909 910 911 912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941 942 943 944 945 946 947
//! Contains all entities used in `PermaplanT`.
pub mod base_layer_images;
pub mod base_layer_images_impl;
pub mod blossoms_impl;
pub mod drawings;
pub mod drawings_impl;
pub mod guided_tours_impl;
pub mod layers;
pub mod layers_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 shadings;
pub mod shadings_impl;
pub mod timeline;
pub mod users_impl;
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::{blossoms, gained_blossoms, guided_tours, maps, plants, seeds, users};
use super::r#enum::experience::Experience;
use super::r#enum::membership::Membership;
use super::r#enum::privacy_option::PrivacyOption;
use super::r#enum::salutation::Salutation;
use super::r#enum::track::Track;
use super::r#enum::{
deciduous_or_evergreen::DeciduousOrEvergreen, external_source::ExternalSource,
fertility::Fertility, /*flower_type::FlowerType, */ growth_rate::GrowthRate,
herbaceous_or_woody::HerbaceousOrWoody, life_cycle::LifeCycle,
light_requirement::LightRequirement, /*nutrition_demand::NutritionDemand,*/
propagation_method::PropagationMethod, quality::Quality, quantity::Quantity, shade::Shade,
soil_ph::SoilPh, soil_texture::SoilTexture, water_requirement::WaterRequirement,
};
/// 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: i32,
/// - 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>>>,
/// - Family of the plant.
/// - See `/doc/architecture/glossary.md`.
/// - *Used* to build up hierarchy.
/// - *Fetched from* PracticalPlants and Permapeople.
/// - *Fill ratio:* 88%
pub family: Option<String>,
/*
/// - Genus of the plant.
/// - Is also first word of unique_name, see above (`/doc/database/hierarchy.md`)
/// - *See also* `/doc/architecture/glossary.md`.
/// - *Used* to build up hierarchy.
/// - Genus is determined by botanical nomenclature. Sometimes gets changed due to modern insights through genetical research.
/// - *Fetched from* PracticalPlants and Permapeople.
/// - *TODO:* copy from first word of unique name.
/// - *Fill ratio:* 63%
pub genus: Option<String>,
*/
/// - TODO: comment out
/// - 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>,
*/
/// - TODO: use in search (and attribute)
/// - *Used* for search ranking (diversity).
/// - ecological and environmental function of the plant, especially nitrogen fixer is relevant for PermaplanT.
/// - *Fetched from* PracticalPlants)
/// - *Fill ratio:* 13%
pub functions: Option<String>,
/// - TODO: comment out
/// - 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
/// - Permanent deep shade: almost no sunlight/no 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>,
/// - TODO: comment out
/// - 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<SoilTexture>>>,
/*
/// - *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>,
*/
/// - TODO: comment out
/// - 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>,
/// - TODO: use in search (and attributes)
/// - 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>,
/// - TODO: use in attribute
/// - 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 attributes)
/// - 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>>>,
/// - TODO: comment out
/// - 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 attributes
/// - *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>,
*/
/// - TODO: comment out
/// - 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 attributes
/// - The creation date of the entry.
/// - Only for administration.
/// - *Fill ratio:* 100%
pub created_at: NaiveDateTime,
/// - Is readonly in attributes
/// - The last update date of the entry.
/// - Only for administration.
/// - *Fill ratio:* 100%
pub updated_at: NaiveDateTime,
/// - ! TODO: discuss with Lukas
/// - *Used* in watering layer.
/// - Fetched from PracticalPlants and merged with \`has_drought_tolerance\` of Permapeople.
/// - *Fill ratio:* 57%
pub has_drought_tolerance: Option<bool>,
/// - TODO: comment out
/// - *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>,
*/
/// - TODO: comment out
/// - 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>,
*/
/// - TODO: show in search
/// - 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<WaterRequirement>>>,
/// - TODO: comment out
/// - 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>>>,
/// - TODO: comment out
/// - 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>,
*/
/// - TODO: use in search (and as attribute)
/// - Important information.
/// - *Fetched from* Permapeople.
/// - *Fill ratio:* 62%
pub edible: Option<bool>,
/// - TODO: use as attribute (translation in frontend)
/// - Only informational.
/// - *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.
/// - *TODO:* ovlerap with `functions`.
/// - *Fetched from* Permapeople.
/// - *Fill ratio:* 2%
//pub utility: Option<String>,
*/
/// - TODO: use in search (and as attribute)
/// - 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.
/// - *TODO:* ask how to interpret.
/// - *Fetched from* Permapeople.
/// - *Fill ratio:* 0.56%
//pub when_to_start_indoors_weeks: Option<String>,
/// - Only informational.
/// - *TODO:* ask how to interpret.
/// - *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.
/// - *TODO:* should be number and then be used for calender
/// - *Fetched from* Permapeople.
/// - Reinsaat: `1st harvest` should be copied to `days_to_harvest`
/// - *Fill ratio:* 0.1%
//pub days_to_harvest: Option<String>,
/// - 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>,
*/
/// - TODO: discuss with Andrei
/// - 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.
/// - *TODO:* must be renamed to `description_en` and translation needed.
/// - The description of the entry.
/// - *Fetched from* Permapeople.
/// - *Fill ratio:* 5%
//pub description: 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>,
*/
/// - TODO: comment out
/// - 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>,
*/
/// - TODO: use as attribute
/// - 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>>>,
/// - TODO: use as attribute
/// - 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>,
*/
/// - TODO: comment out
/// - 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>,
*/
}
/// The `Seed` entity.
#[derive(Identifiable, Queryable)]
#[diesel(table_name = seeds)]
pub struct Seed {
/// The record id of the seed.
pub id: i32,
/// 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<i32>,
/// 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<i32>,
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: i32,
/// 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,
/// The amount of honors the map received.
pub honors: i16,
/// The amount of visits the map had.
pub visits: i16,
/// The amount of plants harvested on the map.
pub harvested: i16,
/// An enum indicating if this map is private or not.
pub privacy: PrivacyOption,
/// 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,
/// The amount of honors the map received.
pub honors: i16,
/// The amount of visits the map had.
pub visits: i16,
/// The amount of plants harvested on the map.
pub harvested: i16,
/// An enum indicating if this map is private or not.
pub privacy: PrivacyOption,
/// 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<PrivacyOption>,
/// 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 `Users` entity.
#[derive(Insertable, Identifiable, Queryable)]
#[diesel(table_name = users)]
pub struct Users {
/// The id of the user from Keycloak.
pub id: Uuid,
/// The preferred salutation of the user.
pub salutation: Salutation,
/// The title(s) of the user.
pub title: Option<String>,
/// The current country of the user.
pub country: String,
/// The phone number of the user.
pub phone: Option<String>,
/// The website of the user.
pub website: Option<String>,
/// The organization the user belongs to.
pub organization: Option<String>,
/// The experience level in permaculture of the user.
pub experience: Option<Experience>,
/// The membership type of the user.
pub membership: Option<Membership>,
/// A collection of years in which the user was a member.
pub member_years: Option<Vec<Option<i32>>>,
/// The date since when the user is a member.
pub member_since: Option<NaiveDate>,
/// The amount of permacoins the user earned in each year as a member.
pub permacoins: Option<Vec<Option<i32>>>,
}
/// The `GuidedTours` entity.
#[derive(Insertable, Identifiable, Queryable)]
#[diesel(primary_key(user_id), table_name = guided_tours)]
pub struct GuidedTours {
/// The id of the user from Keycloak.
pub user_id: Uuid,
/// A flag indicating if the Map Editor Guided Tour was completed.
pub editor_tour_completed: bool,
}
/// The `UpdateGuidedTours` entity.
#[derive(AsChangeset)]
#[diesel(table_name = guided_tours)]
pub struct UpdateGuidedTours {
/// A flag indicating if the Map Editor Guided Tour was completed.
pub editor_tour_completed: Option<bool>,
}
/// The `Blossom` entity.
#[derive(Identifiable, Queryable)]
#[diesel(primary_key(title), table_name = blossoms)]
pub struct Blossom {
/// The title of the Blossom.
pub title: String,
/// The description of the Blossom.
pub description: Option<String>,
/// The track the Blossom is part of.
pub track: Track,
/// The path to the icon of the Blossom in Nextcloud.
pub icon: String,
/// A flag indicating if this Blossom is repeatable every season.
pub is_seasonal: bool,
}
/// The `GainedBlossoms` entity.
#[derive(Insertable, Identifiable, Queryable)]
#[diesel(primary_key(user_id, blossom), table_name = gained_blossoms)]
pub struct GainedBlossoms {
/// The id of the user from Keycloak.
pub user_id: Uuid,
/// The title of the Blossom.
pub blossom: String,
/// The number of times this Blossom was gained by this user.
pub times_gained: i32,
/// The date on which the user gained this Blossom.
pub gained_date: NaiveDate,
}