Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [Members]
- (
- [MemberId] int NOT NULL IDENTITY
- )
- CREATE TABLE [Studios]
- (
- [StudioId] int NOT NULL IDENTITY,
- [HeadId] int,
- [OwnerId] int,
- CONSTRAINT [PK_Studios] PRIMARY KEY ([StudioId]),
- CONSTRAINT [FK_Studios_Members_OwnerId]
- FOREIGN KEY ([OwnerId]) REFERENCES [Members] ([MemberId])
- ON DELETE SET NULL,
- CONSTRAINT [FK_Studios_Members_HeadId]
- FOREIGN KEY ([HeadId]) REFERENCES [Members] ([MemberId])
- ON DELETE SET NULL
- )
Advertisement
Add Comment
Please, Sign In to add comment