23 lines
712 B
SQL
23 lines
712 B
SQL
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
SQL SECURITY DEFINER
|
|
VIEW `vn2008`.`travel`
|
|
AS SELECT `t`.`id` AS `id`,
|
|
`t`.`shipped` AS `shipment`,
|
|
`t`.`shipmentHour` AS `shipment_hour`,
|
|
`t`.`landed` AS `landing`,
|
|
`t`.`landingHour` AS `landing_hour`,
|
|
`t`.`warehouseInFk` AS `warehouse_id`,
|
|
`t`.`warehouseOutFk` AS `warehouse_id_out`,
|
|
`t`.`agencyModeFk` AS `agency_id`,
|
|
`t`.`ref` AS `ref`,
|
|
`t`.`isDelivered` AS `delivered`,
|
|
`t`.`isReceived` AS `received`,
|
|
`t`.`m3` AS `m3`,
|
|
`t`.`kg` AS `kg`,
|
|
`t`.`cargoSupplierFk` AS `cargoSupplierFk`,
|
|
`t`.`totalEntries` AS `totalEntries`,
|
|
`t`.`appointment` AS `appointment`,
|
|
`t`.`awbFk` AS `awbFk`,
|
|
`t`.`daysInForward` AS `daysInForward`
|
|
FROM `vn`.`travel` `t`
|