...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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 text,
max_score text,
question list<frozen<question>>,
PRIMARY KEY (worksheet_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: list<text>,
params: list<text>,
description text,
duration:text
);
|
...