Species

idname
1Oak
2Apple
3Cherry
4Peach
5Plum

Agroforestry_Systems

idsystem_namedescription
1SilvopastureA system where trees, livestock, and forages coexist.
2Alley CroppingTrees are planted alongside crops to provide shade and reduce erosion.
3Forest GardeningA diverse, multi-layered plant community based on woodland ecosystems.
4Riparian BufferStrips of vegetation along waterways to filter runoff.
5WindbreakRows of trees used to block wind.

Farms

idfarm_namelocation
1Sunny Acres123 Main St, Ruralville
2Green Pastures456 Elm St, Hometown
3Orchard Haven789 Oak Lane, Fruitful City
4Meadow View101 Pine St, Seedling County
5Timber Ridge202 Cedar Ave, Lumbertown

Farmers

idfirst_namelast_nameemail
1JohnDoejohn.doe@email.com
2JaneSmithjane.smith@email.com
3BobJohnsonbob.johnson@email.com
4EmilyWilliamsemily.williams@email.com
5TomBrowntom.brown@email.com

System_Species

agroforestry_system_idspecies_id
(→ Agroforestry_Systems.id)(→ Species.id)
11
21
31
41
51
54