Guest User

Untitled

a guest
Dec 1st, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. CREATE TABLE [Members]
  2. (
  3. [MemberId] int NOT NULL IDENTITY
  4. )
  5.  
  6. CREATE TABLE [Studios]
  7. (
  8. [StudioId] int NOT NULL IDENTITY,
  9. [HeadId] int,
  10. [OwnerId] int,
  11.  
  12. CONSTRAINT [PK_Studios] PRIMARY KEY ([StudioId]),
  13.  
  14. CONSTRAINT [FK_Studios_Members_OwnerId]
  15. FOREIGN KEY ([OwnerId]) REFERENCES [Members] ([MemberId])
  16. ON DELETE SET NULL,
  17. CONSTRAINT [FK_Studios_Members_HeadId]
  18. FOREIGN KEY ([HeadId]) REFERENCES [Members] ([MemberId])
  19. ON DELETE SET NULL
  20. )
Advertisement
Add Comment
Please, Sign In to add comment