
[cohesion].[cc_app_module]
CREATE TABLE [cohesion].[cc_app_module]
(
[application_id] [int] NOT NULL,
[module_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_app_module] ADD CONSTRAINT [PK__cc_app_module__3D5E1FD2] PRIMARY KEY CLUSTERED ([application_id], [module_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_app_module] ON [cohesion].[cc_app_module] ([module_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_app_module] ADD CONSTRAINT [FK__cc_app_mo__appli__3F466844] FOREIGN KEY ([application_id]) REFERENCES [cohesion].[cc_application] ([application_id])
GO
ALTER TABLE [cohesion].[cc_app_module] ADD CONSTRAINT [FK__cc_app_mo__modul__3E52440B] FOREIGN KEY ([module_id]) REFERENCES [cohesion].[cc_module] ([module_id])
GO