integrated table and relationships for the recurring alerts