CREATE TABLE [dbo].[UserAlertConfig]
(
[alertconfigID] [int] NOT NULL IDENTITY(1, 1),
[userID] [int] NOT NULL,
[AlertType] [int] NOT NULL,
[AlertTrigger] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserAlertConfig] ADD CONSTRAINT [pk_alertconfigID] PRIMARY KEY CLUSTERED ([alertconfigID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserAlertConfig] ADD CONSTRAINT [fk_alerttrigger_alerttrigger] FOREIGN KEY ([AlertTrigger]) REFERENCES [dbo].[AlertTriggerDetails] ([AlertTrigger])
GO
ALTER TABLE [dbo].[UserAlertConfig] ADD CONSTRAINT [fk_alerttype_alerttype] FOREIGN KEY ([AlertType]) REFERENCES [dbo].[AlertTypeDetails] ([AlertType])
GO
ALTER TABLE [dbo].[UserAlertConfig] ADD CONSTRAINT [fk_users_userID] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO
[dbo].[UserAlertConfig]
![Foreign Keys fk_users_userID: [dbo].[Users].userID](../../Images/fk.gif)
