Advertisement
Guest User

Untitled

a guest
Dec 16th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. CREATE TABLE [dbo].[tbl_questprogressinfo](
  2. [QuestIndex] INT NOT NULL,
  3. [CharacterIndex] INT NOT NULL,
  4. [StartDateTime] DATETIME NOT NULL,
  5. [EndDateTime] DATETIME NULL,
  6. [Completed] BIT NOT NULL,
  7.  
  8. CONSTRAINT [PK_tbl_questprogressinfo] PRIMARY KEY CLUSTERED ([QuestIndex] ASC, [CharacterIndex] ASC),
  9. CONSTRAINT [FK_tbl_questprogressinfo_tbl_questinfo] FOREIGN KEY ([QuestIndex]) REFERENCES [dbo].[tbl_questinfo] ([Index]),
  10. CONSTRAINT [FK_tbl_questprogressinfo_tbl_characterinfo] FOREIGN KEY ([CharacterIndex]) REFERENCES [dbo].[tbl_characterinfo] ([Index])
  11. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement