[cohesion].[cc_rel

Property	Value
Row Count	0
Created	11:18:10 AM Friday, April 20, 2007
Last Modified	11:18:10 AM Friday, April 20, 2007

Property

Value

Row Count

Created

11:18:10 AM Friday, April 20, 2007

Last Modified

11:18:10 AM Friday, April 20, 2007

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key PK__cc_rel_map__09A971A2: map_id\rel_id$	map_id	int	4
$Cluster Primary Key PK__cc_rel_map__09A971A2: map_id\rel_id$	rel_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__cc_rel_map__09A971A2: map_id\rel_id$

map_id

int

$Cluster Primary Key PK__cc_rel_map__09A971A2: map_id\rel_id$

rel_id

int

	Name	Columns	Unique
$Cluster Primary Key PK__cc_rel_map__09A971A2: map_id\rel_id$	PK__cc_rel_map__09A971A2	map_id, rel_id

Name

Columns

Unique

$Cluster Primary Key PK__cc_rel_map__09A971A2: map_id\rel_id$

PK__cc_rel_map__09A971A2

map_id, rel_id

Name	Columns
FK__cc_rel_ma__map_i__0B91BA14	map_id->[cohesion].[cc_map].[map_id]
FK__cc_rel_ma__rel_i__0A9D95DB	rel_id->[cohesion].[cc_ci_relation].[rel_id]

Name

Columns

FK__cc_rel_ma__map_i__0B91BA14

map_id->[cohesion].[cc_map].[map_id]

FK__cc_rel_ma__rel_i__0A9D95DB

rel_id->[cohesion].[cc_ci_relation].[rel_id]

SQL Script

CREATE TABLE [cohesion].[cc_rel_map]
(
[map_id] [int] NOT NULL,
[rel_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_rel_map] ADD CONSTRAINT [PK__cc_rel_map__09A971A2] PRIMARY KEY CLUSTERED ([map_id], [rel_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_rel_map] ADD CONSTRAINT [FK__cc_rel_ma__map_i__0B91BA14] FOREIGN KEY ([map_id]) REFERENCES [cohesion].[cc_map] ([map_id])
GO
ALTER TABLE [cohesion].[cc_rel_map] ADD CONSTRAINT [FK__cc_rel_ma__rel_i__0A9D95DB] FOREIGN KEY ([rel_id]) REFERENCES [cohesion].[cc_ci_relation] ([rel_id])
GO