Attraction Airport taxi

Name Price Pick-up location Date

(name) (price) (pickup_location) (date)
Data Type: string Data Type: int Data Type: string Data Type: date

0..1 0..1
Date Location Destination Price
(date) (location) (destination) (price)
Data Type: date Data Type: string Data Type: string Data Type: int

Review Type taxi Number of passengers

(review) (type_taxi) (num_of_passengers)
Data Type: string Data Type: enum Data Type: int

0..1 0..1

User Reservation
Car rental
User ID User name Date
Location
(user_id) (user_name)
Pick-up location Drop-off location Data Type: int Data Type: string Check In Date Check Out Date
Trip
(pickup_location) (dropoff_location) (checkin) (checkout)
Data Type: string Data Type: string Trip ID Data Type: Date Data Type: Date
Email Age
(utrip_id)
0..1 1..1 (email) (age)
1..1 0..* Data Type: string 1..1 1..*
Date Data Type:string Data Type: int
Info
Device
Pick-up date Drop-off date Number of reservations (device_class)
Password Address
(pickup_date) (dropoff_date) (num_of_reservations)
(password) (address) Data Type: enum
Data Type: date Data Type: date Data Type: int Booker Country
Data Type: string Data Type: int
(booker_country)
Data Type: string Affiliate channels ID
Rental price Phone number (affiliate_id)
(price) (phone_number) Data Type: int
Data Type: int Data Type: int

0..* 1..*
1..1

1..1 1..1
0..*
Car Stay
Flight
Company Location
Time
Company name Company review Layover Length Hotel Country Hotel City
(company_name) (company_review) (layover) (hotel_country) (city_id)
Data Type: string Data Type: string Data Type: int Data Type: string Data Type: int

Flight Time Date

Info Main info
(flight_time) (date)
Data Type: int Data Type: date
Car category Car specs Room Type Description
(car_categoty) (car_specs) (room_type) (stay_description)
Data Type: string Data type: String Data Type: enum Data Type: string
Ticket
Allowed baggage
(allowed_baggage) Today's price Reviews
Data Type: string (price) (review)
Data Type: int Data Type: string
Class Ticket price
(Class) (price)
Data Type: enum Data Type: int

Route
Flight code Airports names
(flight_code) (airports_names)
Data Type: string Data Type: string

0..*

1..*

Airplaine

Airlines Company
(airlines_company)
Data Type: string