Guest User

Untitled

a guest
Jan 18th, 2019
127
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.63 KB | None | 0 0
  1. CREATE TABLE tblQuestion( QuestionID INT PRIMARY KEY,
  2.                     SurveyID INT NOT NULL,
  3.                     Question VARCHAR(120) NOT NULL,
  4.                     FOREIGN KEY (SurveyID) REFERENCES tblSurvey(SurveyID)
  5.                 )
  6. CREATE TABLE tblAnswer(
  7.                     AnswerID INT PRIMARY KEY AUTO_INCREMENT,
  8.                     QuestionID INT NOT NULL,
  9.                     Answer VARCHAR(120) NOT NULL,
  10.                     FOREIGN KEY (QuestionID) REFERENCES tblQuestion(QuestionID),
  11.                 )
  12. CREATE TABLE tblSurvey(
  13.                     SurveyID INT PRIMARY KEY,
  14.                     Name VARCHAR(120) NOT NULL
  15.  
  16.                 )
Add Comment
Please, Sign In to add comment