AIFrontdesk
-

Room inventory (from rooms table)

Totals by room type
Room typeRooms

Availability breakdown

Adapter output
-
DateRoom typeAvailableBookedPhysical

Notes

What’s next
If the availability breakdown is empty, it usually means reservations don’t have room_type_id or there is no inventory/rate grid loaded yet. We can backfill room_type_id once room type labels exist, then availability becomes meaningful.