Menu

#710 Merge tables with a direct dependency on resourceId with the resource table

Unknown
open
None
Unknown
Improvement
Unknown
Unknown
Unknown
Unknown
2025-03-27
2025-03-27
No

The resource, resource_misc, resource_page, resource_text, resource_timestamp, and resource_year tables should be a single table. Rounding up to the nearest ten, that's only 60 fields. Not much for MySQL.

This ensures that all the main fields of a resource always exist upon creation, it removes 5 joins, simplifiy access, and it allows for simpler timestamp updates.

Discussion


Log in to post a comment.