I am trying to model the process of where one co-worker enters a statement of their proposed work procedure and another co-worker commenting and approving the statement. Currently I have one table as such:
METHODOLOGY methodology_id entered_by statement entered_date status_code reviewed_by reviewer_comments reviewed_date
status codes are as such:
1 = in progress by originator 2 = finished and locked by originator 3 = in progress by checker 4 = finished, locked and rejected by checker 5 = finished, locked and approved by checker 6 = approved method was unlocked due to revision to methodology 7 = the originator was changed with a new originator after method was approved 8 = the checker was changed with a new checker
Should this be broken out as such:
METHODOLOGY_STATEMENT methodology_id entered_by statement entered_date status_code METHODOLOGY_REVIEW methodology_review_id methodology_id status_code reviewed_by reviewer_comments reviewed_date
Right now the requirement is only one Review per Method Statement.