ER diagram

Not all columns are included in the ER diagram. For a complete documentation of all columns, see table descriptions.

seedsINTidPKINTplant_idFKNOT NULLTEXTnameNOT NULLTEXTvarietyINTcreated_byNOT NULLplantsINTidPKTEXTunique_nameNOT NULLTEXT[]common_name_enTEXT[]common_name_deTEXTfamilyspatial_relationsINTplant1PKINTplant2PKSPATIAL_RELATION_TYPErelationNOT NULLtemporal_relationINTplant_earlierPKINTplant_laterPKINTmin_durationINTmax_durationTEMPORAL_RELATION_EFFECTeffectmapsINTidPKTEXTnameNOT NULLUUIDcreated_byNOT NULLGEOMETRYgeometryNOT NULLlayersUUIDidPKINTmap_idFKNOT NULLLAYER_TYPEtypeNOT NULLTEXTnameNOT NULLplantingsUUIDidPKUUIDlayer_idFKNOT NULLINTplant_idFKNOT NULLINTxNOT NULLINTyNOT NULLdrawingsUUIDidPKUUIDlayer_idFKNOT NULLDRAWING_SHAPE_TYPEshape_typeNOT NULLINTxNOT NULLINTyNOT NULLusersUUIDidPKTEXTcountryNOT NULLEXPERIENCEexperienceMEMBERSHIPmembershipguided_toursUUIDuser_idPKBOOLEANeditor_tour_completedNOT NULLblossomsTEXTtitlePKTEXTdescriptiongained_blossomsUUIDuser_idPKTEXTblossomFKNOT NULLbase_layer_imagesUUIDidPKUUIDlayer_idFKNOT NULLTEXTpathNOT NULLrelationsplant1plant2belongs toplanted ondrawn oncreated bygained bycompleted bybelongs to

Plants Table

For performance reasons, we decided to disable some unused columns in the plants table for now.

For more information, see: PR #644

The following columns are commented out for now:

  • genus: text
  • medicinal_uses: text
  • material_uses_and_functions: text
  • botanic: text
  • material_uses: text
  • soil_water_retention: soil_water_retention[]
  • environmental_tolerances: text[]
  • native_geographical_range: text
  • native_environment: text
  • flower_colour: text
  • flower_type: flower_type
  • plant_references: text[]
  • is_tree: boolean
  • nutrition_demand: nutrition_demand
  • article_last_modified_at: timestamp without time zone
  • diseases: text
  • germination_temperature: text
  • introduced_into: text
  • habitus: text
  • medicinal_parts: text
  • native_to: text
  • plants_for_a_future: text
  • plants_of_the_world_online_link: text
  • plants_of_the_world_online_link_synonym: text
  • pollination: text
  • propagation_transplanting_en: text
  • resistance: text
  • root_type: text
  • seed_planting_depth_en: text
  • seed_viability: text
  • slug: text
  • utility: text
  • when_to_plant_cuttings_en: text
  • when_to_plant_division_en: text
  • when_to_plant_transplant_en: text
  • when_to_sow_indoors_en: text
  • sowing_outdoors_en: text
  • when_to_start_indoors_weeks: text
  • when_to_start_outdoors_weeks: text
  • cold_stratification_temperature: text
  • cold_stratification_time: text
  • days_to_harvest: text
  • habitat: text
  • spacing_en: text
  • wikipedia_url: text
  • days_to_maturity: text
  • pests: text
  • germination_time: text
  • description: text
  • parent_id: text
  • external_id: text
  • external_url: text
  • root_depth: text
  • external_article_number: text
  • external_portion_content: text
  • sowing_outdoors_de: text
  • spacing_de: text
  • required_quantity_of_seeds_de: text
  • required_quantity_of_seeds_en: text
  • seed_planting_depth_de: text
  • seed_weight_1000_de: text
  • seed_weight_1000_en: text
  • machine_cultivation_possible: boolean
  • edible_uses_de: text