Software development experience collection

1. If the data range of smalldatetime can meet your requirements, do not use datetime.

2. When the data is deleted, it is only deleted.
Id. For example, if deletemark is set to 1, the data is deleted but not deleted. 0 indicates that the data is valid.

Although this is a good starting point, the problem is coming up. Let's write allProgramThe logic and judgment of is to add a condition, that is, deletemark = 0.
The data is the valid data. Even though a simple requirement is added, you need to add a flag for judgment on the whole. In fact, the workload is
There will be a lot more, so sometimes, for a simple function implementation, there will be a lot of extra work, extra effort, this
It depends on what effect you want to achieve.

Of course, you can also create a view. For example, a view is deleted and a view is not deleted.
For logical operations, the workload of the program will be much smaller, and some modifications may be enough. However, these operations are all very high.
Only by understanding this truth can we conclude that, including myself, there will be many detours to understand this. This will only happen in the next system.
Experience.

3. Page form: JS verification, which is mandatory