executedby is the ID assigned to an employee. I'm presuming that JSON is to be used for objectbefore/after. This suggests no ability to query by individual object fields. I didn't sense any other columns that would be JSON.
-- Jack Krupansky On Wed, Mar 16, 2016 at 3:48 PM, Tom van den Berge <t...@drillster.com> wrote: > Is text the most appropriate data type to store JSON that contain couple >> of dozen lines ? >> > > It sure is the simplest way to store JSON. > > The query requirement is "where executedby = ?”. >> > > Since executedby is a timeuuid, I guess you don't want to query a single > record, since that would require you to know the exact timeuuid. Do you > mean that you would like to query all changes in a certain time frame, e.g. > today? In that case, you would have to group your rows in time buckets, > e.g. PRIMARY KEY ((period), auditid). Period can be a day, month, or any > other period that suits your situation. Retrieving all changes in a > specific time frame is done by retrieving all relevant periods. > > Tom >
