To be able to trace progress in the game and report on efficiency, the groupstate table is added, where timestamped data is collected about the exact time of reaching a state by each table (group). The groupstate table has a n:1 relation with groupround and contains a copy of the group_state string.
Each time when the facilitator allows the group to progress to a next state, a new record should be inserted in the groupstate table, with the state, the timestamp, a pointer to the groupround table, and potentially some content.
To be able to trace progress in the game and report on efficiency, the
groupstate
table is added, where timestamped data is collected about the exact time of reaching a state by each table (group). Thegroupstate
table has a n:1 relation withgroupround
and contains a copy of thegroup_state
string.Each time when the facilitator allows the group to progress to a next state, a new record should be inserted in the
groupstate
table, with the state, the timestamp, a pointer to the groupround table, and potentially some content.