可以给出用户表、问卷表、问题表、选项表、答案表的MySQL建表语句吗
时间: 2023-03-24 15:02:44 浏览: 50
可以,以下是MySQL建表语句:
用户表:
CREATE TABLE user (
user_id INT PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) NOT NULL,
password VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
phone VARCHAR(20) NOT NULL
);
问卷表:
CREATE TABLE questionnaire (
questionnaire_id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(100) NOT NULL,
description TEXT,
create_time DATETIME NOT NULL,
user_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES user(user_id)
);
问题表:
CREATE TABLE question (
question_id INT PRIMARY KEY AUTO_INCREMENT,
content TEXT NOT NULL,
type ENUM('single_choice', 'multiple_choice', 'text') NOT NULL,
questionnaire_id INT NOT NULL,
FOREIGN KEY (questionnaire_id) REFERENCES questionnaire(questionnaire_id)
);
选项表:
CREATE TABLE option (
option_id INT PRIMARY KEY AUTO_INCREMENT,
content TEXT NOT NULL,
question_id INT NOT NULL,
FOREIGN KEY (question_id) REFERENCES question(question_id)
);
答案表:
CREATE TABLE answer (
answer_id INT PRIMARY KEY AUTO_INCREMENT,
content TEXT,
user_id INT NOT NULL,
question_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES user(user_id),
FOREIGN KEY (question_id) REFERENCES question(question_id)
);