Nie wiem czy dobrze ale według pewnej instrukcji wygenerowałem taki kod tych 3 tabel, relacje są jedynie pomiędzy tabelami a asp_Users które są wygenerowane przez model uwierzytelniania wbudowany przez MS, gdy jednak chcę utworzyć relacje pomiędzy moimi tabelami otrzymuję powyższy komunikat.
USE [zaplanuj.eu]
GO
/****** Object: Table [dbo].[Subjects] Script Date: 2013-09-30 19:37:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Subjects](
[Subject_Id] [int] IDENTITY(1,1) NOT NULL,
[User_Id] [uniqueidentifier] NOT NULL,
[TypeSchool] [int] NOT NULL,
[Name] [varchar](30) NOT NULL,
[ShortName] [varchar](10) NULL,
CONSTRAINT [PK_Subjects_1] PRIMARY KEY CLUSTERED
(
[Subject_Id] ASC,
[User_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[SubjectsInTeachers] Script Date: 2013-09-30 19:37:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SubjectsInTeachers](
[Teacher_Id] [int] NOT NULL,
[Subject_Id] [int] NOT NULL,
CONSTRAINT [PK_SubjectsInTeachers] PRIMARY KEY CLUSTERED
(
[Teacher_Id] ASC,
[Subject_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Teachers] Script Date: 2013-09-30 19:37:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Teachers](
[Teacher_Id] [int] IDENTITY(1,1) NOT NULL,
[User_Id] [uniqueidentifier] NOT NULL,
[TypeSchool] [int] NOT NULL,
[Rank] [varchar](20) NULL,
[Name] [varchar](30) NOT NULL,
[Surname] [varchar](30) NOT NULL,
CONSTRAINT [PK_Teachers] PRIMARY KEY CLUSTERED
(
[Teacher_Id] ASC,
[User_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Subjects] WITH CHECK ADD CONSTRAINT [FK_Subjects_aspnet_Users] FOREIGN KEY([User_Id])
REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
ALTER TABLE [dbo].[Subjects] CHECK CONSTRAINT [FK_Subjects_aspnet_Users]
GO
ALTER TABLE [dbo].[Teachers] WITH CHECK ADD CONSTRAINT [FK_Teachers_aspnet_Users] FOREIGN KEY([User_Id])
REFERENCES [dbo].[aspnet_Users] ([UserId])
GO
ALTER TABLE [dbo].[Teachers] CHECK CONSTRAINT [FK_Teachers_aspnet_Users]
GO