| flight_id | capacity | | --------- | -------- | | 1 | 2 | | 2 | 2 | | 3 | 1 |

| passenger_id | flight_id | booking_time | | ------------ | --------- | ------------------- | | 101 | 1 | 2023-07-10 16:30:00 | | 102 | 1 | 2023-07-10 17:45:00 | | 103 | 1 | 2023-07-10 12:00:00 | | 104 | 2 | 2023-07-05 13:23:00 | | 105 | 2 | 2023-07-05 09:00:00 | | 106 | 3 | 2023-07-08 11:10:00 | | 107 | 3 | 2023-07-08 09:10:00 |