I know that quotas will be coming soon. My circulation staff would like to limit future reservations to one per user. Lookin at the schema, it seems that it should be doable by:
1. Look at reservation_users for memberid
2. If memberid is found take the resid and query reservations; else allow reservation
3. If reservations::start_date > today then deny reservation; else allow reservation
Would this work, or am I off base?