Page Comparison

METHOD: POSTPATCH 
URI: /coursev1/v1content/assessmentstate/update // End point
REQUEST: {
    "idrequest": "api.course.assessment.update",
  "ver": "1.0",
  "ets": 1566884714550, //Time stamp in ms
  "request": [{
		{
        "contents": [ ],
        "assessments": [
            {
 				"assessmentTs": 1567591211000, //Assessment time in epoch
                "batchId":"", // Batch Identifier - required
				"courseId":"", // Course Identifier - required
	  			"userId":"",  // User Identifier - required
	  			"attemptId":"", // Attempt Identifier - required
	  			"contentId": "", // Content Identifier - required
		
                "events": [{} ]	 //ONLY ASSESS Events - required
	},
	...],            }
        ]
    
}
}

CREATE TABLE assessment_aggregator (
    batch_id text,
    user_id text,
    course_id text,
    content_id text,
    attempt_id text,
    updated_on timestamp,
    created_on timestamp,
    last_attempted_on timestamp,
    total_score int,
    total_max_score int,
    question list<frozen<question>>,
    PRIMARY KEY (content_id, attempt_id, user_id, course_id, batch_id )
)

CREATE INDEX ON assessment_aggregator (last_attempted_on);

CREATE TYPE question(
    id text,
    max_score int,
    score int,
    type text,
    title text,
    resvalues frozen<list<map<textlist<map<text,text>>>text>>,
    params frozen<list<map<textlist<map<text,text>>>text>>,
    description text,
    duration decimal
);