Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Assessment Questions

Details

Table ID: h_sm_assessment_questions

Contains details of assessment questions (supports translations)

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Date Created
h_date_created
The creation date of the record.
Type DATETIME
Nullable true
Default Language
h_default_language
The Default fallback Language of the question
Type VARCHAR
Size 64
Nullable true
Indexed true
ID
h_id
The primary key of the table
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
One to Many
h_sm_assessment_answers.h_question_id
Language
h_language
Current Language of the question
Type VARCHAR
Size 64
Nullable true
Indexed true
Question
h_question
The Question to be asked
Type VARCHAR
Size 255
Nullable true
Indexed true
Question Date Updated
h_last_updated
The Day and Time of the of when the question was last updated
Type DATETIME
Nullable true
Question ID
h_question_id
The Linked Question ID
Type INTEGER
Nullable true
Indexed true
Question Order
h_order
The Order of the question
Type INTEGER
Nullable true
Indexed true
Status
h_status
The status of the question
Type VARCHAR
Size 32
Nullable true
The Assessment ID
h_assessment_id
The Assessment ID the question is associated to
Type INTEGER
Nullable true
Indexed true
The Type ID
h_type_id
The Type ID the question is associated to
Type INTEGER
Nullable true
Indexed true
In This Document