Requirements?

[fyliu]

• Are the requirements documented and if so, where?
• If not, do you have any knowledge about the requirements?

copied from slack

[fyliu]

We mainly work off of the ER diagram which has the latest database schema design. The requirements is to make a common backend for VRMS, the website, and CivicTechJobs. But the short term work is to implement all the tables with CRUD functionality for VRMS.

The original people that worked on the design are gone except for Bonnie, and she’s really busy. As we work through the tables, we’re finding out some things they put into the design are not what they meant to have. Azania hit one with the faq_viewed table where there's an extra field that shouldn't be there. There are also tables borrowed from VRMS that need improvements, like the recurring_event table that needs at least an added rrule field and maybe a couple more supporting fields to do what it’s meant to do. What I'm saying is that there's a good enough overall design. We can guess at what it's meant to do most of the time, but sometimes it's not as thought-out as we'd need to be able to implement without asking more clarifying questions from Bonnie.