Summary:
During the meeting, the participants discussed the issue of storing and querying user data for cities visited. They explored the possibility of using arrays and objects in the database schema. There was some confusion regarding the implementation, but it was determined that it would be best to create a separate table for reviews and businesses. This would allow for easier querying and filtering of data. Additionally, they discussed a potential solution for finding accounts that have not left a review for a particular GMB. They proposed using a query that retrieves account IDs of those who have reviewed the GMB, and then querying the accounts table for those IDs that are not in the list. This would provide a list of accounts that have not left a review. The meeting concluded with a plan to implement these changes and test the solution.
(Source: Office Hours 9/7 )
