Description
We need to define and implement any new schemas/tables to store information for each resource's suggestions. This also needs to include any materialized views that will be consumed by the admin dashboard and other administrative flows.
Complexity
I'll let @vontell figure this out.