Qmaker
Tables (7)
category
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
question
- id — BIGINT
- question_text — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
question_category
- id — BIGINT
- question_id — BIGINT — NOT NULL
- category_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
question_option
- id — BIGINT
- question_id — BIGINT — NOT NULL
- option_text — TEXT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- explanation_text — TEXT
- created_at — TIMESTAMP
quiz
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- user_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
quiz_question
- id — BIGINT
- quiz_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
user
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP