Ich werde Hoteldaten aus bookingdotcom in SQL-Datenbank extrahieren

Ich habe bereits ein Python-Skript erstellt, das alle Datensätze von booking.com zieht

Hier ist eine Liste einiger Datensätze, die es in die Datenbank lädt;

Hotels Tabelle

1. hotel_type
2. hotel_name
3. no_of_stars
4. address
5. description
6. url
7. pool
8. airport_shuttle
9. spa_wellness_centre
10. fitness_centre
11. family_rooms
12. facilities_for_disabled_guests
13. parking
14. free_parking
15. pets_allowed
16. room_service
17. free_wifi
18. tea_coffee_maker_in_all_rooms
19. restaurant
20. bar
21. breakfast
22. breakfast_rating
23. breakfast_number_of_reviews
24. garden
25. wifi_all_areas
26. all_facilities

Hotel-Bewertungstabelle

1. overall
2. cleanliness
3. comfort
4. facilities
5. free_wifi
6. location
7. value_for_money
8. number_of_reviews

Zimmer Tabelle

1. room_name
2. room_size
3. air_conditioning
4. coffee_machine
5. free_wifi
6. minibar
7. soundproofing
8. tv
9. balcony
10. private_room
11. private_suite
12. dormitory
13. shared_dormitory
14. bath
15. private_bathroom
16. ensuite_bathroom
17. shared_bathroom
18. beds_single
19. beds_double
20. beds_large_double
21. beds_extra_large_double
22. beds_sofa
23. beds_bunk
24. additional_important
25. further_facilities

Hotelangebote Tabelle

1. checkin
2. checkout
3. price
4. sleeps
5. breakfast_included
6. breakfast_optional
7. breakfast_text
8. meals
9. free_cancellation_until
10. free_cancellation_text
11. prepayment
12. prepayment_text

Gib mir Bescheid, wenn du mehr brauchst