database table and dtos for range-based action