Table qti_assessment_item
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.question_id fkac738b2b33716f61 R
adaptive bool 1  √  null
identifier varchar 1024
item_body text 2147483647  √  null
label varchar 256  √  null
lang varchar 10  √  null
time_dependent bool 1  √  null
title text 2147483647
uuid varchar 40
institution_id int8 19
institution.id fk98d3e6d7bc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc qti_assessment_item_pkey
institution_id + uuid Must be unique Asc/Asc qti_assessment_item_institution_id_uuid_key
institution_id Performance Asc qtiqstinstitutionindex
identifier Performance Asc qtiquestionidentifierindex
uuid Performance Asc qtiquestionuuidindex

Close relationships  within of separation: