Page Comparison

CREATE TABLE assessment_histroy(
    batch_id: text // Batch identifier.
    user_id: text, // User Identifier.
    attempt_id: index, // Question Attempt identifier, To track the number of attempts on that question.
    course_id: text, // Course Identifier.
    assessment_id: text // Identifier of the assessment/content/worksheet 
    assessment_name: text // Name of the assessment/content/worksheet
    question: jsonb // array[objects] // Question details spec object
    datetimedate_time: timestamp // Time stamp, To know last updated time.
    PRIMARY KEY (batch_id,  user_id, course_id, assessment_id)
)