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