Database and Integration Build Services

A Colorado-based client is seeking a qualified vendor to provide comprehensive database and integration build services. The project involves the design and development of a cloud-based PostgreSQL database, complete with a robust relational schema. Core entities to be captured include producer contact information, attributes, certifications, product lists, service areas, geographic coverage, verification status, and metadata such as "last updated" information. The solution must support role-based access control and include audit logging to ensure compliance and data security.

The vendor will also deliver a database management tool, ensuring the architecture is user-friendly and maintainable by the internal team. The implementation should include stored functions, procedures, and triggers to facilitate streamlined database management.

Additionally, the scope includes developing a website codebase or a front-end integration layer. This component should support a "claim profile" workflow involving invitation, verification, and approval steps, as well as manual user data import. The system must provide granular access controls to manage user permissions effectively.