This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am working on jforum. I did not see any foreigh keys in MySQL schema. In the jforum_model document I see the relationships, but the relationships are not reflected in the database schema.
Can anyone explain this?
Thank you very much.
David [originally posted on jforum.net by davidxia]
Migrated From Jforum.net
Joined: Apr 22, 2012
Don't know for sure but I'd guess it's for simplicity across all the different DB's jForum supports. Some of them don't (or didn't at creation time) support foreign key constraints.
Plus hard constraints sometime make it harder to set up the initial data and do extracts from production to test sites. Not good DB schema practice, but there is no performance hit for not having these.
Then again, it could just be because Rafael's more interested in code that DB modeling...lol