app_question_sessions

0 rows


Description

Gives ids of the newest open and newest graded states

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_question_sessions_id_seq'::regclass)
attemptid int8 19 0
app_question_attempts.id Defined in XMLR
questionid int8 19 0
app_question.id Defined in XMLR
newest int8 19 0
app_question_states.id Defined in XMLR
newgraded int8 19 0
app_question_states.id Defined in XMLR
sumpenalty numeric 12,7 0
manualcomment text 2147483647 null
manualcommentformat int2 5 0
flagged int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_quessess_id_pk Primary key Asc id
app_quessess_att_ix Performance Asc attemptid
app_quessess_attque_uix Must be unique Asc/Asc attemptid + questionid
app_quessess_new2_ix Performance Asc newgraded
app_quessess_new_ix Performance Asc newest
app_quessess_que_ix Performance Asc questionid

Relationships