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.
- Agri Supply Chain
- Data Model
The tables behind Agri Supply Chain
Agri Supply Chain 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
- Change it
- Add fields and tables in Proto
How the model is organised
Fields and Boundaries
Fields supplies the plot identity, area and availability. Field boundaries references Fields with geo JSON, survey date and area hectares.
Crop Cycles
Crop cycles references Fields and retains the crop, variety, stage and planting/harvest dates.
Field Work
Field tasks references Fields, crop cycles and team members. Team members.User references Users to connect the assigned person with an authenticated account.
Input Stocks and Usage
Input stocks retains lot identity, unit, balance and expiry. Input usage links the consumed quantity to input stocks and field tasks; the task provides the field and cycle path.
Agronomy and Applications
Agronomy evidence references Fields with dated measurements and notes. Input applications references Fields and team members through Applicator. Its input name is text rather than a stock-lot reference.
Harvest Deliveries
Crop deliveries references crop cycles and team members through accepted by. Quantity, Unit and quality grade retain the accepted harvest basis.
Every table, by feature
- Fields and Boundaries4
- Crop Cycles4
- Field Work7
- Input Stocks and Usage5
- Agronomy and Applications8
- Harvest Deliveries5
- 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 - Team members
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Users
Users
Linked to Users
- 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
- Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Fields, Crop cycles, Team members - Crop deliveries
Harvested quantities with unit and grade, accepted by a reviewer
Linked to Crop cycles, Team members
- Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Fields, Crop cycles, Team members - 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 - Team members
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Users
Users
Linked to Users - 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
- 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, Team members - 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
- Agronomy evidence
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, Team members - Fields
Farm fields and plots with area, location and availability status
- Team members
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Users
Users
Linked to Users - 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, Team members - Input stocks
Agricultural input stock lots with quantity on hand, unit and expiry
- Crop deliveries
Harvested quantities with unit and grade, accepted by a reviewer
Linked to Crop cycles, Team members - 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
- Team members
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users - Users
Users
Linked to Users
Keys and references
Preserve the Id values and actual references during migration. A field name or person name cannot replace a Field, Cycle or assigned to reference. Resolve team members.User to the real Users record; Users.User also carries a user reference. Field tasks.Field should agree with its linked crop cycles.Field before work proceeds. Keep input usage.Input attached to the correct lot when product names repeat.
Migration order
- Resolve Users and create team members with their authenticated account links.
- Load Fields with reviewed codes, names, areas and availability states.
- Attach field boundaries and crop cycles to the correct fields.
- Load input stocks with units, expiry dates and reconciled opening quantities.
- Create field tasks with valid field, cycle and assigned-team references.
- Import historical input usage only with an agreed stock reconciliation; avoid consuming the opening balance again.
- Attach agronomy evidence, input applications and crop deliveries with their dates and responsible-person references.
Set up Agri Supply Chain your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.