I've modified the schema slightly to incorporate your suggestions. What I'm struggling with now is how using this schema I'd deal with tickets that are currently in an open state per day ( keeping in mind that an open ticket might not necessarily have any information associated with a particular day ) without doing some horrible looking SQL.