Column name | Example | Initial rule | Description |
id | 1 | | |
binomial_name | Abelia triflora | | |
common_name | NULL | | |
common_name_de | NULL | | |
family | Caprifoliaceae | | |
subfamily | NULL | | |
genus | Abelia | | |
edible_uses | NULL | | |
medicinal_uses | NULL | | |
material_uses_and_functions | [1][2] | | |
botanic | [3][6] | | |
propagation | NULL | | |
cultivation | NULL | | |
environment | NULL | | |
material_uses | NULL | | |
functions | NULL | | |
provides_forage_for | NULL | | |
provides_shelter_for | NULL | | |
hardiness_zone | 6 | | |
heat_zone | NULL | | |
water | moderate | | |
sun | full sun | | |
shade | light shade | | |
soil_ph | {neutral,alkaline,very alkaline} | | |
soil_texture | {sandy,loamy} | | |
soil_water_retention | NULL | | |
environmental_tolerances | NULL | | |
native_climate_zones | NULL | | |
adapted_climate_zones | NULL | | |
native_geographical_range | NULL | | |
native_environment | NULL | | |
ecosystem_niche | NULL | | |
root_zone_tendancy | NULL | | |
deciduous_or_evergreen | deciduous | | |
herbaceous_or_woody | woody | | |
life_cycle | {perennial} | | |
growth_rate | slow | | |
mature_size_height | 3.5 | | |
mature_size_width | 3 | | |
fertility | NULL | | |
pollinators | NULL | | |
flower_colour | NULL | | |
flower_type | hermaphrodite | | |
created_at | 2023-02-09 14:06:01.451028 | | |
updated_at | 2023-02-09 14:06:01.451028 | | |
has_drought_tolerance | false | | |
tolerates_wind | false | | |
plant_references | {ref1, ref2)} | | |
is_tree | true | Set of Herbaceous/Woody (woody) AND life cycle (perennial) | |
nutrition_demand | NULL | If "Nutritionally poor soil" in environmental_tolerances is given light feeder should be set. | |
preferable_permaculture_zone | NULL | | -1..6 (-1 should be printed as 00) |
Store relations between plants.
Column name | Example | Description |
plant1 | 1 | id of first plant |
plant2 | 2 | id of second plant |
relation | neutral | type of relation |
note | why put two cherries together anyways | some comment about the relation |
Column name | Example | Description |
id | 1 | |
created_by | 1 | |
name | My Map | only alphanumerical values |
is_inactive | false | |
last_visit | 2023-04-04 | |
honors | 0 | 0 to infinity |
visits | 0 | 0 to infinity |
harvested | 0 | 0 to infinity, amount of plants harvested on this map |
version_date | 2023-04-04 | the date the snapshot for this version was taken |
created_at | 2023-04-04 | |
deletion_date | 2023-04-04 | |
inactivity_date | 2023-04-04 | |
zoom_factor | 100 | value used in formula "X by X cm", e.g. 100 would mean "100 x 100 cm", range from 10 to 100000 |
geo_data | NULL | PostGis Geodata, location of the map |
Column name | Example | Description |
id | 1 | |
map_id | 1 | the id of the map |
type | {base, plants, etc.} | the type of layer |
name | Base Layer | the display name of the layer |
is_alternative | false | true if the layer is an user-created alternative layer |
Column name | Example | Description |
id | 1 | |
layer_id | 1 | the id of the layer |
plant_id | 1 | the plant that is planted |
x | 1 | the x coordinate of the position on the map. |
y | 1 | the y coordinate of the position on the map. |
width | 1 | the width of the plant on the map. |
height | 1 | the height of the plant on the map. |
rotation | 0 | the rotation of the plant on the map. |
scale_x | 1 | the x scale of the plant on the map. |
scale_y | 1 | the y scale of the plant on the map. |
Column name | Example | Description |
id | 00000000-0000-0000-0000-000000000000 | the UUID from Keycloak |
salutation | Mr | the preferred salutation of the user |
title | NULL | the title of the user |
country | Austria | the country of the user |
phone | NULL | the phone number of the user |
website | NULL | the website of the user |
organization | NULL | the organization of the user |
experience | beginner | the experience level of the user |
membership | Regular Membership | the membership type of the user |
member_years | {2023} | array of years |
member_since | 2023-07-12 | since when the user is a member |
permacoins | {0} | array of positive integers |
Column name | Example | Description |
user | 00000000-0000-0000-0000-000000000000 | the id of the user |
editor_tour | false | flag for the Map Editor Tour |
Column name | Example | Description |
title | Novice Gardener | |
description | Plant your first plant | |
track | Beginners Track | the track (category) this blossom belongs to |
icon | NULL | |
is_seasonal | false | resets and repeats every year |
Column name | Example | Description |
id | 1 | |
user_id | 1 | |
blossom_id | 1 | |
times_gained | 1 | 0 to infinity |
gained_date | {2023-04-10} | one entry for every time gained |
Column name | Example | Description |
id | 1 | list id |
created_by | 1 | user id |
map_id | 1 | id of the map this list is for |
name | Smoothie Ingredients | name of the list |
description | Ingredients for my strawberry smoothie | description of the list |
image | NULL | an image for further customizing the list |
is_recurring | true | a flag representing whether the objectives repeat themselves or not |
end_date | 2023-04-15 | an optional date at which point the owner wants the objectives to be fulfilled |
accomplished | 0 | the number of times the list was fulfilled; only relevant for recurring lists |
Many-to-many table to store relations between plants and ingredient lists.
Column name | Example | Description |
list_id | 1 | id of the ingredient list |
plant_id | 1 | id of the plant used as an ingredient |
is_fulfilled | true | if enough of this ingredient can be harvested |
Column name | Example | Description |
id | 1 | event id |
map_id | 1 | id of the map the event is taking place on |
system_event | true | a flag representing whether this event is system or user generated |
name | Harvest strawberries | name of the event |
description | NULL | description of the event details |
event_date | 2023-04-15 | the date the event is taking place on |
Many-to-many table to store map-specific favourites.
Column name | Example | Description |
map_id | 1 | id of the map |
plant_id | 1 | id of the plant |
Many-to-many table to store relations between plants, genus, subfamily and family.
Column name | Example | Description |
id | 1 | relation id |
from_id | 1 | id of the left side of the relation(id of plant, genus, subfamily or family) |
from_type | genus | type can be plant, genus, subfamily or family |
to_id | 1 | id of the right side of the relation(id of plant, genus, subfamily or family) |
to_type | family | type can be plant, genus, subfamily or family |
relation_type | companion | type of the relation can be companion, antagonist, neutral |
relation_strength | 2 | strength of the relation, can be 0 to 3 |
created_at | 2023-02-09 14:06:01.451028 | creation timestamp |
updated_at | 2023-02-09 14:06:01.451028 | update timestamp |