
[cohesion].[cc_named_elem]
CREATE TABLE [cohesion].[cc_named_elem]
(
[element_id] [int] NOT NULL,
[elem_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_named_elem] ADD CONSTRAINT [PK__cc_named_elem__10566F31] PRIMARY KEY CLUSTERED ([element_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_named_elem] ON [cohesion].[cc_named_elem] ([elem_name]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_named_elem] ADD CONSTRAINT [FK__cc_named___eleme__114A936A] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO