Livoa LogoLivoa
User


user_id (PK)

password

disability_type

email

mobility_aids

full_name

phone

Reviews


review_id (PK)

location_id (FK)

companion_id (FK)

user_id (FK)

rating

comment

Companion


companion_id (PK)

hourly_rate

total_reviews

availability

valid_from

valid_until

Booking


booking_id (PK)

payment_id (FK)

user_id (FK)

companion_id (FK)

total_amount

scheduled_start

scheduled_end

cancellation

special_instructions

Payment


payment_id (PK)

total_amount

payment_method

paid_at

currency

Bank


Bank_id (PK)

payment_id (FK)

Location


location_id (PK)

government_id (FK)

address

sequence

name

estimated_arrival

actual_arrival

Government


government_id (PK)

Accessible locations

Accessibility_report


report_id (PK)

location_id (FK)

wide_entrance

verified

elevator_available

ramp_available

wheelchair_accessible

accessible_parking

ERD2

by Omar

0
0 uses