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.