cassandra-example.cql

CREATE TABLE test (
  office text,
  office_team text,
  ts timestamp,
  team_member text,
  action text,
  is_team_active boolean static,
  PRIMARY KEY ((office, office_team), ts, team_member)
);

INSERT INTO test (office, office_team, ts, team_member, action, is_team_active) VALUES('finland', 'dbas', '2016-06-04T12:00:00Z', 'Garo', 'Entered office', true);
INSERT INTO test (office, office_team, ts, team_member, action) VALUES('finland', 'dbas', '2016-06-04T13:00:00Z', 'Garo', 'Exitted office');
UPDATE test SET is_team_active = false WHERE office = 'finland' and office_team = 'dbas';