Table qti_assessment_item_ref
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
qti_item_result.item_ref_id fk97b58ab0d4a8d8f9 R
category varchar 1024  √  null
identifier varchar 255
uuid varchar 40
xml_path varchar 1024
question_id int8 19
qti_assessment_item.id fkac738b2b33716f61 R
test_id int8 19
qti_assessment_test.id fkac738b2ba53360b4 R
list_position int4 10
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc qti_assessment_item_ref_pkey
test_id + identifier Must be unique Asc/Asc qti_assessment_item_ref_test_id_identifier_key
test_id + uuid Must be unique Asc/Asc qti_assessment_item_ref_test_id_uuid_key
identifier Performance Asc qtiqrefidentifierindex
question_id Performance Asc qtiqrefquestionindex
test_id Performance Asc qtiqreftestindex
uuid Performance Asc qtiqrefuuidindex

Close relationships  within of separation: