CREATE TABLE [dbo].[TriggeringEvent]
(
[eventID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[verificationScriptID] [int] NULL,
[eventName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[orderMatters] [int] NULL CONSTRAINT [DF__Triggerin__order__50C5FA01] DEFAULT ((0)),
[timeToLast] [decimal] (18, 0) NULL CONSTRAINT [DF__Triggerin__timeT__51BA1E3A] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TriggeringEvent] ADD CONSTRAINT [PK__TriggeringEvent__4DE98D56] PRIMARY KEY CLUSTERED ([eventID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TriggeringEvent] ADD CONSTRAINT [FK__Triggerin__divis__4EDDB18F] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[TriggeringEvent] ADD CONSTRAINT [FK__Triggerin__verif__4FD1D5C8] FOREIGN KEY ([verificationScriptID]) REFERENCES [dbo].[HealingScripts] ([scriptID])
GO
[dbo].[TriggeringEvent]
![Foreign Keys FK__Triggerin__divis__4EDDB18F: [dbo].[Divisions].divisionID](../../Images/fk.gif)
