Tables [cohesion].[cc_app_module]
Properties
PropertyValue
Row Count936
Created11:18:10 AM Friday, April 20, 2007
Last Modified11:18:10 AM Friday, April 20, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__cc_app_module__3D5E1FD2: application_id\module_idForeign Keys FK__cc_app_mo__appli__3F466844: [cohesion].[cc_application].application_idapplication_idint4
No
Cluster Primary Key PK__cc_app_module__3D5E1FD2: application_id\module_idForeign Keys FK__cc_app_mo__modul__3E52440B: [cohesion].[cc_module].module_idIndexes XIE1cc_app_module: module_idmodule_idint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cc_app_module__3D5E1FD2: application_id\module_idPK__cc_app_module__3D5E1FD2application_id, module_id
Yes
XIE1cc_app_modulemodule_id
Foreign Keys Foreign Keys
NameColumns
FK__cc_app_mo__appli__3F466844application_id->[cohesion].[cc_application].[application_id]
FK__cc_app_mo__modul__3E52440Bmodule_id->[cohesion].[cc_module].[module_id]
SQL Script
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
Uses