simplify schema #112
Replies: 1 comment
-
Please revisit the purpose of the CatSubCat table and if it's really needed. It's causing duplicate categories to show up for any help service that are in two subcategories in the same category. I have not seen any problems in the code, but it looks funny and is confusing. A data entry person could "clean up the dupes" and it might have the unintended consequence of also deleting the sub-cat. Any time you see a knot of relations like that in the DB it's a trigger to review the relationships. One trick for reading the DB is saying "have" for the relations. So following from table to table reads like "Customer has Orders". In our case "Categories have Subcategories, and Subcategories have Help Services. Help Services have categories and Subcategories" etc. The tables are nouns and the relations are verbs. If a table is acting like a verb, you might be able to remove it. |
Beta Was this translation helpful? Give feedback.
-
I added two additional tables for Alerts and Infos to support the requests from Little Help Book for the Wildfires. I noticed some additional fields that look suspect. I didn't take the time to research the code to see what's extra and what being used. If might be an appropriate time to review the schema with an eye toward simplification.
Beta Was this translation helpful? Give feedback.
All reactions