CREATE TABLE [dbo].[LogicOperators]
(
[operatorID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[triggerID] [int] NOT NULL,
[sequenceID] [int] NOT NULL,
[lopName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[conditionScriptID] [int] NULL,
[conditionRetVal] [int] NULL CONSTRAINT [DF__LogicOper__condi__77DFC722] DEFAULT ((0)),
[reactionScriptID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LogicOperators] ADD CONSTRAINT [PK__LogicOperators__740F363E] PRIMARY KEY CLUSTERED ([operatorID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[LogicOperators] ADD CONSTRAINT [FK__LogicOper__condi__76EBA2E9] FOREIGN KEY ([conditionScriptID]) REFERENCES [dbo].[HealingScripts] ([scriptID])
GO
ALTER TABLE [dbo].[LogicOperators] ADD CONSTRAINT [FK__LogicOper__divis__75035A77] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[LogicOperators] ADD CONSTRAINT [FK__LogicOper__react__78D3EB5B] FOREIGN KEY ([reactionScriptID]) REFERENCES [dbo].[HealingScripts] ([scriptID])
GO
ALTER TABLE [dbo].[LogicOperators] ADD CONSTRAINT [FK__LogicOper__trigg__75F77EB0] FOREIGN KEY ([triggerID]) REFERENCES [dbo].[Triggers] ([triggerID])
GO