View Published Cases & Provide Help (External)

[User] ----------------------- 🔑 user_id (PK) • name • email • phone • role

[Blood Donor] ----------------------- 🔑 donor_id (PK) 🔗 user_id (FK) • blood_group • location • availability

[Admin] ----------------------- 🔑 admin_id (PK) • name • email • role

[Blood Donation Req] ----------------------- 🔑 request_id (PK) 🔗 admin_id (FK) • blood_group • patient_details • status

[Hospital] ----------------------- 🔑 hospital_id (PK) • name • location • contact

[Doctor] ----------------------- 🔑 doctor_id (PK) 🔗 hospital_id (FK) • name • specialization

ni