dev
Last change
on this file since b25b9ea was b25b9ea, checked in by Стојков Марко <mst@…>, 3 years ago |
Get question state endpoint
|
-
Property mode
set to
100644
|
File size:
893 bytes
|
Line | |
---|
1 | CREATE TABLE [dbo].[Answer] (
|
---|
2 | [Id] BIGINT IDENTITY (1, 1) NOT NULL,
|
---|
3 | [Uid] UNIQUEIDENTIFIER NOT NULL,
|
---|
4 | [Text] NVARCHAR (4000) NOT NULL,
|
---|
5 | [QuestionFk] BIGINT NOT NULL,
|
---|
6 | [StudentFk] BIGINT NOT NULL,
|
---|
7 | [CorrectAnswer] BIT NOT NULL,
|
---|
8 | [CreatedOn] SMALLDATETIME NOT NULL,
|
---|
9 | [UpvotesCount] BIGINT NOT NULL DEFAULT 0,
|
---|
10 | CONSTRAINT [PK_Answer] PRIMARY KEY CLUSTERED ([Id] ASC),
|
---|
11 | CONSTRAINT [FK_Answer_Question_QuestionFk] FOREIGN KEY ([QuestionFk]) REFERENCES [dbo].[Question] ([Id]),
|
---|
12 | CONSTRAINT [FK_Answer_Student_StudentFk] FOREIGN KEY ([StudentFk]) REFERENCES [dbo].[Student] ([Id])
|
---|
13 | );
|
---|
14 |
|
---|
15 |
|
---|
16 | GO
|
---|
17 | CREATE NONCLUSTERED INDEX [IX_Answer_QuestionFk]
|
---|
18 | ON [dbo].[Answer]([QuestionFk] ASC);
|
---|
19 |
|
---|
20 |
|
---|
21 | GO
|
---|
22 | CREATE NONCLUSTERED INDEX [IX_Answer_StudentFk]
|
---|
23 | ON [dbo].[Answer]([StudentFk] ASC);
|
---|
24 |
|
---|
Note:
See
TracBrowser
for help on using the repository browser.