· 9 years ago · Nov 25, 2016, 08:18 PM
1CREATE DATABASE IF NOT EXISTS QA
2GO
3USE QA
4GO
5CREATE TABLE Users
6(
7UserID int identity(-2147483648,1),
8Name varchar(150),
9fname varchar(150),
10isadmin bit,
11CONSTRAINT PK_Users PRIMARY KEY CLUSTERED (UserID),
12)
13
14GO
15CREATE TABLE Question
16(
17QuestionID int identity(-2147483648,1),
18UserID int,
19Question varchar(max),
20CONSTRAINT PK_Question PRIMARY KEY CLUSTERED (QuestionID),
21CONSTRAINT FK_UserQuestion FOREIGN KEY (UserID)
22 REFERENCES dbo.Users (UserID)
23)
24GO
25CREATE TABLE Answer
26(
27AnswerID int identity(-2147483648,1),
28QuestionID int,
29UserID int,
30Answer varchar(max),
31IsSolver bit,
32CONSTRAINT PK_Answer PRIMARY KEY CLUSTERED (AnswerID),
33CONSTRAINT FK_UserAnswer FOREIGN KEY (UserID)
34 REFERENCES dbo.Users (UserID) ,
35CONSTRAINT FK_AnswerQuestion FOREIGN KEY (UserID)
36 REFERENCES dbo.Question (QuestionID)
37)
38GO
39
40CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
41[create_specification] ...