10 lines
288 B
SQL
10 lines
288 B
SQL
CREATE TABLE IF NOT EXISTS survey_responses (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
survey_id INT NOT NULL,
|
|
respondent_email VARCHAR(255),
|
|
question_1_answer TEXT,
|
|
question_2_answer TEXT,
|
|
question_3_answer TEXT,
|
|
submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|