travelhun

Tables (5)

Answers

  • id — INT
  • responseId — INT — Foreign key → Responses.id — NOT NULL
  • questionId — INT — Foreign key → Questions.id — NOT NULL
  • selectedOptionId — INT — Foreign key → Options.id — NOT NULL

Options

  • id — INT
  • questionId — INT — Foreign key → Questions.id — NOT NULL
  • optionText — VARCHAR(255) — NOT NULL
  • score — INT — NOT NULL
  • conditionalNextQuestionId — INT — Foreign key → Questions.id

Questions

  • id — INT
  • surveyId — INT — Foreign key → Surveys.id — NOT NULL
  • questionText — TEXT — NOT NULL
  • questionType — VARCHAR(50)
  • previousQuestionId — INT
  • nextQuestionId — INT — Foreign key → Questions.id

Responses

  • id — INT
  • surveyId — INT — Foreign key → Surveys.id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • totalScore — INT
  • completionDate — TIMESTAMP

Surveys

  • id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • creationDate — TIMESTAMP