salix/db/routines/vn2008/views/awb_component_template.sql

20 lines
660 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`awb_component_template`
AS SELECT`act`.`id` AS `awb_component_template_id`,
`act`.`freightFk` AS `carguera_id`,
`act`.`airportIn` AS `airport_in`,
`act`.`airportOut` AS `airport_out`,
`act`.`airlineFk` AS `airline_id`,
`act`.`typeFk` AS `awb_component_type_id`,
`act`.`dated` AS `Fecha`,
`act`.`awbRoleFk` AS `awb_role_id`,
`act`.`awbUnit` AS `awb_unit_id`,
`act`.`value` AS `value`,
`act`.`maxValue` AS `max_value`,
`act`.`minValue` AS `min_value`,
`act`.`currencyFk` AS `Id_Moneda`,
`act`.`days` AS `days`
FROM
`vn`.`awbComponentTemplate` `act`;