Re: Storing JSON inside a text or blob column
Well, for simplicity, lets say I have a member table, a group table, a ballots table and a votes table.
member table has normal member info
iMemberId vchName, etc.
The group table contains
iGroupId iMemberId GroupType(Set)
1 1 (1)
2 1 (1,3)
3 1 (1,2,3)
The votes table contains
iBallotId iMemberId iGroupId
1 1 1
2 1 2
3 1 3
But then, within each ballot I have say 10 different measures...and the measure list changes based on the GroupType....ie it is really a set of a group of measures so that if someone is a member of a grouptype which supports all types, the measure list could have 30 possible votes. Also, each vote for each measure has to be saved.
Would it be better to store the measures as a json string inside a mediumtext column or better to break it out into more tables??? Hopefully that was clear