On 10/31/2017 4:26 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:
At the day gig, they use FK constraints and References in their Oracle database schema. Honestly, I got into that years ago with VFP but then kinda fell off that wagon over the years, preferring to just handle some things in the BizObj of the solution rather
For large applications (500+ tables) I usually require it. Smaller apps... eh... I think there would still be benefits but I'm usually building them so fast that end users won't take the time to provide a complete enough picture to drive all RI rules. Sure, I could still do them on my "internal design only" tables, but like you said, there is some overhead associated. So in the smaller cases it's pretty situational as to whether or not I use it.
My attitude is, generally, the more you can put "into" the database, that "belongs" in the database, the better flexibility, maintainability, and stability you'll get.
-Charlie