Versions Compared

Old Version 17

changes.mady.by.user Manjunath Davanam

Saved on

compared with

New Version 18

changes.mady.by.user Manjunath Davanam

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Need to validate and de-dup the the events.

Table Schema:

Question object :

language
Code Block
jsthemeFadeToGrey
titleHistory table schemaassessment_profile
linenumberstrue
CREATE TABLE assessment_histroyprofile (
     batch_id: text // Batch identifier.,
     user_id: text,
// User Identifier.     attemptcourse_id: indextext,
// Question Attempt identifier, To track the number of attempts on that question.
    course_id: worksheet_id text,
// Course Identifier.     assessmentattempt_id: text,
// Identifier of the assessment/content/worksheet  updated_on timestamp,
    assessmentcreated_name: text // Name of the assessment/content/worksheeton timestamp,
    question: jsonb // array[objects] // Question details spec object
    date_time: timestamp // Time stamp, To know last updated time.
     list<frozen<question>>,
    PRIMARY KEY (batchworksheet_id, attempt_id, user_id, course_id, assessmentbatch_id )
)

Question object :

Code Block
languagejs
themeFadeToGrey
titleQuestion object structure
linenumberstrue
question:{
  "qid": "do_957399094343"


CREATE TYPE question(
    id: text,
  "  max_score": 5int,
  "  score": 2int,
  "  type" :"mcq/mmcq/ftb/mtf": text,
  "  title": "Choosetext,
valid odd number"   "pass": "Yes"/"No"text,
  "desc":"Description of the question",  description: text
    "duration":text
5);


}


Challenges:

 

  1. How to capture the attempts? i.e. Number of times the particular user is attempted particular question. 
  2. How to capture the batch-id and course-id

...