Leads Table
Component Detail
Data Layer
low complexity
backend
0
Dependencies
1
Dependents
0
Entities
0
Integrations
Description
PostgreSQL table that persists all qualified booking form submissions as lead records. Stores the prospect's contact details, organization metadata, submission timestamp, and current pipeline status. Serves as the source of truth for sales pipeline tracking and demo scheduling.
leads-table
Responsibilities
- Store booking submission records with organization name, contact person, email, phone, organization type, and message
- Track lead status (new, contacted, demo-scheduled, closed) for sales pipeline management
- Record submission timestamp and originating IP for audit and deduplication purposes
Interfaces
insert(lead: NewLead): Promise<Lead>
findByEmail(email: string): Promise<Lead | null>
updateStatus(id: string, status: LeadStatus): Promise<void>