DB Schema

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.