capitron

Tables (8)

DATA CASES (t_data_cases)

  • CASE ID (id) — int — Primary key — NOT NULL
  • EXERCISE ID (exercise_id) — int — Foreign key → Exercises.QUESTION ID — NOT NULL
  • RECORD CODE (record_code) — varchar
  • RECORD TYPE (record_type) — varchar
  • HAS ISSUE (issue_yn) — varchar

Exercises (t_excercises)

  • QUESTION ID (id) — int — Primary key — NOT NULL
  • TYPE (type) — varchar
  • Title (title) — varchar
  • DESCRIPTION (description) — varchar
  • SCORE (score) — int
  • LEVEL (level) — int
  • GROUP ID (group_id) — int — Foreign key → GROUP.GROUP ID — NOT NULL
  • CREATED DATE (created_at) — timestamp

GROUP (t_groups)

  • GROUP ID (id) — int — Primary key — NOT NULL
  • GROUP NAME (group_name) — varchar

MATCHING OPTIONS (t_matching_options)

  • OPTION ID (id) — int — Primary key — NOT NULL
  • EXERCISE ID (exercise_id) — int — Foreign key → Exercises.QUESTION ID — NOT NULL
  • CONTENT (content) — varchar
  • PAIR ID (pair_id) — int
  • SIDE (side) — varchar
  • CREATED DATE (created_at) — timestamp

QUIZ OPTIONS (t_quiz_options)

  • OPTION ID (id) — int — Primary key — NOT NULL
  • EXERCISE ID (exercise_id) — int — Foreign key → Exercises.QUESTION ID — NOT NULL
  • ANSWER (answer) — varchar
  • IS CORRECT? (correct_yn) — varchar
  • CREATED DATE (created_at) — timestamp

RECORD VALUES (t_record_values)

  • RECORD ID (id) — int — Primary key — NOT NULL
  • CASE ID (case_id) — int — Foreign key → DATA CASES.CASE ID — NOT NULL
  • FIELD NAME (field_name) — varchar
  • FIELD VALUE (field_value) — varchar

USER ANSWERS (t_user_answers)

  • USER ANSWER ID (id) — int — Primary key — NOT NULL
  • USER ID (user_id) — int — Foreign key → User table.USER ID — NOT NULL
  • EXERCISE ID (exercise_id) — int — Foreign key → Exercises.QUESTION ID — NOT NULL
  • CREATED DATE (created_at) — timestamp

User table (t_users)

  • USER ID (id) — int — Primary key — NOT NULL
  • USER NAME (name) — varchar
  • PHONE (phone) — varchar
  • USER PASSWORD (password) — varchar
  • CREATED DATE (created_at) — timestamp