ChemMentor Pro

/* ChemMentor Database Schema */
CREATE TABLE leads (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100),
    phone VARCHAR(20) NOT NULL,
    status ENUM('new', 'contacted', 'qualified', 'customer', 'dormant') DEFAULT 'new',
    source VARCHAR(50),
    priority ENUM('low', 'medium', 'high') DEFAULT 'low',
    score INT DEFAULT 0,
    tags JSON,
    sequence_id INT NULL, -- FK to sequences table
    current_step INT DEFAULT 0, -- Current step if not using lead_sequence_progress
    next_action_date DATETIME,
    last_contact_date DATETIME,
    notes TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);
-- ... (rest of schema as provided previously) ...