[cohesion].[cc_user_role]
CREATE TABLE [cohesion].[cc_user_role]
(
[cendura_id] [int] NOT NULL,
[role_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_user_role] ADD CONSTRAINT [PK__cc_user_role__440B1D61] PRIMARY KEY CLUSTERED ([cendura_id], [role_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_user_role] ON [cohesion].[cc_user_role] ([role_id]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_user_role] ADD CONSTRAINT [FK__cc_user_r__cendu__45F365D3] FOREIGN KEY ([cendura_id]) REFERENCES [cohesion].[cc_user] ([cendura_id])
GO
ALTER TABLE [cohesion].[cc_user_role] ADD CONSTRAINT [FK__cc_user_r__role___44FF419A] FOREIGN KEY ([role_id]) REFERENCES [cohesion].[cc_role] ([role_id])
GO
![Foreign Keys FK__cc_user_r__cendu__45F365D3: [cohesion].[cc_user].cendura_id](../../Images/fk.gif)
