Tables [cohesion].[cc_elem_attachment]
Properties
PropertyValue
Row Count702
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_elem_attachme__60A75C0F: attachment_id\element_idForeign Keys FK__cc_elem_a__attac__628FA481: [cohesion].[cc_attachment].attachment_idattachment_idint4
No
Cluster Primary Key PK__cc_elem_attachme__60A75C0F: attachment_id\element_idForeign Keys FK__cc_elem_a__eleme__619B8048: [cohesion].[cc_element].element_idIndexes XIE1cc_elem_attach: element_idelement_idint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cc_elem_attachme__60A75C0F: attachment_id\element_idPK__cc_elem_attachme__60A75C0Fattachment_id, element_id
Yes
XIE1cc_elem_attachelement_id
Foreign Keys Foreign Keys
NameColumns
FK__cc_elem_a__attac__628FA481attachment_id->[cohesion].[cc_attachment].[attachment_id]
FK__cc_elem_a__eleme__619B8048element_id->[cohesion].[cc_element].[element_id]
SQL Script
CREATE TABLE [cohesion].[cc_elem_attachment]
(
[attachment_id] [int] NOT NULL,
[element_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_elem_attachment] ADD CONSTRAINT [PK__cc_elem_attachme__60A75C0F] PRIMARY KEY CLUSTERED ([attachment_id], [element_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_elem_attach] ON [cohesion].[cc_elem_attachment] ([element_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_elem_attachment] ADD CONSTRAINT [FK__cc_elem_a__attac__628FA481] FOREIGN KEY ([attachment_id]) REFERENCES [cohesion].[cc_attachment] ([attachment_id])
GO
ALTER TABLE [cohesion].[cc_elem_attachment] ADD CONSTRAINT [FK__cc_elem_a__eleme__619B8048] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
Uses