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