Merge tables with a direct dependency on resourceId with the resource table
Virtual Research Environment / On-line Bibliography Manager
Brought to you by:
sirfragalot
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.