Database Design Learning Record

1. reduce the range to the minimum add a personal asset table if you have a personal asset. We just need to add a table directly to achieve it. Narrow it down to the minimum range directly. The Direct Design Library inventory table contains the personal ID field and the Department ID field (the Department field exists because it is possible for a person to have multiple identities that cannot be differentiated) so that the individual can find the assets of the owning department. Find the assets of the owning company.
2. Merge Conditional dead value field, the same display function can consider merging fields into a field, the Post status ID and the re-edit ID effect are used to show the announcement information, two fields can be merged into (1 published, 2 unpublished edited, 3 unpublished unedited) This will achieve the same tone effect. But whether the top is not merged inside because the top is used to make the announcement whether the feature is sticky. And just two fields are used to show the announcement, two completely different functions of the field is not able to merge. The announcement publication object type is also a feature that shows whether an announcement is displayed. Why not merge, if the merging of two conditions is 2*3 is 6 conditions, but this will lead to write a very long SQL does not make the program better. Therefore, the announcement publication object Type field cannot be merged. Same as the audit status. It will 3*3 more after merging.

3. The General database design field, there is a title need to have a description, why not use the content it. Description if you are using a hint, but the content field tends to have a value with an HTML tag. There are a lot of problems when you show a hint.

Database Design Learning Record