Fertilizers
id | name | quantity |
1 | Fertilizer1 | 100.0 |
2 | Fertilizer2 | 150.0 |
3 | Fertilizer3 | 200.0 |
4 | Fertilizer4 | 250.0 |
5 | Fertilizer5 | 300.0 |
Components
id | componentName |
1 | Nitrogen |
2 | Phosphorus |
3 | Potassium |
4 | Calcium |
5 | Magnesium |
FarmerInfo
id | farmerName | farmLocation |
1 | Farmer1 | New York |
2 | Farmer2 | Chicago |
3 | Farmer3 | Los Angeles |
4 | Farmer4 | Houston |
5 | Farmer5 | Philadelphia |
Crops
id | cropName | yield |
1 | Wheat | 7000.0 |
2 | Corn | 8000.0 |
3 | Rice | 6000.0 |
4 | Barley | 5000.0 |
5 | Oats | 4000.0 |
Farmers_Crops
farmerId | cropId |
(→ FarmerInfo.id) | (→ Crops.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 1 |
Fertilizers_Components
fertilizerId | componentId |
(→ Fertilizers.id) | (→ Components.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 1 |
4 | 1 |
5 | 1 |