9 lines
321 B
MySQL
9 lines
321 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`consignatarios_observation`
|
||
|
|
AS SELECT `co`.`id` AS `consignatarios_observation_id`,
|
||
|
|
`co`.`addressFk` AS `Id_Consigna`,
|
||
|
|
`co`.`observationTypeFk` AS `observation_type_id`,
|
||
|
|
`co`.`description` AS `text`
|
||
|
|
FROM `vn`.`addressObservation` `co`
|