## Species

id | name
--- | ---
1 | Oak
2 | Apple
3 | Cherry
4 | Peach
5 | Plum

## Agroforestry_Systems

id | system_name | description
--- | --- | ---
1 | Silvopasture | A system where trees, livestock, and forages coexist.
2 | Alley Cropping | Trees are planted alongside crops to provide shade and reduce erosion.
3 | Forest Gardening | A diverse, multi-layered plant community based on woodland ecosystems.
4 | Riparian Buffer | Strips of vegetation along waterways to filter runoff.
5 | Windbreak | Rows of trees used to block wind.

## Farms

id | farm_name | location
--- | --- | ---
1 | Sunny Acres | 123 Main St, Ruralville
2 | Green Pastures | 456 Elm St, Hometown
3 | Orchard Haven | 789 Oak Lane, Fruitful City
4 | Meadow View | 101 Pine St, Seedling County
5 | Timber Ridge | 202 Cedar Ave, Lumbertown

## Farmers

id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Doe | john.doe@email.com
2 | Jane | Smith | jane.smith@email.com
3 | Bob | Johnson | bob.johnson@email.com
4 | Emily | Williams | emily.williams@email.com
5 | Tom | Brown | tom.brown@email.com

## System_Species

agroforestry_system_id | species_id
--- | ---
(→ Agroforestry_Systems.id) | (→ Species.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 4