Backend Web Application

CUQuest is a backend system designed to support a service-exchange platform for university students. I developed the PostgreSQL database schema and API architecture to manage users, service posts, and request lifecycles while enforcing strict data integrity at the database level.

The system uses enumerated types to constrain request status values (open, pending, closed, expired), ensuring invalid states cannot exist within the database. The schema is fully normalized and built with primary keys, foreign keys, and relational constraints to maintain consistency across user accounts, posts, and transactional records.

On the application side, the backend is structured around FastAPI, connecting to PostgreSQL to expose RESTful endpoints for creating posts, retrieving listings, and updating request statuses. The architecture emphasizes separation of concerns between schema design, business logic, and API routing.

This project strengthened my understanding of backend system design, database-driven state management, API development, and how relational modeling directly shapes application behavior. This project is ongoing.