November 14, 2022 at 12:00 am
Comments posted to this topic are about the item What's the Edge Case?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 15, 2022 at 3:53 pm
When designing the initial model for a database, I'd rather err on the side of tight constraints (ie: default to not-null if the business can't think of a good reason it would ever be NULL). If the business later says: "Hey, we get an error when we try to enter a PO for a tax exempt customer!", then it's no big deal for the DBA to deploy a single line of code to alter the constraint. Frankly, that's just spilled milk.
However, if you default to null, and the business says: "Ooops! We entered several dozen PO last month without adding sales tax.", then that's potentially a big mess to straighten out for everybody.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply