// by Kristian Allikmaa

CREATE v_showtravels_for_user AS
SELECT t.id, t.departure, t.arrival, t.price, t.seats_total,
c_from.city_name AS from_city, c_from.id AS from_city_id, c_to.city_name
AS to_city, c_to.id AS to_city_id, t_from.terminal_name AS from_terminal,
t_from.id AS from_terminal_id, t_to.terminal_name AS to_terminal, t_to.id
AS to_terminal_id, o.operator_name, o.id as operator_id, s.ship_name,
s.id as ship_id
FROM travels AS t
LEFT JOIN terminals AS t_from ON (t_from.id = t.terminal_from_id)
LEFT JOIN terminals AS t_to ON (t_to.id = t.terminal_to_id)
LEFT JOIN cities AS c_from ON (c_from.id = t_from.city_id)
LEFT JOIN cities AS c_to ON (c_to.id = t_to.city_id)
LEFT JOIN ships AS s ON (s.id = t.ship_id)
LEFT JOIN operators AS o ON (o.id = s.operator_id);