## 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