I'm designing a system, that will have multiple administrators with different administrator levels (level 1,2, ...). When a user logs in and creates something (eg. organisation), all of the administrators need to confirm what the user created. The administrator with administrator level 1 is the first one to confirm. If he accepts the users data he will pass the decision to administrator with administrator level 2. He will the again decide if the user data is correct or not. This process goes on until the administrator with the highest administrator level is reached.
My proposed solution:
Every administrator would have a column that indicates his administrator level. User data table would then have a confirmation status column and a column, indicating which administrator level was the last one to set the confirmation status.
What do you think?