[New post] Determining Nullability of a column

ricksonmenezes posted: " It seems very common sensical but still are common mistakes made by table modelling. You have a workflow that allows Open, Assigned, InProgress, Done, Cancelled status but the Status column in the DB allows Null. If the Status column in DB is designe" Respond to this post by replying above this line New post on Trying to post some tech ideas that enthused me. Determining Nullability of a column by ricksonmenezes It seems very common sensical but still are common mistakes made by table modelling. You have a workflow that allows Open, Assigned, InProgress, Done, Cancelled status but the Status column in the DB allows Null. If the Status column in DB is designed to be NOT NULL, you can catch application code bugs when database rejects the Insert/Update up front instead of finding data later where the Status column is missing. This free site is ad-supported. Learn more ​ ricksonmenezes | August 11, 2021 at 6:34 am | Categories: Database | URL: https://wp.me/pbx99M-T5 Comment    See all comments    Like Unsubscribe to no longer receive posts from Trying to post some tech ideas that enthused me.. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://stackoverblow.wordpress.com/2021/08/11/determining-nullability-of-a-column/ Thanks for flying with WordPress.com