Vendor needs to provide database and integration build services. 1. Cloud–based PostgreSQL database: – Design a relational schema for the database. Core entities include: – Producer contact, attributes, certifications. – Product lists & attributes. – Service areas and geographic coverage. – Verification status and “last updated” metadata. – Supports role–based access control at the database level, including audit logs. 2. Database management tool: – Database architecture must be maintainable by an internal team. – Include stored functions, procedures and triggers for ease of use. 3. Website codebase / front–end integration layer: – Supports a “claim profile” workflow (invitation, verification, approval). – Supports manual (user) data import. – Granular access levels for users.