community care platform · oracle sql · cpsc 304
StrayCare
a community tool for tracking stray animals. every feeding, vaccination, and volunteer action lands in an oracle schema so nothing falls through the cracks.
how it works
every stray, mapped.
each pin is a log entry. feeding, vaccination, sighting — all tied to a plus code location so nothing slips through the cracks and every volunteer knows exactly where to go.
what it does
animal profiles
profiles for each stray with age, traits, and location, tied to feeding and vaccine history.
volunteer communities
volunteers are grouped by community so people only manage animals in their area.
location-aware care
Plus Codes anchor every animal and volunteer, so filtering by neighbourhood actually works.
vaccination tracking
vaccination records include type, dose, date, and vet, so gaps show up fast.
community analytics
oracle views make it easy to pull feeding frequency, volunteer activity, and area coverage.
access control
session auth and role checks keep edits limited to the right community.
database-first design
we started with the schema.
once the oracle tables made sense, the ui was straightforward — it was just exposing what the database already knew.
Plus Codes are the location keys. vaccinations are stored as separate events so we can analyze them without mixing them into feeding history.
- normalized tables for animals, volunteers, communities, vets.
- bridge tables for volunteer–community and animal–location links.
- separate vaccination and feeding event tables with timestamps.
- views for last-fed, vaccination gaps, and volunteer activity.
StrayCare ER Diagram · Oracle SQL · abstract version
team
three people, a community of strays, and one oracle schema.
