Home

Database schema

users

---

id int email_id String address String address2 String locality String city String pincode long donor bool recipient bool admin_approved bool join_date Date request_count fulfilled_count donation_count health_information String //path to some kind of medical record file (EMR) blood_group String password String //encrypted. Even admins cannot access directly account_status String //active inactive blocked

admin_users

---

id int email_id String password String join_date Date Status String //active inactive

requests_for_blood

---

id date_requested Date admin_approved bool Address String address2 String locality String hospital String referring_doctor String landmark String comments String medical_record_file String //if any urgency String //URGENT 3-DAYS 5-DAYS or any particular date / time required_date_time DateTime donor_id int recipient_id int tracking_request String //on off Last_known_location String // lat long Comments_from_admin String other_request_ids String //csv for other request_ids in the event that one request needs more than one person to donate. App flow needs to be thought through.