| id | name |
|---|---|
| 1 | Oak |
| 2 | Apple |
| 3 | Cherry |
| 4 | Peach |
| 5 | Plum |
| 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. |
| 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 |
| id | first_name | last_name | |
|---|---|---|---|
| 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 |
| agroforestry_system_id | species_id |
|---|---|
| (→ Agroforestry_Systems.id) | (→ Species.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |