CREATE TABLE [dbo].[wsm_model_relationship]
(
[model_uuid_aside] [binary] (16) NOT NULL,
[model_uuid_bside] [binary] (16) NOT NULL,
[a_side_count] [int] NULL,
[b_side_count] [int] NULL,
[mandatory] [int] NOT NULL,
[model_uuid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_model_relationship] ADD CONSTRAINT [XPKwsm_model_relationship] PRIMARY KEY CLUSTERED ([model_uuid_aside], [model_uuid_bside]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3wsm_model_relationship] ON [dbo].[wsm_model_relationship] ([model_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_model_relationship] ON [dbo].[wsm_model_relationship] ([model_uuid_aside]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_model_relationship] ON [dbo].[wsm_model_relationship] ([model_uuid_bside]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_model_relationship] ADD CONSTRAINT [r_114] FOREIGN KEY ([model_uuid_aside]) REFERENCES [dbo].[wsm_model] ([model_uuid])
GO
ALTER TABLE [dbo].[wsm_model_relationship] ADD CONSTRAINT [r_115] FOREIGN KEY ([model_uuid_bside]) REFERENCES [dbo].[wsm_model] ([model_uuid])
GO
ALTER TABLE [dbo].[wsm_model_relationship] ADD CONSTRAINT [r_127] FOREIGN KEY ([model_uuid]) REFERENCES [dbo].[wsm_model] ([model_uuid])
GO
GRANT SELECT ON  [dbo].[wsm_model_relationship] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_model_relationship] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_model_relationship] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_model_relationship] TO [wsm_admin_group]
GRANT SELECT ON  [dbo].[wsm_model_relationship] TO [wsm_ro_group]
GO