app_question

0 rows


Description

The questions themselves

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_question_id_seq'::regclass)
app_qtype_ddimageortext.questionid Defined in XML R
app_qtype_ddimageortext_drags.questionid Defined in XML R
app_qtype_ddimageortext_drops.questionid Defined in XML R
app_qtype_ddmarker.questionid Defined in XML R
app_qtype_ddmarker_drags.questionid Defined in XML R
app_qtype_ddmarker_drops.questionid Defined in XML R
app_qtype_essay_options.questionid Defined in XML R
app_qtype_match_options.questionid Defined in XML R
app_qtype_match_subquestions.questionid Defined in XML R
app_qtype_multichoice_options.questionid Defined in XML R
app_qtype_randomsamatch_options.questionid Defined in XML R
app_qtype_shortanswer_options.questionid Defined in XML R
app_question.parent Defined in XML R
app_question_answers.question Defined in XML R
app_question_attempts.questionid Defined in XML R
app_question_calculated.question Defined in XML R
app_question_calculated_options.question Defined in XML R
app_question_datasets.question Defined in XML R
app_question_ddwtos.questionid Defined in XML R
app_question_gapselect.questionid Defined in XML R
app_question_hints.questionid Defined in XML R
app_question_multianswer.question Defined in XML R
app_question_numerical.question Defined in XML R
app_question_numerical_options.question Defined in XML R
app_question_numerical_units.question Defined in XML R
app_question_truefalse.question Defined in XML R
app_quiz_slots.questionid Defined in XML R
category int8 19 0
app_question_categories.id Defined in XML R
parent int8 19 0
app_question.id Defined in XML R
name varchar 255 ''::character varying
questiontext text 2147483647 null
questiontextformat int2 5 0
generalfeedback text 2147483647 null
generalfeedbackformat int2 5 0
defaultmark numeric 12,7 1
penalty numeric 12,7 0.3333333
qtype varchar 20 ''::character varying
length int8 19 1
stamp varchar 255 ''::character varying
version varchar 255 ''::character varying
hidden int2 5 0
timecreated int8 19 0
timemodified int8 19 0
createdby int8 19 √ null
app_user.id Defined in XML R
modifiedby int8 19 √ null
app_user.id Defined in XML R

Indexes

Constraint Name Type Sort Column(s)
app_ques_id_pk Primary key Asc id
app_ques_cat_ix Performance Asc category
app_ques_cre_ix Performance Asc createdby
app_ques_mod_ix Performance Asc modifiedby
app_ques_par_ix Performance Asc parent
app_ques_qty_ix Performance Asc qtype

Relationships

Close relationships within degrees of separation