| 1 | create view BaggageDetails (PassengerId, Name, Surname, DateOfBirth, TicketId, FlightId, FlightNumber, Origin, Destination, BaggageID,
|
|---|
| 2 | BaggageType, StatusType, Timestamp, StatusAirport) as
|
|---|
| 3 | select passenger.id, passenger.name, passenger.surname, passenger.dateofbirth,
|
|---|
| 4 | ticket.id, flight.id, flight.flightnumber, departureAirport.code, arrivalAirport.code,
|
|---|
| 5 | baggage.id, baggagetype.name, baggagestatustype.name,
|
|---|
| 6 | baggagestatus.timestamp,statusAirport.code
|
|---|
| 7 | from ticket
|
|---|
| 8 | join baggage on baggage.ticketid = ticket.id
|
|---|
| 9 | join baggagestatus on baggage.id = baggagestatus.baggageid
|
|---|
| 10 | join baggagestatustype on baggagestatus.baggagestatustypeid = baggagestatustype.id
|
|---|
| 11 | join baggagetype on baggage.baggagetypeid = baggagetype.id
|
|---|
| 12 | join flight on ticket.flightid = flight.id
|
|---|
| 13 | join gate as departureGate on departureGate.id = flight.actualgatedepartureid
|
|---|
| 14 | join gate as arrivalGate on arrivalGate.id = flight.actualgatearrivalid
|
|---|
| 15 | join terminal as departureTerminal on departureTerminal.id = departureGate.terminalid
|
|---|
| 16 | join terminal as arrivalTerminal on arrivalTerminal.id = arrivalGate.terminalid
|
|---|
| 17 | join airport as departureAirport on departureAirport.id = departureTerminal.airportid
|
|---|
| 18 | join airport as arrivalAirport on arrivalAirport.id = arrivalTerminal.airportid
|
|---|
| 19 | join airport as statusAirport on statusAirport.id = baggagestatus.airportid
|
|---|
| 20 | join passenger on ticket.passengerid = passenger.id;
|
|---|
| 21 |
|
|---|
| 22 |
|
|---|
| 23 |
|
|---|
