The Business Collective

Site Map

Architecture overview of The Business Collective platform.

Public Pages

Public

Member Pages

Logged in

Admin Pages

Admin only

Data Entities

UserBuilt-in. Stores full_name, email, role, business_name, industry, profile_photo_url.
BusinessProfilebusiness_stage, collaboration_type.
Needsneed_types[], urgency_level, budget_readiness.
Offersoffer_categories[], ideal_customer.
OpenResponsesgoal, challenge, ideal_connection, open_opportunities, notes, tool_available (Yes/No), tool_wish. Collected at registration; tool fields surfaced in Admin Analytics.
MatchesStores top 5 AI matches per user with score, reason, conversation_starters[], matched_offer_categories[], and matched_profile_photo_url.
DealTracks deal_type (Customer/Partnership/Vendor/Other), deal_stage (Identified → Closed Won/Lost), estimated_value, amount_closed, notes per matched connection.
Eventname, datetime, venue, host, status.
EventAttendeeLinks users to events.
EventMatchIn-event match pairs with score and reason.
BroadcastAdmin-authored announcements with title, body, priority (info/warning/urgent), status (draft/sent), and recipient_count.
BroadcastReceiptTracks per-user read status for each broadcast. Created in bulk when a broadcast is sent.
CalendarEventPublic-facing events shown on the calendar page with title, date, time, location, event_type, and optional registration link.
PostEventFeedback5-question post-event survey capturing connection value, relevance, business outcome, usefulness, and open feedback.
SponsorsPartner company info with logo, tier (Founding/Community/Supporting), description, and featured flag. Displayed on /sponsors page.
SponsorApplicationSponsorship applicant data with business_name, contact_name, email, desired_tier, and status (pending/reviewed/approved/declined).
AdminNotificationAdmin-only notifications for sponsor applications and other admin events with type, title, message, reference_id, and read status.
DeletedAccountAudit log of deleted accounts storing user_id, email, full_name, and deleted_at timestamp.

Backend Functions

generateMatches7-layer AI scoring engine: direct need match, reverse match, business stage, collaboration intent, ideal customer, open-response AI alignment, and deal success pattern learning (from Closed Won deals). Stores top 5 per user in Matches with score, reason, and conversation starters.
generateEventMatchesScores attendees within a specific event using the same 7 layers → stores in EventMatch. Enables in-event optimization and quick discovery of highest-value connections at the gathering.
getAllUsersAdmin utility — returns all users with profile data for analytics dashboard and event management workflows.
deleteAccountHandles user account deletion: soft-deletes User record, archives all related data, and logs deletion in DeletedAccount table for audit trail.
agentChatBackend proxy for the anonymous AI chat widget. Uses asServiceRole to create conversations and send messages to the gwinnett_collective_assistant agent without requiring user authentication.