These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Farm Management System
- Data model
The tables behind Farm Management System
Farm Management System ships with 11 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 11
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Field identity
Fields anchor field boundaries, field observations, input applications and crop cycles.
Work
Field tasks connects a Fields record, a crop cycles record and an assigned People record.
Consumption
Input usage connects field tasks with input stocks.
Harvest
Harvests links measured yield and its reviewer to crop cycles.
Access
People links the named actor to Users.
Every table, by feature
- Fields and boundaries2
- Crop cycles3
- Field work5
- Input stocks and usage3
- Harvest records3
- Observations and applications4
- Shared and settings1
- Fields
Farm fields and plots with area, location and availability status
- Field boundaries
Surveyed field boundary geometry with survey date and area
Linked to Fields
- Crop cycles
Crop cycles per field from planned planting through growing, harvesting and close
Linked to Fields - Fields
Farm fields and plots with area, location and availability status
- Harvests
Harvested quantities with unit and grade, accepted by a reviewer
Linked to Crop cycles, People
- Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Fields, Crop cycles, People - Fields
Farm fields and plots with area, location and availability status
- Crop cycles
Crop cycles per field from planned planting through growing, harvesting and close
Linked to Fields - People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Input usage
Input quantities consumed against a field task
Linked to Input stocks, Field tasks
- Input stocks
Agricultural input stock lots with quantity on hand, unit and expiry
- Input usage
Input quantities consumed against a field task
Linked to Input stocks, Field tasks - Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Fields, Crop cycles, People
- Harvests
Harvested quantities with unit and grade, accepted by a reviewer
Linked to Crop cycles, People - Crop cycles
Crop cycles per field from planned planting through growing, harvesting and close
Linked to Fields - People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users
- Field observations
Field scouting observations with measured value, unit and notes
Linked to Fields - Input applications
Recorded input applications to a field by a named applicator
Linked to Fields, People - Fields
Farm fields and plots with area, location and availability status
- People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users
Keys and references
Use the reference fields to connect records rather than matching free-text names. Field tasks.Field and field tasks.Cycle identify the work scope; field tasks.assigned to identifies the person. Harvests.Cycle and Harvests.accepted by retain the harvest scope and reviewer. Input usage.Input and input usage.Task retain the lot and task behind consumption.
Migration order
- Import Users and People and reconcile account links.
- Import Fields and any field boundaries.
- Import crop cycles, then field tasks and field observations.
- Import input stocks, then input usage and input applications.
- Import Harvests and check each linked cycle and reviewer.
Set up Farm Management System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.