1. 

   rmbg Greenhorn

   Messages:

   4

   Likes Received:

   0

   Best Answers:

   0

   Trophy Points:

   11

   #1

   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?
   

    

   rmbg, Jun 3, 2026 at 11:59 PM IP
   
2. 

   sarahk iTamer Staff

   Messages:

   29,016

   Likes Received:

   4,583

   Best Answers:

   124

   Trophy Points:

   665

   #2

   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.

    

   sarahk, Jun 4, 2026 at 3:39 AM IP

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in