
--
-- Final view structure for view `V_STUDENT_MARK_SEQ12_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ12_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ12_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '12') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ13_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ13_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ13_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '13') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ13_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ13_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ13_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '13') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '14') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ14_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ14_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ14_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '14') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '15') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '15') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '15') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ15_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ15_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ15_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '15') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '16') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ16_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ16_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ16_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '16') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ17_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ17_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ17_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '17') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ17_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ17_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ17_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '17') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ18_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ18_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ18_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '18') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ18_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ18_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ18_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '18') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '19') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '19') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '19') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ19_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ19_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ19_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '19') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '1') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '1') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '1') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ1_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ1_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ1_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '1') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ20_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ20_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ20_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '20') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '21') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ21_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ21_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ21_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '21') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ23_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ23_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ23_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '23') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ24_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ24_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ24_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '24') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ25_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ25_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ25_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '25') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ26_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ26_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ26_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '26') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ27_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ27_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ27_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '27') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ28_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ28_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ28_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '28') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ29_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ29_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ29_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '29') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ2_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ2_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ2_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '2') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ30_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ30_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ30_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '30') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ3_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ3_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ3_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '3') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ4_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ4_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ4_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '4') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ5_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ5_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ5_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '5') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_46`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_46`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_46` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '46')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_47`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_47`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_47` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '47')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_49`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_49`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_49` AS select distinct `eval`.`id` AS `eval`,`crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`room`.`id` AS `room`,`std`.`id` AS `std`,`teach`.`full_name` AS `teacher`,`modu`.`id` AS `module`,`m`.`value` AS `value`,`m`.`weight` AS `weight` from (((((((((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `attribution` `att` on(((`att`.`course_id` = `crs`.`id`) and (`att`.`year_id` = '8')))) join `user` `teach` on((`att`.`teacher_id` = `teach`.`id`))) join `module` `modu` on((`modu`.`id` = `crs`.`module_id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) left join `abscence_sheet` `sheet` on(((`seq`.`id` = `sheet`.`sequence_id`) and (`sheet`.`class_room_id` = `room`.`id`)))) left join `abscence` `abs` on((`sheet`.`id` = `abs`.`abscence_sheet_id`))) join `quater` `quat` on((`seq`.`quater_id` = `quat`.`id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '49')) order by `room`.`id`,`modu`.`id`,`std` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ6_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ6_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ6_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '6') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ7_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ7_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ7_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '7') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ8_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ8_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ8_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '8') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_51`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_51`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_51` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '51')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_MARK_SEQ9_53`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_MARK_SEQ9_53`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_MARK_SEQ9_53` AS select distinct `crs`.`id` AS `crs`,`crs`.`coefficient` AS `coef`,`std`.`id` AS `std`,`m`.`value` AS `value`,`m`.`weight` AS `weight`,`eval`.`mini` AS `mini`,`eval`.`maxi` AS `maxi` from (((((`mark` `m` join `student` `std` on((`m`.`student_id` = `std`.`id`))) join `evaluation` `eval` on((`m`.`evaluation_id` = `eval`.`id`))) join `class_room` `room` on((`eval`.`class_room_id` = `room`.`id`))) join `course` `crs` on((`eval`.`course_id` = `crs`.`id`))) join `sequence` `seq` on((`seq`.`id` = `eval`.`sequence_id`))) where ((`room`.`id` = '9') and (`eval`.`sequence_id` = '53')) order by `std`,`crs` */;

--
-- Final view structure for view `V_STUDENT_RANKS`
--

/*!50001 DROP VIEW IF EXISTS `V_STUDENT_RANKS`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`bethesda`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `V_STUDENT_RANKS` AS select `V_STUDENT_MARK_QUATER`.`std` AS `std`,cast((sum(((`V_STUDENT_MARK_QUATER`.`value` * `V_STUDENT_MARK_QUATER`.`weight`) * `V_STUDENT_MARK_QUATER`.`coef`)) / sum((`V_STUDENT_MARK_QUATER`.`weight` * `V_STUDENT_MARK_QUATER`.`coef`))) as decimal(4,2)) AS `moyenne`,sum((`V_STUDENT_MARK_QUATER`.`weight` * `V_STUDENT_MARK_QUATER`.`coef`)) AS `totalCoef` from `V_STUDENT_MARK_QUATER` group by `V_STUDENT_MARK_QUATER`.`std` order by sum(((`V_STUDENT_MARK_QUATER`.`value` * `V_STUDENT_MARK_QUATER`.`weight`) * `V_STUDENT_MARK_QUATER`.`coef`)) desc */;


