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.
- Greenhouse Management
- Data model
The tables behind Greenhouse Management
Greenhouse Management 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
Growing areas
Fields hold operational area identities; greenhouse zones attach surveyed geometry to a field.
Crop work
Crop cycles connect a crop and variety to a field; field tasks connect assigned work to both.
Inputs
Input stocks hold lots and balances; input usage links applied quantities to stock and task.
Outcome
Harvests attach dated quantity, unit, grade and accepting person to a cycle.
Field evidence
Field observations and nutrient readings attach measurements and applications to fields.
Identity
People link named team members to Users and appear on task, harvest and application records.
Every table, by feature
- Crop cycles4
- Field work5
- Input stock and usage5
- Harvest review4
- Greenhouse zones3
- Observations and readings6
- Shared and settings1
- 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, People - 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 - 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 - 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
- People
Farm staff, operators, reviewers and managers with their authenticated user account and role title
Linked to Users
- Greenhouse zones
Surveyed field boundary geometry with survey date and area
Linked to Fields - 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
- Field observations
Field scouting observations with measured value, unit and notes
Linked to Fields - Nutrient readings
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 - Field tasks
Planned and executed field work assigned to a person for a specific cycle
Linked to Fields, Crop cycles, People - Input usage
Input quantities consumed against a field task
Linked to Input stocks, Field tasks
Keys and references
Use the exact reference fields when importing or reconciling records. Crop cycles.Field, field tasks.Field and field tasks.Cycle must identify the intended area and planting. Input usage.Input and input usage.Task connect consumption to stock and work. Harvests.Cycle identifies the planting whose output was measured. Greenhouse zones.Field, field observations.Field and nutrient readings.Field provide field context. People.User connects assignments and recorded decisions to an account.
Migration order
- Import Users and People, then confirm each active person has the right account link.
- Import Fields and verify names, codes, locations and status.
- Import greenhouse zones and crop cycles against the correct fields.
- Import input stocks and reconcile on-hand quantities, units and expiry dates.
- Import field tasks with their field, cycle and assignee links.
- Import input usage, field observations, nutrient readings and Harvests after checking their source references.
Set up Greenhouse Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.