I'm building an application that processes user-uploaded images through an API. Each image goes through multiple stages: - Uploaded - Queued - Processed - Completed I'm curious how others design MySQL tables for this type of workflow. Do you use separate tables for jobs and results, or a single table with status columns?
I haven't done that but it makes sense to be a single table with a status. There's no value-add to having separate tables if the only difference in the data stored is the status. If you desperately need to see them separately you can always create views.