Project categories and data integrity
Posted: 30 Mar 2005, 06:51
A user of my local Mantis install pointed out something strange in the category filter. In the drop down there are categories that do not exist as categories for the project.
I looked at the mantis_bug_table and there is category as a string field not as a foreign key like project_id, reporter_id etc. I am guessing these categories did exist in the past, but had since been deleted.
2 questions:
-Is my understanding of this situation correct?
-Why is it done this way? For Performance? I may be a bit of a nazi about database design, but a strict foreign key link seems the way to go for me.
I looked at the mantis_bug_table and there is category as a string field not as a foreign key like project_id, reporter_id etc. I am guessing these categories did exist in the past, but had since been deleted.
2 questions:
-Is my understanding of this situation correct?
-Why is it done this way? For Performance? I may be a bit of a nazi about database design, but a strict foreign key link seems the way to go for me.