Funcoes
database
create
001-trip_scheduling.sql +4 -0
query
001-function_create_trip_scheduling.sql +2 -2
schema-diagrams
db_schema.dia +0 -0
@@ -79,6 +79,8 @@ create table trip(
@@ -104,6 +106,8 @@ create table trip_history(
@@ -26,10 +26,10 @@ CREATE OR REPLACE FUNCTION create_compleate_user
(justification_trip VARCHAR(255), id_trip_user_trip INT, external_funding_trip BOOLEAN, id_destination_trip INT, id_stauts_trip INT, data_departure_trip DATE, time_departure_trip TIME, arrival_time_trip TIME, company_departure_trip VARCHAR(255), price_departure_trip FLOAT, date_return_trip DATE, time_return_trip TIME, arrival_time_return_trip TIME, company_return_trip VARCHAR, price_return_trip FLOAT, observation_trip TEXT, need_hotel_trip BOOLEAN) RETURNS VOID
(justification_trip VARCHAR(255), id_trip_user_trip INT, external_funding_trip BOOLEAN, id_destination_trip INT, id_stauts_trip INT, data_departure_trip DATE, time_departure_trip TIME, arrival_time_trip TIME, company_departure_trip VARCHAR(255), price_departure_trip FLOAT, date_return_trip DATE, time_return_trip TIME, arrival_time_return_trip TIME, company_return_trip VARCHAR, price_return_trip FLOAT, flight_code_departure_trip INT, flight_code_return_trip INT, observation_trip TEXT, need_hotel_trip BOOLEAN) RETURNS VOID
INSERT INTO trip(justification, id_trip_user, external_funding, id_destination, id_status, date_departure, time_departure, company_departure, price_departure, date_return, time_return, arrival_time_return, company_return, price_return, price_return, observation, need_hotel) VALUES (justification_trip, id_trip_user_trip, external_funding_trip, id_destination_trip, id_status_trip, date_departure_trip, time_departure_trip, arrival_time_trip, company_departure_trip, price_departure_trip, date_return_trip, time_return_trip, arrival_time_return_trip, company_return_trip, price_return_trip, observation_trip, need_hotel_trip);
INSERT INTO trip(justification, id_trip_user, external_funding, id_destination, id_status, date_departure, time_departure, company_departure, price_departure, date_return, time_return, arrival_time_return, company_return, price_return, price_return, flight_code_departure, flight_code_return, observation, need_hotel) VALUES (justification_trip, id_trip_user_trip, external_funding_trip, id_destination_trip, id_status_trip, date_departure_trip, time_departure_trip, arrival_time_trip, company_departure_trip, price_departure_trip, date_return_trip, time_return_trip, arrival_time_return_trip, company_return_trip, price_return_trip,flight_code_departure_trip, flight_code_return_trip, observation_trip, need_hotel_trip);
No preview for this file type