...
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 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<text,text>>>,
params frozen<list<map<text,text>>>,
description text,
duration decimal
);
|
...