Database Structure
The volunteer system uses MySQL for the database, and Prisma.io for the ORM.
| title | in-use | description |
|---|---|---|
| User | x | Store user data |
| Semester | x | Used to filter/sort data based on semester |
| UserMembership | x | Store everyone who has paid membership to CYB |
| Session | x | Store valid browser sessions |
| ActivateToken | x | Email validation status and last validation attempt |
| Role | x | Available roles for role-based access |
| WorkLog | x | Volunteer vouchers earned |
| VoucherLog | x | Volunteer vouchers used |
| WorkGroup | Used to filter/sort data based on work group | |
| ShiftCafé | Shifts for volunteers working in the café |
