I would like to add quizzes and questions directly to the database. However, I am not seeing a column/field for the question description in the #_ariquizquestion table. The fileds I see are:

QuestionId
QuizId
QuestionVersionId
Created
CreatedBy
Modified
ModifiedBy
Status
QuestionIndex
BankQuestionId
QuestionTypeId
QuestionCategoryId
asset_id

Please let me know where the question description and the answers are stored.

Also, are there two different tables that store question in the question bank and others that are added directly to quizzes?

Thank you

Hello,

Question text is stored in "Question" field from #__ariquizquestionversion table. Answers are stored in "Data" field from #__ariquizquestionversion table.

Regards,
ARI Soft

Thank You.

I notice that there is an Answer ID tag in the Data field. What is this value and what can I use to generate it?

Regards

You can use any unique value for each answer inside a question. For example uniqid PHP function can be used.

Regards,
ARI Soft