CREATE TABLE [dbo].[act_actors_link]
(
[al_actor_id] [int] NOT NULL,
[al_link_code] [dbo].[ais_code_short] NOT NULL,
[al_actor2_id] [int] NOT NULL,
[al_rowver] [timestamp] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[act_actors_link] ADD CONSTRAINT [PK_act_actors_link] PRIMARY KEY CLUSTERED  ([al_actor_id], [al_link_code], [al_actor2_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[act_actors_link] WITH NOCHECK ADD CONSTRAINT [FK_act_actors_link_act_actors_actor] FOREIGN KEY ([al_actor_id]) REFERENCES [dbo].[act_actors] ([act_actor_id])
GO
ALTER TABLE [dbo].[act_actors_link] WITH NOCHECK ADD CONSTRAINT [FK_act_actors_link_act_actors_actor2] FOREIGN KEY ([al_actor2_id]) REFERENCES [dbo].[act_actors] ([act_actor_id])
GO
ALTER TABLE [dbo].[act_actors_link] WITH NOCHECK ADD CONSTRAINT [FK_act_actors_link_act_link_types] FOREIGN KEY ([al_link_code]) REFERENCES [dbo].[act_link_types] ([lt_link_code])
GO
