Skip to content
shashank-srikant edited this page Aug 6, 2016 · 1 revision

Welcome to Seva Setu's wiki. This would be constantly updated to involve various aspects of the project.

DB Schema

mct_beneficiary

Stores data about mothers in rural areas, including details like name, husband's name, phone number, due date and ID of the field worker assigned.

mct_field_workers

Maintains data about the field workers. One field worker may be assigned to many rural mothers/beneficiaries.

mct_call_champions

Maintains details of call champions

mct_user

Maintains details of the users of the web app who are mct_field_workers and mct_call_champions

mct_due_list

Given the expected date of delivery of a mother (table: mct_beneficiary, field: dt_due_date), a fixed number of interventions are calculated for the mother. These interventions are the dates when the call champions call the mother. Each row in this table denotes one such intervention. Each intervention has a specific agenda (details of which are stored in table 'mct_checklist_master') which the call champion picks up and discusses. The status of whether the call champion/the mother have been reminded over sms/email is maintained in the field 'reminder_status'.

mct_callchampion_report

Stores details of conversations between the beneficiary and call champions, including call status,summary of conversation and action items to be carried out.

mct_checklist_master

Stores details of action items including when (reference week number) and in what situation they need to be carried out.