-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 26, 2025 at 03:01 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `vistaarr_nitinnew`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_city`
--

CREATE TABLE `tbl_city` (
  `tbl_city_id` int(20) NOT NULL,
  `tbl_city_name` varchar(255) NOT NULL,
  `tbl_city_flag` int(10) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_city`
--

INSERT INTO `tbl_city` (`tbl_city_id`, `tbl_city_name`, `tbl_city_flag`) VALUES
(1, 'Delhi', 0),
(2, 'Gurgaon', 0),
(3, 'Noida', 0),
(4, 'Greater Noida', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_company_info`
--

CREATE TABLE `tbl_company_info` (
  `id` int(11) NOT NULL,
  `website_url` varchar(50) NOT NULL,
  `owner_name` varchar(100) NOT NULL,
  `owner_email` varchar(100) NOT NULL,
  `owner_mobile` varchar(20) NOT NULL,
  `gst_number` varchar(50) NOT NULL,
  `address1` varchar(50) NOT NULL,
  `address2` varchar(50) NOT NULL,
  `pincode` varchar(20) NOT NULL,
  `country` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `city` varchar(50) NOT NULL,
  `company_logo` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_events`
--

CREATE TABLE `tbl_events` (
  `tbl_events_id` int(11) NOT NULL,
  `event_name` varchar(255) NOT NULL,
  `event_date` date NOT NULL,
  `primary_developer` varchar(255) NOT NULL,
  `other_developer` varchar(255) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `tbl_state_id` int(11) NOT NULL,
  `tbl_city_id` int(11) NOT NULL,
  `property_type` varchar(50) NOT NULL,
  `event_video` varchar(50) NOT NULL,
  `event_card` varchar(50) NOT NULL,
  `event_banner` varchar(50) NOT NULL,
  `event_type` varchar(250) NOT NULL,
  `cdate` datetime NOT NULL,
  `edate` datetime NOT NULL,
  `cuser` varchar(50) NOT NULL,
  `euser` varchar(50) NOT NULL,
  `flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_followup_status`
--

CREATE TABLE `tbl_followup_status` (
  `tbl_followup_status_id` int(11) NOT NULL,
  `tbl_followup_status_name` varchar(255) NOT NULL,
  `tbl_followup_status_cdate` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `tbl_followup_status_edate` timestamp(6) NULL DEFAULT NULL ON UPDATE current_timestamp(6),
  `tbl_followup_status_cuser` varchar(255) DEFAULT NULL,
  `tbl_followup_status_euser` varchar(255) DEFAULT NULL,
  `tbl_followup_status_flag` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_invite_user`
--

CREATE TABLE `tbl_invite_user` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile_no` varchar(20) NOT NULL,
  `role` varchar(20) NOT NULL,
  `cdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `edate` datetime NOT NULL,
  `flag` int(11) NOT NULL,
  `cuser` varchar(250) NOT NULL,
  `euser` varchar(250) NOT NULL,
  `deleted_flag` int(11) NOT NULL,
  `action` text NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_invite_user`
--

INSERT INTO `tbl_invite_user` (`id`, `name`, `email`, `mobile_no`, `role`, `cdate`, `edate`, `flag`, `cuser`, `euser`, `deleted_flag`, `action`, `status`) VALUES
(1, 'Varun', 'varun@vistaarr.com', '918076694558', 'ADMIN', '2025-03-02 09:57:50', '0000-00-00 00:00:00', 0, 'ADMIN', '', 0, '', 'ACTIVE'),
(2, 'SAURABH KALRA', 'saurabh@vistaarr.com', '918920667188', 'ADMIN', '2025-03-02 05:28:24', '0000-00-00 00:00:00', 0, 'ADMIN', '', 0, '', 'ACTIVE'),
(3, 'Avadhi Badjatya', 'avadhibadjatya11@gmail.com', '919425347407', 'STANDARD', '2025-03-02 05:30:13', '0000-00-00 00:00:00', 0, 'ADMIN', '', 0, '', 'ACTIVE'),
(4, 'Varun Sales Person', 'varun_aggarwal29@outlook.com', '919871430877', 'STANDARD', '2025-03-02 05:32:34', '0000-00-00 00:00:00', 0, 'ADMIN', '', 0, '', 'ACTIVE');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead`
--

CREATE TABLE `tbl_lead` (
  `tbl_lead_id` int(11) NOT NULL,
  `tbl_lead_name` varchar(255) DEFAULT NULL,
  `tbl_lead_mobile` varchar(255) DEFAULT NULL,
  `tbl_lead_alt_mobile` varchar(255) DEFAULT NULL,
  `tbl_lead_email` varchar(255) NOT NULL,
  `tbl_lead_source_id` int(11) DEFAULT NULL,
  `tbl_lead_project_id` int(11) DEFAULT NULL,
  `tbl_lead_user_assigned` int(11) DEFAULT NULL,
  `tbl_lead_city_id` int(11) DEFAULT NULL,
  `cdate` datetime NOT NULL DEFAULT current_timestamp(),
  `edate` datetime NOT NULL DEFAULT current_timestamp(),
  `cuser` varchar(100) DEFAULT NULL,
  `euser` varchar(100) DEFAULT NULL,
  `flag` int(11) NOT NULL DEFAULT 0,
  `tbl_lead_city` varchar(200) DEFAULT NULL,
  `tbl_lead_project` varchar(200) DEFAULT NULL,
  `tbl_lead_intent` varchar(200) DEFAULT NULL,
  `tbl_lead_source_name` varchar(200) DEFAULT NULL,
  `tbl_lead_reg_date` date DEFAULT NULL,
  `tbl_lead_assigned_user` varchar(200) DEFAULT NULL,
  `tbl_lead_status` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_lead`
--

INSERT INTO `tbl_lead` (`tbl_lead_id`, `tbl_lead_name`, `tbl_lead_mobile`, `tbl_lead_alt_mobile`, `tbl_lead_email`, `tbl_lead_source_id`, `tbl_lead_project_id`, `tbl_lead_user_assigned`, `tbl_lead_city_id`, `cdate`, `edate`, `cuser`, `euser`, `flag`, `tbl_lead_city`, `tbl_lead_project`, `tbl_lead_intent`, `tbl_lead_source_name`, `tbl_lead_reg_date`, `tbl_lead_assigned_user`, `tbl_lead_status`) VALUES
(1, 'Kamal Tomar', '9876567898', '9876567898', 'kamal@gmail.com', 1, 0, 0, 0, '2025-02-16 03:43:25', '2025-02-22 18:07:28', 'ADMIN', '', 0, '', '', '', '', '2025-02-22', '', ''),
(2, 'Kamal Tomar', '9876567898', '9876567898', 'kamal@gmail.com', 1, 0, 0, 0, '2025-02-16 03:45:46', '2025-02-22 18:07:28', 'ADMIN', '', 0, '', '', '', '', '2025-02-22', '', ''),
(3, 'Kamal Tomar', '9876567898', '9876567898', 'kamal@gmail.com', 1, 0, 0, 0, '2025-02-16 04:32:49', '2025-02-22 18:07:28', 'ADMIN', '', 0, '', '', '', '', '2025-02-22', '', ''),
(178, 'Yashashri kurambhatti', '9028842252', '', 'yashashrikulkarni001@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-22', 'varun sales person', ''),
(179, 'atul', '9.19961E+11', '', 'kanchanbhosale@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-23', 'varun sales person', ''),
(180, 'Viay Thaware', '9.18555E+11', '', 'ViajyThaware@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-24', 'varun sales person', 'In Progress'),
(181, 'Sunil Mahapatra', '9.18669E+11', '', 'sunila.mahapatra@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-25', 'varun sales person', 'In Progress'),
(182, 'Charan', '9.19891E+11', '', 'charanbkale@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-26', 'varun sales person', 'In Progress'),
(183, 'abhi', '9.18459E+11', '', 'abhikhopade1712@gmail.cm', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-27', 'varun sales person', 'New'),
(184, 'fszf8ksdfjdjk9w', '9011041569', '', 'ha0545378@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-28', 'varun sales person', 'New'),
(185, 'Harsh', '9.17276E+11', '', 'harshpipara1801@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-01', 'varun sales person', 'New'),
(186, 'Satish Panchal', '9.19766E+11', '', 'saatishpanchal24@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-02', 'varun sales person', 'New'),
(187, 'Satish Panchal', '', '', 'saatishpanchal24@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-03', 'varun sales person', 'New'),
(188, 'Satish Panchal', '9.19766E+11', '', 'saatishpanchal24@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-04', 'varun sales person', 'New'),
(189, 'Yogendra ', '9.18087E+11', '', 'yogenjain1993@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-05', 'varun sales person', 'New'),
(190, 'Ashish', '9.19595E+11', '', 'ashish.chougale2012@gmail.con', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-06', 'varun sales person', 'SV Scheduled'),
(191, 'Ankur', '9.19996E+11', '', 'ankurdalvi001@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-07', 'varun sales person', 'SV Scheduled'),
(192, 'Ram ', '9.19768E+11', '', 'rammarathi.raut@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-08', 'varun sales person', 'SV Scheduled'),
(193, 'R', '7455522211', '', 'vijaykp@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-09', 'varun sales person', 'SV Scheduled'),
(194, 'Nilesh Taware', '9.19882E+11', '', 'nileshtaware01@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-10', 'varun sales person', 'SV Scheduled'),
(195, 'B.M.Jadhav', '9.19987E+11', '', 'bmjadhav1@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-03-11', 'varun sales person', 'Dead Lead'),
(196, 'B.M.Jadhav', '9.19987E+11', '', 'bmjadhav1@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:25', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-03-12', 'varun sales person', 'Dead Lead'),
(197, 'Rakesh Kumar Gulati', '9.19424E+11', '', 'rakesh.seekers@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-03-13', 'varun sales person', 'Dead Lead'),
(198, 'JAGDISH KATIE', '8888639305', '', 'jagdishkate01@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-03-14', 'varun sales person', 'Dead Lead'),
(199, 'Husen Daruwale', '9.17559E+11', '', 'husen.daruwale@sulzer.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'Dead Lead'),
(200, 'Satish Gaikwad', '9.19819E+11', '', 'callsatish@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'Dead Lead'),
(201, 'Gopal', '9.1736E+11', '', 'meghuthecool@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'Dead Lead'),
(202, 'Vipul Ramesh Sharma', '9.19604E+11', '', 'sales@kleantech.in', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'Dead Lead'),
(203, 'Rete', '9.17767E+11', '', 'test@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(204, 'Stephnis Rajendra Sable ', '9.18793E+11', '', 'steev.smith@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(205, 'Stephnis Rajendra Sable ', '9.18793E+11', '', 'steev.smith@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(206, 'Stephnis Rajendra Sable ', '9.18793E+11', '', 'steev.smith@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(207, 'Nilesh Tipnis', '9.17045E+11', '', 'nileshtipnis@outlook.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(208, 'Sahane chandarakant genabhau ', '9.17798E+11', '', 'csahane2010@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(209, 'Sahane chandarakant genabhau ', '9.17798E+11', '', 'csahane2010@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(210, 'Sourav Chakraborty ', '85140 65740', '', 'sourvicky007@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-22', 'varun sales person', 'EOI Completed'),
(211, 'Kore', '9.19822E+11', '', 'gkkore@hotmail.com', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(212, '', '9.18087E+11', '', '', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(213, '', '9.18087E+11', '', '', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(214, '', '9.18087E+11', '', '', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(215, '', '9.18087E+11', '', '', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(216, '', '9.18087E+11', '', '', 0, 0, 0, 0, '2025-02-22 18:07:26', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(217, 'Aarti Pohnerkar ', '9.19923E+11', '', 'aartipohnerkar@ymail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Company Website', '2025-02-22', 'varun sales person', 'EOI Completed'),
(218, 'Jasvinder singh', '9.18413E+11', '', 'jsmarwaha2007@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(219, 'Sanjay ', '9.19835E+11', '', 'ho@shirkeindia.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(220, 'Rashi', '9.1883E+11', '', 'mrash61@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(221, 'Dines', '9.19431E+11', '', 'dines@hotmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(222, 'gaurav bhandarkar', '9.19851E+11', '', 'alfatechindia@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(223, 'Suhas shimpi', '9.18957E+11', '', 'Shimpi.suhas88@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(224, 'Prashant Salunke ', '9.19851E+11', '', 'psalunke1972@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(225, 'MANISH GHANASHYAM MIJAR', '9.1937E+11', '', 'manishmijar14@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(226, 'Ashwini Chetan Chaudhari', '9.19924E+11', '', 'ashwinicrc@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(227, 'Manasi ', '9.17045E+11', '', 'dreamer250875@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(228, 'SHAJI MATHEW', '9.19769E+11', '', 'shajim64@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(229, 'Ram ghu', '9.19404E+11', '', 'ramkapoor4r@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'EOI Completed'),
(230, 'UDAY KULKARNI', '9.19226E+11', '', 'uttam.udyog@yahoo.in', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(231, 'Nivas Patil ', '9.19823E+11', '', '71nivas@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(232, 'Sandip Kanse', '9.1992E+11', '', 'kanse.sandip@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(233, 'Sandip', '9920470388', '', 'kanse.sandip@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(234, 'Shankar chalwadi', '9.19373E+11', '', 'shankar08518@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(235, 'Ritesh Ingole', '9.19168E+11', '', 'riteshingole@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(236, 'Sharad Khambe', '9.19823E+11', '', 'khambe.sharad@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:27', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(237, 'Yusuf ', '81495 06876 ', '', 'ypathan29@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:28', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(238, 'Dinesh gawade', '9.19327E+11', '', 'gawadedinesh@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:28', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(239, 'Deepak Sood', '9.19373E+11', '', 'deepaksood717@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:28', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(240, 'Pritesh', '9.18087E+11', '', 'priteshwani07@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:28', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(241, 'Sonali Adhau', '9.17507E+11', '', 'sonali.d.adhau@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:28', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(242, 'Shweta ', '9.19993E+11', '', 'shwetaaa@gmail.com', 0, 0, 0, 0, '2025-02-22 18:07:28', '2025-02-22 18:07:28', '', '', 0, 'Greater Noida', 'Rohan Harita', '', 'Other', '2025-02-22', 'varun sales person', 'SV Completed'),
(243, 'roshni kumari', '1234567890', NULL, 'test@gmail.com', NULL, NULL, NULL, NULL, '2025-02-24 13:39:26', '2025-02-24 13:39:26', NULL, NULL, 0, NULL, 'Contact Mahindra Zen  ', NULL, 'Website', '2025-02-24', NULL, NULL),
(244, 'roshni kumari', '1234567890', NULL, 'test@gmail.com', NULL, NULL, NULL, NULL, '2025-02-24 13:39:26', '2025-02-24 13:39:26', NULL, NULL, 0, NULL, 'Contact Mahindra Zen  ', NULL, 'Website', '2025-02-24', NULL, NULL),
(245, 'good', '1234567890', NULL, 'test@gmail.com', NULL, NULL, NULL, NULL, '2025-02-24 13:42:00', '2025-02-24 13:42:00', NULL, NULL, 0, NULL, 'Contact Mahindra Zen  ', NULL, 'Website', '2025-02-24', NULL, NULL),
(246, 'good', '1234567890', NULL, 'test@gmail.com', NULL, NULL, NULL, NULL, '2025-02-24 13:42:00', '2025-02-24 13:42:00', NULL, NULL, 0, NULL, 'Contact Mahindra Zen  ', NULL, 'Website', '2025-02-24', NULL, NULL),
(247, 'goooood', '1234567890', NULL, 'good@gmail.com', NULL, NULL, NULL, NULL, '2025-02-24 13:45:23', '2025-02-24 13:45:23', NULL, NULL, 0, NULL, 'Contact Mahindra Zen  ', NULL, 'Website', '2025-02-24', NULL, NULL),
(248, 'ATS ADVANTAGE', '9871430877', NULL, 'varun_aggarwal29@outlook.com', NULL, NULL, NULL, NULL, '2025-02-25 07:46:06', '2025-02-25 07:46:06', NULL, NULL, 0, NULL, 'Contact Mahindra Zen  ', NULL, 'Website', '2025-02-25', NULL, NULL),
(249, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:05:18', '2025-03-02 15:35:18', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(250, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:08:01', '2025-03-02 15:38:01', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(251, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:11:17', '2025-03-02 15:41:17', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(252, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:37:15', '2025-03-02 16:07:15', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(253, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:40:59', '2025-03-02 16:10:59', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(254, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:47:43', '2025-03-02 16:17:43', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(255, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:48:20', '2025-03-02 16:18:20', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(256, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:50:14', '2025-03-02 16:20:14', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(257, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:51:15', '2025-03-02 16:21:15', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(258, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:53:14', '2025-03-02 16:23:14', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(259, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:54:12', '2025-03-02 16:24:12', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(260, 'Ravi', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:54:48', '2025-03-02 16:24:48', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(261, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:56:45', '2025-03-02 16:26:45', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(262, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:58:08', '2025-03-02 16:28:08', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(263, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 11:59:06', '2025-03-02 16:29:06', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(264, '', '', '', '', 0, 0, NULL, NULL, '2025-03-02 12:00:03', '2025-03-02 16:30:03', 'ADMIN', NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead_assign`
--

CREATE TABLE `tbl_lead_assign` (
  `tbl_lead_assign_id` int(11) NOT NULL,
  `tbl_lead_assign_user` int(11) NOT NULL,
  `tbl_lead_assign_flag` int(11) NOT NULL,
  `tbl_lead_assign_projects` int(11) NOT NULL,
  `tbl_lead_assign_count` int(11) NOT NULL,
  `tbl_lead_assign_last_lead_received` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead_import`
--

CREATE TABLE `tbl_lead_import` (
  `tbl_lead_import_id` int(11) NOT NULL,
  `tbl_lead_import_filename` varchar(200) NOT NULL,
  `tbl_lead_import_upload_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `tbl_lead_import_imported_by` varchar(200) NOT NULL,
  `tbl_lead_import_status` varchar(50) NOT NULL,
  `tbl_lead_import_uploaded` int(11) NOT NULL,
  `tbl_lead_import_not_uploaded` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead_source`
--

CREATE TABLE `tbl_lead_source` (
  `tbl_lead_source_id` int(11) NOT NULL,
  `source_name` varchar(255) NOT NULL,
  `cdate` datetime NOT NULL,
  `edate` datetime NOT NULL,
  `flag` int(11) NOT NULL,
  `cuser` varchar(100) NOT NULL,
  `euser` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_lead_source`
--

INSERT INTO `tbl_lead_source` (`tbl_lead_source_id`, `source_name`, `cdate`, `edate`, `flag`, `cuser`, `euser`) VALUES
(1, 'Facebook Ads', '2025-02-16 01:01:52', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(4, 'Google Ads', '2025-02-16 01:04:10', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(5, 'Company Website', '2025-02-16 05:15:44', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(6, 'Reference', '2025-02-22 01:25:28', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(7, 'Landing Page', '2025-02-22 01:25:44', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(8, '99 Acres', '2025-02-22 01:25:58', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(9, 'Magicbricks', '2025-02-22 01:26:36', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(10, 'Common Floor', '2025-02-22 01:26:50', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(11, 'Makaan', '2025-02-22 01:27:03', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(12, 'Housing', '2025-02-22 01:27:10', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(13, 'Chat', '2025-02-22 01:27:23', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(14, 'Newspaper Ad', '2025-02-22 01:27:35', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(15, 'Whatsapp', '2025-02-22 01:27:49', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(16, 'Other', '2025-02-22 01:28:02', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(17, 'Linkedin', '2025-02-22 01:28:16', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(18, 'Taboola', '2025-02-22 01:28:34', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(19, 'Hoarding', '2025-02-22 01:28:47', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(20, 'Pamphlet', '2025-02-22 01:29:09', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(21, 'Event', '2025-02-22 01:29:28', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(22, 'Radio', '2025-02-22 01:29:35', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(23, 'SMS Campaign', '2025-02-22 01:30:00', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(24, 'Email Campaign', '2025-02-22 01:30:23', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(25, 'Walk In', '2025-02-22 01:30:41', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(26, 'CSV', '2025-02-22 01:30:52', '2025-02-22 01:25:44', 0, 'ADMIN', ''),
(27, 'Channel Partner', '2025-02-22 01:31:12', '2025-02-22 01:25:44', 0, 'ADMIN', '');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead_user`
--

CREATE TABLE `tbl_lead_user` (
  `tbl_lead_user_id` int(11) NOT NULL,
  `tbl_lead_user_profile_id` int(11) DEFAULT NULL,
  `tbl_lead_user_mobile` varchar(20) NOT NULL,
  `tbl_lead_user_alt_mobile` varchar(20) DEFAULT NULL,
  `tbl_lead_user_assigned_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_project_id` int(11) NOT NULL,
  `tbl_lead_user_intent` varchar(50) DEFAULT NULL,
  `tbl_lead_user_source_id` int(11) DEFAULT NULL,
  `tbl_lead_user_source_name` varchar(200) DEFAULT NULL,
  `tbl_lead_user_assigned_user_id` int(11) DEFAULT NULL,
  `tbl_lead_user_regdate` datetime(6) DEFAULT NULL,
  `tbl_lead_user_share_user_id` int(11) DEFAULT NULL,
  `tbl_lead_user_marked_by` varchar(255) DEFAULT NULL,
  `tbl_lead_user_marked_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_access_validity` datetime(6) DEFAULT NULL,
  `tbl_lead_user_access` varchar(255) DEFAULT NULL,
  `tbl_lead_user_note` text DEFAULT NULL,
  `tbl_lead_user_note_date` datetime(6) NOT NULL,
  `tbl_lead_user_cdate` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `tbl_lead_user_ctime` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `tbl_lead_user_edate` timestamp(6) NULL DEFAULT NULL ON UPDATE current_timestamp(6),
  `tbl_lead_user_etime` timestamp(6) NULL DEFAULT NULL ON UPDATE current_timestamp(6),
  `tbl_lead_user_cuser` varchar(255) DEFAULT NULL,
  `tbl_lead_user_euser` varchar(255) DEFAULT NULL,
  `tbl_lead_user_flag` int(11) NOT NULL DEFAULT 0,
  `tbl_lead_user_city_id` int(11) DEFAULT NULL,
  `tbl_lead_user_lnote` text DEFAULT NULL,
  `tbl_lead_user_lnote_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_reason` text DEFAULT NULL,
  `tbl_lead_user_fdate` datetime(6) DEFAULT NULL,
  `tbl_lead_user_fdate_flag` int(11) NOT NULL DEFAULT 0,
  `tbl_lead_user_sv_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_sv_type` varchar(255) DEFAULT NULL,
  `tbl_lead_user_sv_project_id` int(11) DEFAULT NULL,
  `tbl_lead_user_sv_duration` varchar(255) DEFAULT NULL,
  `tbl_lead_user_booking_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_eoi_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_status_marked_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_sv_completed_date` datetime(6) DEFAULT NULL,
  `tbl_lead_user_status` varchar(50) DEFAULT 'New'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_lead_user`
--

INSERT INTO `tbl_lead_user` (`tbl_lead_user_id`, `tbl_lead_user_profile_id`, `tbl_lead_user_mobile`, `tbl_lead_user_alt_mobile`, `tbl_lead_user_assigned_date`, `tbl_lead_user_project_id`, `tbl_lead_user_intent`, `tbl_lead_user_source_id`, `tbl_lead_user_source_name`, `tbl_lead_user_assigned_user_id`, `tbl_lead_user_regdate`, `tbl_lead_user_share_user_id`, `tbl_lead_user_marked_by`, `tbl_lead_user_marked_date`, `tbl_lead_user_access_validity`, `tbl_lead_user_access`, `tbl_lead_user_note`, `tbl_lead_user_note_date`, `tbl_lead_user_cdate`, `tbl_lead_user_ctime`, `tbl_lead_user_edate`, `tbl_lead_user_etime`, `tbl_lead_user_cuser`, `tbl_lead_user_euser`, `tbl_lead_user_flag`, `tbl_lead_user_city_id`, `tbl_lead_user_lnote`, `tbl_lead_user_lnote_date`, `tbl_lead_user_reason`, `tbl_lead_user_fdate`, `tbl_lead_user_fdate_flag`, `tbl_lead_user_sv_date`, `tbl_lead_user_sv_type`, `tbl_lead_user_sv_project_id`, `tbl_lead_user_sv_duration`, `tbl_lead_user_booking_date`, `tbl_lead_user_eoi_date`, `tbl_lead_user_status_marked_date`, `tbl_lead_user_sv_completed_date`, `tbl_lead_user_status`) VALUES
(2, 4, '8395828518', '', '2025-03-02 02:43:08.000000', 9, NULL, 4, 'Google Ads', 1, '2025-03-02 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00.000000', '2025-03-01 21:13:08.000000', '2025-03-02 13:43:08.065388', NULL, NULL, 'ADMIN', NULL, 0, 3, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'New');

-- --------------------------------------------------------

--
-- Table structure for table `tbl_lead_user_profile`
--

CREATE TABLE `tbl_lead_user_profile` (
  `tbl_lead_user_profile_id` int(11) NOT NULL,
  `tbl_lead_user_profile_name` varchar(255) DEFAULT NULL,
  `tbl_lead_user_profile_mobile` varchar(20) NOT NULL,
  `tbl_lead_user_profile_alt_mobile` varchar(20) DEFAULT NULL,
  `tbl_lead_user_profile_email` varchar(50) DEFAULT NULL,
  `tbl_lead_user_profile_cdate` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `tbl_lead_user_profile_edate` timestamp(6) NULL DEFAULT NULL ON UPDATE current_timestamp(6),
  `tbl_lead_user_profile_cuser` varchar(200) DEFAULT NULL,
  `tbl_lead_user_profile_euser` varchar(200) NOT NULL,
  `tbl_lead_user_profile_flag` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_lead_user_profile`
--

INSERT INTO `tbl_lead_user_profile` (`tbl_lead_user_profile_id`, `tbl_lead_user_profile_name`, `tbl_lead_user_profile_mobile`, `tbl_lead_user_profile_alt_mobile`, `tbl_lead_user_profile_email`, `tbl_lead_user_profile_cdate`, `tbl_lead_user_profile_edate`, `tbl_lead_user_profile_cuser`, `tbl_lead_user_profile_euser`, `tbl_lead_user_profile_flag`) VALUES
(4, 'Kamal Tomar', '8395828518', '', 'ravi@gmail.com', '2025-03-01 21:13:07.000000', NULL, 'ADMIN', '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_marketing_agency`
--

CREATE TABLE `tbl_marketing_agency` (
  `id` int(11) NOT NULL,
  `agency_name` varchar(250) NOT NULL,
  `cdate` datetime NOT NULL,
  `edate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_personal_info`
--

CREATE TABLE `tbl_personal_info` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `owner_email` varchar(50) NOT NULL,
  `mobile_no` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_project`
--

CREATE TABLE `tbl_project` (
  `tbl_project_id` int(11) NOT NULL,
  `tbl_project_name` varchar(255) DEFAULT NULL,
  `tbl_project_code` varchar(255) DEFAULT NULL,
  `tbl_project_api_url` varchar(500) DEFAULT NULL,
  `tbl_project_location` varchar(255) DEFAULT NULL,
  `tbl_project_address` varchar(300) DEFAULT NULL,
  `tbl_project_cdate` timestamp(6) NOT NULL DEFAULT current_timestamp(6),
  `tbl_project_edate` timestamp(6) NULL DEFAULT NULL ON UPDATE current_timestamp(6),
  `tbl_project_cuser` varchar(255) DEFAULT NULL,
  `tbl_project_euser` varchar(255) DEFAULT NULL,
  `tbl_project_flag` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_project`
--

INSERT INTO `tbl_project` (`tbl_project_id`, `tbl_project_name`, `tbl_project_code`, `tbl_project_api_url`, `tbl_project_location`, `tbl_project_address`, `tbl_project_cdate`, `tbl_project_edate`, `tbl_project_cuser`, `tbl_project_euser`, `tbl_project_flag`) VALUES
(8, 'Chandak Chembur', 'PRJ0001', 'https://crm.vistaarr.com/admin/api.php?pcode=PRJ0001', '3', 'Noida', '2025-03-01 22:16:02.000000', NULL, 'ADMIN', NULL, 0),
(9, 'DLF Property', 'PRJ0002', 'https://crm.vistaarr.com/admin/api.php?pcode=PRJ0002', '2', 'Gurgaon', '2025-03-01 22:16:45.000000', NULL, 'ADMIN', NULL, 0),
(10, 'M3M Noida', 'PRJ0003', 'https://crm.vistaarr.com/admin/api.php?pcode=PRJ0003', '3', 'Noida', '2025-03-01 22:17:09.000000', NULL, 'ADMIN', NULL, 0),
(11, 'Rohan Harita', 'PRJ0004', 'https://crm.vistaarr.com/admin/api.php?pcode=PRJ0004', '2', 'Gurgaon', '2025-03-01 22:18:02.000000', '2025-03-02 03:29:04.363555', 'ADMIN', NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `tbl_subfollowup`
--

CREATE TABLE `tbl_subfollowup` (
  `tbl_subfollowup_id` int(11) NOT NULL,
  `tbl_subfollowup_status_id` int(11) DEFAULT NULL,
  `tbl_subfollowup_status_name` varchar(255) DEFAULT NULL,
  `tbl_lead_user_id` int(11) NOT NULL,
  `tbl_subfollowup_date` datetime(6) DEFAULT NULL,
  `tbl_subfollowup_intent` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_reason` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_comment` varchar(500) DEFAULT NULL,
  `tbl_subfollowup_sv_scheduled_date` datetime(6) DEFAULT NULL,
  `tbl_subfollowup_sv_type` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_sv_project_id` int(11) DEFAULT NULL,
  `tbl_subfollowup_sv_project_name` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_sv_intent` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_sv_comment` varchar(500) DEFAULT NULL,
  `tbl_subfollowup_eoi_token_date` datetime(6) DEFAULT NULL,
  `tbl_subfollowup_eoi_project_id` int(11) DEFAULT NULL,
  `tbl_subfollowup_eoi_project_name` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_eoi_token_amount` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_eoi_validity_date` datetime(6) DEFAULT NULL,
  `tbl_subfollowup_eoi_unit_price` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_eoi_unit_no` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_eoi_token_comment` varchar(300) DEFAULT NULL,
  `tbl_subfollowup_booking_date` datetime(6) DEFAULT NULL,
  `tbl_subfollowup_booking_net_purchase_price` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_booking_amt_paid` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_booking_unit_no` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_cdate` timestamp(6) NULL DEFAULT current_timestamp(6),
  `tbl_subfollowup_edate` timestamp(6) NULL DEFAULT NULL ON UPDATE current_timestamp(6),
  `tbl_subfollowup_cuser` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_euser` varchar(255) DEFAULT NULL,
  `tbl_subfollowup_flag` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tbl_team`
--

CREATE TABLE `tbl_team` (
  `id` int(11) NOT NULL,
  `team_name` varchar(250) NOT NULL,
  `team_lead` varchar(250) NOT NULL,
  `user_id` int(11) NOT NULL,
  `team_description` varchar(255) NOT NULL,
  `flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_city`
--
ALTER TABLE `tbl_city`
  ADD PRIMARY KEY (`tbl_city_id`);

--
-- Indexes for table `tbl_company_info`
--
ALTER TABLE `tbl_company_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_events`
--
ALTER TABLE `tbl_events`
  ADD PRIMARY KEY (`tbl_events_id`);

--
-- Indexes for table `tbl_followup_status`
--
ALTER TABLE `tbl_followup_status`
  ADD PRIMARY KEY (`tbl_followup_status_id`);

--
-- Indexes for table `tbl_invite_user`
--
ALTER TABLE `tbl_invite_user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_lead`
--
ALTER TABLE `tbl_lead`
  ADD PRIMARY KEY (`tbl_lead_id`);

--
-- Indexes for table `tbl_lead_assign`
--
ALTER TABLE `tbl_lead_assign`
  ADD PRIMARY KEY (`tbl_lead_assign_id`);

--
-- Indexes for table `tbl_lead_import`
--
ALTER TABLE `tbl_lead_import`
  ADD PRIMARY KEY (`tbl_lead_import_id`);

--
-- Indexes for table `tbl_lead_source`
--
ALTER TABLE `tbl_lead_source`
  ADD PRIMARY KEY (`tbl_lead_source_id`);

--
-- Indexes for table `tbl_lead_user`
--
ALTER TABLE `tbl_lead_user`
  ADD PRIMARY KEY (`tbl_lead_user_id`);

--
-- Indexes for table `tbl_lead_user_profile`
--
ALTER TABLE `tbl_lead_user_profile`
  ADD PRIMARY KEY (`tbl_lead_user_profile_id`);

--
-- Indexes for table `tbl_personal_info`
--
ALTER TABLE `tbl_personal_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_project`
--
ALTER TABLE `tbl_project`
  ADD PRIMARY KEY (`tbl_project_id`);

--
-- Indexes for table `tbl_subfollowup`
--
ALTER TABLE `tbl_subfollowup`
  ADD PRIMARY KEY (`tbl_subfollowup_id`);

--
-- Indexes for table `tbl_team`
--
ALTER TABLE `tbl_team`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_city`
--
ALTER TABLE `tbl_city`
  MODIFY `tbl_city_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_company_info`
--
ALTER TABLE `tbl_company_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_events`
--
ALTER TABLE `tbl_events`
  MODIFY `tbl_events_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_followup_status`
--
ALTER TABLE `tbl_followup_status`
  MODIFY `tbl_followup_status_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_invite_user`
--
ALTER TABLE `tbl_invite_user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_lead`
--
ALTER TABLE `tbl_lead`
  MODIFY `tbl_lead_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=265;

--
-- AUTO_INCREMENT for table `tbl_lead_source`
--
ALTER TABLE `tbl_lead_source`
  MODIFY `tbl_lead_source_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `tbl_lead_user`
--
ALTER TABLE `tbl_lead_user`
  MODIFY `tbl_lead_user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_lead_user_profile`
--
ALTER TABLE `tbl_lead_user_profile`
  MODIFY `tbl_lead_user_profile_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_project`
--
ALTER TABLE `tbl_project`
  MODIFY `tbl_project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_subfollowup`
--
ALTER TABLE `tbl_subfollowup`
  MODIFY `tbl_subfollowup_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
