DB Schema

Database schema

+users
-—
id long
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 //Hashed Password.
account_status String //active inactive blocked

admin_users
-—
id int
email_id String
password String // Hashed
join_date Date
Status String //active inactive

requests_for_blood
-———————-
id long
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 long
recipient_id long
tracking_request String //on off – is the user requesting for donor tracking?
Last_known_location String // lat long – recipient tracking for our purposes
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.