--
-- Host: localhost    Database: kfv.prod
-- ------------------------------------------------------


--
-- Final view structure for view `v_wehrfuehrer`
--

/*!50001 DROP VIEW IF EXISTS `v_wehrfuehrer`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`poeschl`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_wehrfuehrer` AS select `f`.`kbmbereich` AS `kbmbereich`,`f`.`feuerwehr` AS `feuerwehr`,`u`.`vorname` AS `vorname`,`u`.`name` AS `name`,`u`.`email` AS `email`,`w`.`rolle` AS `rolle`,`f`.`id_feuerwehr` AS `id_feuerwehr`,`w`.`id_wehrfuehrer` AS `id_wehrfuehrer`,`w`.`id_user` AS `id_user` from ((`wehrfuehrer` `w` join `feuerwehr` `f`) join `user` `u`) where `w`.`id_feuerwehr` = `f`.`id_feuerwehr` and `w`.`id_user` = `u`.`id_user` and `w`.`aktiv` = 1 */;



