assessment_options.html

<head>
<style>

    div {
        font-family: monospace;
    }

    table, th, td {
        border: 1px solid black;
        border-collapse: collapse;
    }

    tr:nth-child(odd) {
        background-color: #FFFFFF;
    }
    tr:nth-child(even) {
        background-color: #EBF2F2;
    }

    th, td {
        text-align: left;
        padding: 5px 10px 5px 5px;
    }

</style>
</head>


<div>
    <h1>assessment_options</h1>

    <h2>Description</h2>
    <p>
        Information of choice options for a question
    </p>

    <h2> Columns </h2>
    <table>
        <tr><th>Name</th><th>Description</th></tr>
        
        <tr>
          <td>assessment_question_id</td><td>unique question id of an assessment</td>
        </tr>
        
        <tr>
          <td>assessment_option_id</td><td>unique choice option ids of a question</td>
        </tr>
        
        <tr>
          <td>assessment_option_display</td><td>The JSON blob containing the question prompt. This is written in a custom Coursera markup language. The actual prompt text is encapsulated within key named &quot;value.&quot;</td>
        </tr>
        
        <tr>
          <td>assessment_option_feedback</td><td>The text that is displayed to learners upon answering a question correctly</td>
        </tr>
        
        <tr>
          <td>assessment_option_correct</td><td>For text answer type questions, instructors can insert both correct and incorrect answer patterns in order to provide learners with tailored feedback based on common solutions or misconceptions. This field indicates whether the pattern was one that corresponded to a correct solution (t) or an incorrect solution (f).</td>
        </tr>
        
    </table>

    <h2>SQL create statement</h2>
    <pre>
CREATE TABLE assessment_options (
    assessment_question_id VARCHAR(50) 
    ,assessment_option_id VARCHAR(50) 
    ,assessment_option_display VARCHAR(20000) 
    ,assessment_option_feedback VARCHAR(20000) 
    ,assessment_option_correct BOOL 
    ,PRIMARY KEY (assessment_question_id, assessment_option_id)
    ,FOREIGN KEY (assessment_question_id) REFERENCES assessment_questions(assessment_question_id)
);
    </pre>
</div>