Broker Management System

Add broker-specific landing pages, role-based access control (admin/broker/applicant), and IP address tracking to a tRPC + Drizzle + React web application.

Implementation Process

Extend database schema (landing pages table, IP columns, role enum)

Add database helper functions

Add backend router (public, admin, broker self-service endpoints)

Build frontend (public landing page, admin management UI)

Write tests

Seed broker data and document the process

Documentation Sections

Admin Guide

How to add brokers with limited or full access, create personalised landing pages, and manage IP address tracking for audit compliance.

Schema Templates

Drizzle ORM table definitions for broker landing pages, IP tracking columns, and user role enums ready to copy into your project.

Backend Patterns

Database helpers, tRPC router procedures, IP extraction utilities, and role-based middleware patterns.

Frontend Patterns

React component structure for public broker landing pages, admin management UI, routing, and navigation.

Test Patterns

Vitest mock setup with in-memory arrays, context helpers, IP tracking tests, and a complete test case matrix.

Tech Stack

React 19TypeScripttRPC 11Drizzle ORMMySQL / TiDBTailwind CSS 4shadcn/uiVitestExpress 4Manus OAuth