Livoa LogoLivoa
AIRLINE
AirlineName
AirlineCode
Country
FLIGHT
ListedPrice
FlightNumber
AirlineCode (FK)
SmokingAllowedIndicator
BusinessClassIndicator
CITY
Country
CityName
AirportTax
CURRENCY
CurrencyCode
CurrencyName
EXCHANGE_RATE
ExchangeRate
RateDate (Partial Key)
CurrencyCode (Partial Key)
BOOKING
AmountPaidSoFar
BookingDate
BookingCity (FK)
StatusIndicator
BookingNumber
ClassIndicator
OutstandingBalance
PassengerFirstName
PassengerLastName
ResponsibleCustomerID (FK)
TotalPrice
CUSTOMER
LastName
CustomerID
FirstName
AddressID (FK)
ADDRESS
AddressID
Street
City
PostalCode
ProvinceState
Country
EMAIL
EmailAddress
PHONE
CountryCode (Partial Key)
LocalNumber (Partial Key)
AreaCode (Partial Key)
FAX
CountryCode (Partial Key)
AreaCode (Partial Key)
LocalNumber (Partial Key)
FLIGHT_AVAILABILITY
FlightNumber (Partial Key)
DepartureDateTime (Partial Key)
ArrivalDateTime
BookedEconomySeats
BookedBusinessSeats
TotalEconomySeats
TotalBusinessSeats

er

by bobby

0
0 uses