2024-08-20 08:06:10 +00:00
|
|
|
CREATE OR REPLACE DEFINER=`vn`@`localhost`
|
2024-01-15 11:31:03 +00:00
|
|
|
SQL SECURITY DEFINER
|
|
|
|
|
VIEW `vn`.`workerLabour`
|
|
|
|
|
AS SELECT `b`.`id` AS `businessFk`,
|
|
|
|
|
`b`.`workerFk` AS `workerFk`,
|
|
|
|
|
`b`.`workcenterFk` AS `workCenterFk`,
|
|
|
|
|
`b`.`started` AS `started`,
|
|
|
|
|
`b`.`ended` AS `ended`,
|
|
|
|
|
`b`.`departmentFk` AS `departmentFk`,
|
|
|
|
|
`b`.`payedHolidays` AS `payedHolidays`
|
|
|
|
|
FROM `vn`.`business` `b`
|
|
|
|
|
ORDER BY `b`.`started` DESC
|
