Q_QML_Ex

TABLE Q_QML_Ex

An auxiliary table with the same structure and primary key as Q_Question_Ex that contains auxiliary information about the question including the serialised (XML) question data.

Primary Key: Question_MID int NOT NULL

Primary Key: Question_LID int NOT NULL

Primary Key: Revision int NOT NULL

Editor varchar(200) NOT NULL

Modified_Date datetime NOT NULL

Comments varchar(4000)

QML_Data nvarchar(max)

The data in this field may be encrypted. The purpose of the encryption is to prevent accidental exposure of exam content through, for example, database backups. Newer databases may use plain text as transparent data encryption (TDE) is the preferred way to encrypt the contents of databases to mitigate this type of risk. For security purposes, details of the encryption method used are private to Questionmark and not published in documentation.

Base bit NOT NULL

Primary Key: Lang varchar(10) NOT NULL

Question_ID bigint computed NOT NULL