SQLite Database Administration

Database Information

File Path:
C:\Program Files\Ampps\www\l\data\leads.sqlite

File Size: 332 KB

Database Type: SQLite

Last Modified: 2025-07-23 17:23:14

Table Statistics
Lead Sources: 10
Leads Backup 2025 06 29 15 44 50: 44
Lead Contacts Backup 2025 06 29 15 44 50: 122
Lead Verifications Backup 2025 06 29 15 44 50: 0
Lead Activity Backup 2025 06 29 15 44 50: 25
Lead Activities Backup 2025 06 29 15 44 50: 13
Leads: 46
Lead Contacts: 125
Lead Verifications: 0
Lead Activity: 52
Lead Activities: 361
Administration Tools
Database Maintenance
Optimizes the database file by removing unused space and reorganizing data.
Backup & Export
Downloads a complete copy of the database file for backup purposes.
Quick Access
System Test Manage Leads
Documentation
Setup Guide Documentation
Recent Activity
Updated 2025-07-17 22:19:29
Lead updated
Lead ID: 6076189 | By: system
Updated 2025-07-17 21:50:32
Lead updated
Lead ID: 1917311 | By: system
Updated 2025-07-17 21:50:21
Lead updated
Lead ID: 1917311 | By: system
Updated 2025-07-17 21:46:30
Lead updated
Lead ID: 1917311 | By: system
Updated 2025-07-16 22:31:47
Lead updated
Lead ID: 4300534 | By: system
Updated 2025-07-16 20:14:36
Lead updated
Lead ID: 5322378 | By: system
Updated 2025-07-10 20:49:41
Lead updated
Lead ID: 3187493 | By: system
Updated 2025-07-10 19:31:12
Lead updated
Lead ID: 1692583 | By: system
Updated 2025-07-09 17:38:02
Lead updated
Lead ID: 3187493 | By: system
Updated 2025-07-09 17:37:42
Lead updated
Lead ID: 3187493 | By: system
Database Schema
Core Tables
  • leads - Main lead information
  • lead_contacts - Contact methods (emails, phones, etc.)
  • lead_verifications - Verification history and results
Supporting Tables
  • lead_sources - Lead source tracking and statistics
  • lead_activity - Complete activity/audit log