ZX-Art production = ZXDB entry
ZX-Art release = ZXDB release (currently I sticked to downloads of particular type but I will change this to use releases)
Software (production, ZXDB entry) can have original author, screenshots, comments, year of first publication
Release can have year, publisher, additional authors, additional screenshots, additional comments and most importantly - file download.
Thanks! I totally agree, I'll just use the releases table now. That download table usage decision is legacy which I will change.
I think that both program (production, entry) and release should be commentable. Some releases can be mods which fix the issues, add new materials, change the graphics but still remain the same game. So there can be real need to comment them.Einar Saukas wrote: ↑Wed Apr 11, 2018 2:40 pmAlso I think it makes sense to assign comments to the release, instead of individual files. Even if a game has separate 48K and 128K versions, and I want to comment specifically about the AY music in 128K, it's still better to put this comment once in the release, instead of repeating this comment in the English 128K file and again in the Spanish 128K file. Or if I want to say that parts 1 and 2 are better than part 3, a single comment on the release still works better than separate comments on the file of each part.
Thank you! That really seems logical.Einar Saukas wrote: ↑Wed Apr 11, 2018 2:40 pmReleases are static non-changeable numeric IDs. You can rely on them!
The only chance RELEASE_SEQ will change, is if we find out that a release was duplicated by mistake. But this is no different than finding out an entire entry was duplicated by mistake so an ENTRY_ID should be removed. Anyway removing either ENTRY_ID or RELEASE_SEQ will happen very very rarely, and when it happens I will announce it here so you can easily adjust it manually on your side.