Airports
id | name | location | IATA_Code | ICAO_Code | airport_services |
1 | New York JFK | Queens, New York | JFK | NYJF | Lost Property |
2 | Los Angeles LAX | Los Angeles, California | LAX | KLAX | Lost Property |
Services
id | service_name |
1 | Lost Property |
2 | Customer Complaints |
ServiceOfferings
id | airport_id | service_id | date |
| (→ Airports.id) | (→ Services.id) | |
1 | 1 | 1 | 2023-12-01 |
2 | 2 | 2 | 2023-12-01 |
3 | 1 | 1 | 2024-01-05 |
4 | 2 | 2 | 2024-01-06 |
CustomerComplaints
complaint_id | airport_service_offering_id | customer_complaint |
| (→ ServiceOfferings.id) | |
1 | 1 | Delayed baggage claim |
2 | 2 | Unclean restrooms |
3 | 3 | Poor wifi connection |
4 | 4 | Lack of seating |