app_question_sessions

0 rows

Description

Gives ids of the newest open and newest graded states

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 6 of 6 entries

Relationships

Close relationships within degrees of separation

One
Two degrees