CREATE TABLE [dbo].[Triggers]
(
[triggerID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[triggerName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[lastModificationEpoch] [decimal] (18, 0) NULL CONSTRAINT [DF__Triggers__lastMo__6C6E1476] DEFAULT ((0)),
[eventID] [int] NULL,
[concurrencySetting] [int] NULL,
[impersonationID] [int] NULL,
[scriptLanguage] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Triggers] ADD CONSTRAINT [PK__Triggers__6A85CC04] PRIMARY KEY CLUSTERED ([triggerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Triggers] ADD CONSTRAINT [FK__Triggers__divisi__6B79F03D] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[Triggers] ADD CONSTRAINT [FK__Triggers__eventI__6D6238AF] FOREIGN KEY ([eventID]) REFERENCES [dbo].[TriggeringEvent] ([eventID])
GO
ALTER TABLE [dbo].[Triggers] ADD CONSTRAINT [FK__Triggers__impers__6E565CE8] FOREIGN KEY ([impersonationID]) REFERENCES [dbo].[ImpersonationSettings] ([impersonationID])
GO
[dbo].[Triggers]
![Foreign Keys FK__Triggers__divisi__6B79F03D: [dbo].[Divisions].divisionID](../../Images/fk.gif)
