fixed associations and added indexes to reservation table