Vendor needs to provide wholesale producer directory website database and Integration build services to backend developer to design and produce the database, database management tool, and integration layers. Database will be hosted in a cloud–based PostgreSQL SAAS; administrators from Provecho Collective should be able to manage the data and database through a database management tool. 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.