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




--
-- Database: `vafa_5`
--

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

--
-- Structure for view `project_process_task_list`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `project_process_task_list` AS select `PPPT`.`project_process_task_id` AS `project_process_task_id`,`PPPT`.`project_process_id` AS `project_process_id`,`PPPT`.`project_process_task_type` AS `project_process_task_type`,`PPP`.`project_plan_process_id` AS `project_plan_process_id`,`PPP`.`project_plan_process_name` AS `project_plan_process_name`,`PTM`.`project_task_master_id` AS `project_task_master_id`,`PTM`.`project_task_master_name` AS `project_task_master_name`,`PTM`.`project_task_master_process` AS `project_task_master_process`,`PTM`.`project_task_master_order` AS `project_task_master_order`,`PMPM`.`project_management_master_id` AS `project_management_master_id`,`PMPM`.`project_master_name` AS `project_master_name`,`PSLMM`.`project_site_location_mapping_master_id` AS `road_id`,`PSLMM`.`project_site_location_mapping_master_name` AS `road_name` from (((((((`project_plan_process_task` `PPPT` join `project_plan_process` `PPP` on((`PPP`.`project_plan_process_id` = `PPPT`.`project_process_id`))) join `project_task_master` `PTM` on((`PTM`.`project_task_master_id` = `PPPT`.`project_process_task_type`))) join `users` `U` on((`U`.`user_id` = `PPP`.`project_plan_process_assigned_user`))) join `project_process_master` `PPM` on((`PPM`.`project_process_master_id` = `PPP`.`project_plan_process_name`))) join `project_plan` `PP` on((`PP`.`project_plan_id` = `PPP`.`project_plan_process_plan_id`))) join `project_management_project_master` `PMPM` on((`PMPM`.`project_management_master_id` = `PP`.`project_plan_project_id`))) left join `project_site_location_mapping_master` `PSLMM` on((`PSLMM`.`project_site_location_mapping_master_id` = `PPPT`.`project_process_task_location_id`)));

--
-- VIEW  `project_process_task_list`
-- Data: None
--


