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