13 lines
412 B
MySQL
13 lines
412 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`cl_cau`
|
||
|
|
AS SELECT `c`.`id` AS `id`,
|
||
|
|
`c`.`claimFk` AS `cl_main_id`,
|
||
|
|
`c`.`claimResponsibleFk` AS `cl_res_id`,
|
||
|
|
`c`.`workerFk` AS `Id_Trabajador`,
|
||
|
|
`c`.`claimReasonFk` AS `cl_mot_id`,
|
||
|
|
`c`.`claimResultFk` AS `cl_con_id`,
|
||
|
|
`c`.`claimRedeliveryFk` AS `cl_dev`,
|
||
|
|
`c`.`claimDestinationFk` AS `cl_sol`
|
||
|
|
FROM `vn`.`claimDevelopment` `c`
|