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