id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,difficulty
2495,Denormalize subtype field in entities table,ewinslow,,"We should put the subtype name straight into the entities table instead of having to go look for it in the subtypes table.  Since type/subtype pairs are unique, the pair can be used to grab the appropriate row from the subtypes table whenever it's needed.  This change would save us a join whenever we query for entities.",Enhancement,closed,normal,Near Term Future Release,Core,1.7,minor,wontfix,,brettp,easy