🌾 Agriculture · Database ERD
Farm Records Database Schema
A schema for a farm management app: farmers, plots, crop cycles, inputs applied, activities and harvests.
Drawing diagram…
What this diagram shows
- Each plot runs crop cycles by season
- Inputs (seed, fertiliser, pesticide) are logged per cycle
- Harvest yield and sale price close the cycle for profit tracking
Prompt used
ERD for farm records: Farmer owns Plots with area and soil type; CropCycle is one crop on a Plot in a season; InputApplication records seeds, fertilisers and pesticides applied with quantity and cost; Activity records sowing, irrigation and weeding with labour cost; Harvest records yield and sale price per cycle.
Mermaid code
erDiagram
FARMER ||--o{ PLOT : owns
PLOT ||--o{ CROP_CYCLE : grows
CROP ||--o{ CROP_CYCLE : "planted as"
CROP_CYCLE ||--o{ INPUT_APPLICATION : uses
CROP_CYCLE ||--o{ ACTIVITY : includes
CROP_CYCLE ||--o| HARVEST : ends
PLOT {
int id PK
int farmer_id FK
decimal area_acres
string soil_type
}
CROP_CYCLE {
int id PK
int plot_id FK
int crop_id FK
string season
date sown_on
}
INPUT_APPLICATION {
int id PK
int cycle_id FK
string input_type
decimal quantity
decimal cost
}
HARVEST {
int cycle_id FK
decimal yield_quintals
decimal sale_price
}Related templates
Precision Farming IoT Deployment
Where each part of a precision farming system runs: soil and weather sensors in the field, a solar-powered LoRaWAN gateway, and cloud services for irrigation and advice.
Farm-to-Market Supply Chain
How produce moves from the farm to the buyer: harvest, grading, collection centre, mandi or online market, and payment to the farmer.
Crop Monitoring Data Pipeline
How satellite and drone imagery plus field sensors become crop health alerts and advice for farmers.
Automated Irrigation Controller
The states of an automated drip irrigation controller: idle, scheduled watering, moisture-based watering, rain delay and fault handling.
Mandi Price and Selling App
How a farmer checks crop prices across nearby mandis and books a sale: live prices, transport cost, best net price and booking.
Farm Management Platform Architecture
A platform farmers use to plan crops, record field work and inputs, and get advisory and market prices.