Admin panel
Shukravedaherbals lead management
Review every inquiry submitted through the contact form, with status, timestamp, and the health concern each person shared.
Overview
New
Status on arrival for every submission
Records are stored privately and are never shown on public pages.
Filter leads
Submitted inquiries
Filter by status, health concern, and submission timestamp to focus the list on the records that need attention.
| Name | Mobile | Health concern | Status | Submitted | |
|---|---|---|---|---|---|
| Record preview | Hidden until opened | Hidden until opened | Shared by person | new | Timestamp |
Contact data
Relational lead table
The contact-data table stores each submission with indexed timestamps and email addresses for reliable lead tracking.
| Column | Definition |
|---|---|
| id | INT UNSIGNED AUTO_INCREMENT PRIMARY KEY |
| name | VARCHAR(100) NOT NULL |
| VARCHAR(150) NOT NULL | |
| mobile | VARCHAR(15) NOT NULL |
| disease | VARCHAR(150) NOT NULL |
| message | TEXT NOT NULL |
| status | VARCHAR(20) NOT NULL DEFAULT ‘new’ |
| ip_address | VARCHAR(45) NULL |
| user_agent | VARCHAR(255) NULL |
| created_at | TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP |
| Indexes | INDEX idx_created_at (created_at), INDEX idx_email (email) |