Foreign Key to multiple tables
CREATE TABLE [dbo].[Updates](
[Update_ID] [int] IDENTITY (1,1) NOT NULL,
[User_ID] [int] NOT NULL,
[U_Description] [nvarchar](100) NOT NULL,
[U_Type] [char](1) NOT NULL,
[Item_ID] [int] NOT NULL,
[Date_Time] [datetime] DEFAULT CURRENT_TIMESTAMP NOT NULL,
CONSTRAINT pk_Updates PRIMARY KEY CLUSTERED (Update_ID),
CONSTRAINT fk_Updates FOREIGN KEY (User_ID)
REFERENCES Users (User_ID)
ON DELETE CASCADE
ON UPDATE CASCADE
,
CONSTRAINT fk_Updates2 FOREIGN KEY (Item_ID)
REFERENCES Video (Video_ID)
ON DELETE NO ACTION
ON UPDATE NO ACTION
,
CONSTRAINT fk_Updates3 FOREIGN KEY (Item_ID)
REFERENCES User_Event (Event_ID)
ON DELETE NO ACTION
ON UPDATE NO ACTION
How can i make this work? I use U_Type to know witch table i have to join & Item_ID to find the specific item..
|