In the foreground and background are set on the check, I will not empty fields in a database table is set to null, this design is reasonable?

CodePudding user response:

No problem, the primary key automatically for an empty
Set too much test database, such as foreign key constraints, sometimes backup recovery will have trouble,

CodePudding user response:

Taiwan before and after you have set up check, why want to put the database Settings can be empty, the database is the data of the last line of defense, no special circumstances do not recommend to open the gap, so you can quickly locate if an error to the front and back end constraints, which gave an issue, but also can avoid the dirty data warehousing, fully staffed why not?