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 |