Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Why there is no foreign key in the schema?

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, all.

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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


[originally posted on jforum.net by monroe]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic