I just need some help trying to formulate how to setup tables to allow for dataflow and tracking.

I have 1 table to collect the initial data which then sets up a trigger to populate another table for tracking

[data] -> [tracking][department review]

I then want the department to review the data and pass it on to up to 5 different people to review ... once reviewed to signal back to the department all 5 are done to process through with the rest...

any ideas?

Set up tables to model the objects and entities in your business environment.