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
assessment_name: text // Name of the assessment
content_id: text, // Content Identifier
question: jsonb // array[objects] // Question details spec object
datetime: timestamp // Time stamp, To know last updated time.
PRIMARY KEY (batch_id, user_id, content_id, assessment_id)
) |