Update Feed

Patient UpdateLog CF

CREATE TABLE patient_update_log (
    year int,
    event_id timeuuid,
    health_id varchar,
    change_set varchar,
    PRIMARY KEY (year, event_id, health_id)
) WITH CLUSTERING ORDER BY (event_id ASC);

Update Patient

• Records in patient_update_log CF are created whenever any Loggable Fields of a patient record get updated.  event_id set to a generated  timeuuid, change_set to the changed delta of patient object as json string, year set to event year.

Approve Patient Update Request

• (If an update request approved) Records in patient_update_log CF are created. 

Loggable Fields

• sur_name, 
• given_name, 
• gender, 
• confidential and 
• address. 

Feed Query

• Since - gte marker UUID(minimum uuid for given time)
• last_marker - gt event_id