Back to Demo

Mkulima Digital Data Model

Based on farmer profile mapping across the agricultural lifecycle

FARMER• farmer_id (PK)• name• phone_number• registration_dateFARM• farm_id (PK)• farmer_id (FK)• farm_name• farm_type• year_establishedFIELD• field_id (PK)• farm_id (FK)• field_name• location (lat/long)• size_acres• soil_typeCROP_PLANTING• planting_id (PK)• field_id (FK)• crop_type• variety• planting_date• expected_harvest_date• seed_sourceHARVEST• harvest_id (PK)• planting_id (FK)• harvest_date• yield_amount• quality_grade• notesSOIL_DATA• soil_test_id (PK)• field_id (FK)• test_date• ph_levelEQUIPMENT• equipment_id (PK)• farm_id (FK)• equipment_type• acquisition_date• conditionMARKET_LINKS• link_id (PK)• farmer_id (FK)• entity_type• entity_name• relationship_typeFINANCIAL_DATA• finance_id (PK)• farmer_id (FK)• account_type• provider• account_number• credit_score• subsidy_eligibilityWEATHER_DATA• weather_id (PK)• farm_id (FK)• date• temperatureACTIVITIES• activity_id (PK)• planting_id (FK)• activity_type• date• inputs_used• notes