-- http://www.phpmyadmin.net
--




--
-- Database: `vafa_5`
--

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

--
-- Structure for view `project_crm_enquiry`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `project_crm_enquiry`  AS  select `CPM`.`project_name` AS `project_name`,`CE`.`enquiry_id` AS `enquiry_id`,`CE`.`enquiry_number` AS `enquiry_number`,`CE`.`project_id` AS `project_id`,`CE`.`site_id` AS `site_id`,`CE`.`name` AS `name`,`CE`.`cell` AS `cell`,`CE`.`email` AS `email`,`CE`.`company` AS `company`,`CE`.`location` AS `location`,`CE`.`source` AS `source`,`CE`.`remarks` AS `remarks`,`CE`.`interest_status` AS `interest_status`,`CE`.`walk_in` AS `walk_in`,`CE`.`follow_up_date` AS `follow_up_date`,`CE`.`assigned_to` AS `assigned_to`,`CE`.`assigned_on` AS `assigned_on`,`CE`.`added_by` AS `added_by`,`CE`.`added_on` AS `added_on`,`U`.`user_name` AS `user_name`,`U`.`user_id` AS `user_id`,`CIS`.`crm_cust_interest_status_id` AS `crm_cust_interest_status_id`,`CIS`.`crm_cust_interest_status_name` AS `crm_cust_interest_status_name`,`ESM`.`enquiry_source_master_name` AS `enquiry_source_master_name`,`ESM`.`enquiry_source_master_id` AS `enquiry_source_master_id` from ((((`crm_enquiry` `CE` left join `crm_project_master` `CPM` on((`CPM`.`project_id` = `CE`.`project_id`))) join `crm_enquiry_source_master` `ESM` on((`ESM`.`enquiry_source_master_id` = `CE`.`source`))) join `crm_customer_interest_status` `CIS` on((`CIS`.`crm_cust_interest_status_id` = `CE`.`interest_status`))) join `users` `U` on((`U`.`user_id` = `CE`.`assigned_to`))) ;

--
-- VIEW  `project_crm_enquiry`
-- Data: None
--


