CREATE TABLE [dbo].[pol_policies_situations_introducers]
(
[polsi_policy_situation_id] [int] NOT NULL,
[polsi_introducer_id] [int] NOT NULL,
[polsi_retro_code] [dbo].[ais_code_short] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[pol_policies_situations_introducers] ADD CONSTRAINT [PK_pol_policies_situations_introducers] PRIMARY KEY CLUSTERED  ([polsi_policy_situation_id], [polsi_introducer_id], [polsi_retro_code]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[pol_policies_situations_introducers] ADD CONSTRAINT [FK_pol_policies_situations_introducers_act_introducers] FOREIGN KEY ([polsi_introducer_id]) REFERENCES [dbo].[act_introducers] ([int_actor_id])
GO
ALTER TABLE [dbo].[pol_policies_situations_introducers] ADD CONSTRAINT [FK_pol_policies_situations_introducers_pol_policies_situations] FOREIGN KEY ([polsi_policy_situation_id]) REFERENCES [dbo].[pol_policies_situations] ([pols_policy_situation_id])
GO
ALTER TABLE [dbo].[pol_policies_situations_introducers] ADD CONSTRAINT [FK_pol_policies_situations_introducers_int_retrocessions] FOREIGN KEY ([polsi_retro_code]) REFERENCES [dbo].[int_retrocessions] ([iret_retro_code])
GO
