Table qti_assessment_test
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_assessment_item_ref.test_id fkac738b2ba53360b4 R
qti_assessment_result.test_id fkc20452e1a53360b4 R
identifier varchar 1024
navigation_mode int4 10
submission_mode int4 10
test_part_identifier varchar 256
title text 2147483647
uuid varchar 40
xml_path varchar 1024
institution_id int8 19
institution.id fk98d8b056bc711081 R
item_id int8 19
item.id fk98d8b0566f7f1a9c R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc qti_assessment_test_pkey
institution_id + uuid Must be unique Asc/Asc qti_assessment_test_institution_id_uuid_key
item_id + identifier Must be unique Asc/Asc qti_assessment_test_item_id_identifier_key
item_id Must be unique Asc qti_assessment_test_item_id_key
identifier Performance Asc qtitestidentifierindex
institution_id Performance Asc qtitestinstitutionindex
item_id Performance Asc qtitestitemindex
uuid Performance Asc qtitestuuidindex

Close relationships  within of separation: