Ticket #13: 01quiz_db.dot

digraph {
    graph [pad="0.5", nodesep="0.5", ranksep="2"];
    node [shape=plain]
    rankdir=LR;
    
user [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: user</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="username">username</td></tr>
  <tr><td port="password">password</td></tr>
  <tr><td port="email">email</td></tr>
</table>>];
choice_types [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: choice_types</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
  <tr><td port="description">description</td></tr>
</table>>];
question_choices [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: question_choices</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="question_id">question_id</td></tr>
  <tr><td port="choice">choice</td></tr>
</table>>];
quizes [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quizes</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
  <tr><td port="description">description</td></tr>
</table>>];
quiz_questions [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_questions</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="question_id">question_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
</table>>];
quiz_types [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_types</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
</table>>];
subjects [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: subjects</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
</table>>];
quiz_results [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_results</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="file_name">file_name</td></tr>
  <tr><td port="start_time">start_time</td></tr>
  <tr><td port="end_time">end_time</td></tr>
  <tr><td port="total_questions">total_questions</td></tr>
  <tr><td port="score">score</td></tr>
  <tr><td port="timed">timed</td></tr>
  <tr><td port="student_id">student_id</td></tr>
  <tr><td port="duration">duration</td></tr>
</table>>];
choice_types [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: choice_types</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
  <tr><td port="description">description</td></tr>
</table>>];
quiz_results_questions [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_results_questions</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="q_id">q_id</td></tr>
  <tr><td port="quiz_result_id">quiz_result_id</td></tr>
  <tr><td port="wrong">wrong</td></tr>
  <tr><td port="marked">marked</td></tr>
  <tr><td port="review_nbr">review_nbr</td></tr>
</table>>];
quiz_result_questions_time_intervals [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_result_questions_time_intervals</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="qid">qid</td></tr>
  <tr><td port="start_t">start_t</td></tr>
  <tr><td port="end_t">end_t</td></tr>
  <tr><td port="correct">correct</td></tr>
  <tr><td port="user_id">user_id</td></tr>
</table>>];
questions [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: questions</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="subject_id">subject_id</td></tr>
  <tr><td port="question">question</td></tr>
  <tr><td port="answer">answer</td></tr>
  <tr><td port="notes">notes</td></tr>
  <tr><td port="refs">refs</td></tr>
  <tr><td port="choice_type">choice_type</td></tr>
  <tr><td port="type_id">type_id</td></tr>
</table>>];
quiz_question_state [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_question_state</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="quiz_state_id">quiz_state_id</td></tr>
  <tr><td port="qid">qid</td></tr>
  <tr><td port="q_choice">q_choice</td></tr>
  <tr><td port="correct">correct</td></tr>
</table>>];
quiz_state [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_state</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="start_datetime">start_datetime</td></tr>
  <tr><td port="end_datetime">end_datetime</td></tr>
  <tr><td port="quiz_question_state_id">quiz_question_state_id</td></tr>
</table>>];
quiz_state_types [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_state_types</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
</table>>];
quiz_in_progress_state_times [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_in_progress_state_times</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="in_progress_id">in_progress_id</td></tr>
  <tr><td port="datetime">datetime</td></tr>
  <tr><td port="quiz_state_type_id">quiz_state_type_id</td></tr>
</table>>];
role [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: role</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
  <tr><td port="description">description</td></tr>
</table>>];
roles_users [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: roles_users</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="role_id">role_id</td></tr>
</table>>];
quiz_in_progress_tmp [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_in_progress_tmp</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="state_id">state_id</td></tr>
</table>>];
quiz_in_progress [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_in_progress</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="state_id">state_id</td></tr>
  <tr><td port="quiz_hh">quiz_hh</td></tr>
  <tr><td port="quiz_mm">quiz_mm</td></tr>
  <tr><td port="quiz_ss">quiz_ss</td></tr>
</table>>];
quiz_in_progress_questions_answered [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_in_progress_questions_answered</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="question_id">question_id</td></tr>
  <tr><td port="latest_start_time">latest_start_time</td></tr>
  <tr><td port="duration_time">duration_time</td></tr>
  <tr><td port="choice">choice</td></tr>
  <tr><td port="in_progress_id">in_progress_id</td></tr>
  <tr><td port="visit_cnt">visit_cnt</td></tr>
  <tr><td port="marked">marked</td></tr>
</table>>];
quiz_in_progress_types [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_in_progress_types</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
</table>>];
package_types [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: package_types</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
</table>>];
package_quizes [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: package_quizes</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="p_id">p_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
</table>>];
user_quizes [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: user_quizes</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
</table>>];
user_packages [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: user_packages</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="package_id">package_id</td></tr>
</table>>];
quiz_time_limits [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_time_limits</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="quiz_hh">quiz_hh</td></tr>
  <tr><td port="quiz_mm">quiz_mm</td></tr>
  <tr><td port="quiz_ss">quiz_ss</td></tr>
</table>>];
packages [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: packages</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="package_type_id">package_type_id</td></tr>
  <tr><td port="name">name</td></tr>
  <tr><td port="description">description</td></tr>
</table>>];
quiz_state [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_state</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="start_datetime">start_datetime</td></tr>
  <tr><td port="end_datetime">end_datetime</td></tr>
  <tr><td port="quiz_question_state_id">quiz_question_state_id</td></tr>
</table>>];
quiz_state [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: quiz_state</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="user_id">user_id</td></tr>
  <tr><td port="quiz_id">quiz_id</td></tr>
  <tr><td port="start_datetime">start_datetime</td></tr>
  <tr><td port="end_datetime">end_datetime</td></tr>
  <tr><td port="quiz_question_state_id">quiz_question_state_id</td></tr>
</table>>];
question_type [label=<
<table border="0" cellborder="1" cellspacing="0">
  <tr><td><i>Table: question_type</i></td></tr>
  <tr><td port="id">id</td></tr>
  <tr><td port="name">name</td></tr>
  <tr><td port="description">description</td></tr>
</table>>];



        user:id          -> user_packages:user_id
        user:id          -> quiz_results:student_id
        user:id          -> user_quizes:user_id
        user:id          -> quiz_state:user_id
        user:id          -> roles_users:user_id
        user:id          -> quiz_in_progress:user_id
        user:id          -> quiz_result_questions_time_intervals:user_id
        quizes:id        -> quiz_time_limits:quiz_id
        quizes:id        -> user_quizes:quiz_id
        quizes:id        -> quiz_state:quiz_id
        quizes:id        -> quiz_in_progress:quiz_id
        quizes:id        -> quiz_result_questions_time_intervals:quiz_id
        quizes:id        -> quiz_in_progress_state_times:quiz_id
        quizes:id        -> quiz_questions:quiz_id
        quizes:id        -> package_quizes:quiz_id
        quizes:id        -> quiz_question_state:qid
        package_types:id         -> packages:package_type_id
        packages:id      -> user_packages:package_id
        packages:id      -> package_quizes:p_id
        quiz_in_progress_states:id       -> quiz_in_progress:state_id
        quiz_in_progress_types:id        -> quiz_in_progress_states:qip_type_id
        quiz_question_state:id   -> quiz_state:quiz_question_state_id
        questions:id     -> quiz_results_questions:q_id
        questions:id     -> quiz_result_questions_time_intervals:qid
        questions:id     -> quiz_in_progress_questions_answered:question_id
        questions:id     -> quiz_questions:question_id
        questions:id     -> question_choices:question_id
        question_choices:id      -> quiz_in_progress_questions_answered:choice
        question_type:id         -> questions:type_id
        choice_types:id          -> questions:choice_type
        subjects:id      -> questions:subject_id
        quiz_state:id    -> quiz_question_state:quiz_state_id
        role:id          -> roles_users:role_id
        quiz_state_types:id      -> quiz_in_progress_state_times
        quiz_in_progress:id      -> quiz_in_progress_state_times:in_progress_id
        quiz_in_progress:id      -> quiz_in_progress_questions_answered:in_progress_id
        quiz_results:id          -> quiz_results_questions:quiz_result_id

}