
[dbo].[wsm_link_model_method_tmplate]
CREATE TABLE [dbo].[wsm_link_model_method_tmplate]
(
[model_method_uuid] [binary] (16) NOT NULL,
[model_uuid] [binary] (16) NOT NULL,
[rule_uuid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_link_model_method_tmplate] ADD CONSTRAINT [xpkwsm_link_model_method_tmpla] PRIMARY KEY CLUSTERED ([model_method_uuid], [model_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_link_model_method_tmpl] ON [dbo].[wsm_link_model_method_tmplate] ([model_method_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_link_model_method_tmpl] ON [dbo].[wsm_link_model_method_tmplate] ([model_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3wsm_link_model_method_tmplat] ON [dbo].[wsm_link_model_method_tmplate] ([rule_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_link_model_method_tmplate] ADD CONSTRAINT [r_1531] FOREIGN KEY ([model_method_uuid]) REFERENCES [dbo].[wsm_model_method_template] ([model_method_uuid])
GO
ALTER TABLE [dbo].[wsm_link_model_method_tmplate] ADD CONSTRAINT [r_1532] FOREIGN KEY ([model_uuid]) REFERENCES [dbo].[wsm_model] ([model_uuid])
GO
GRANT SELECT ON [dbo].[wsm_link_model_method_tmplate] TO [wsm_admin_group]
GRANT INSERT ON [dbo].[wsm_link_model_method_tmplate] TO [wsm_admin_group]
GRANT DELETE ON [dbo].[wsm_link_model_method_tmplate] TO [wsm_admin_group]
GRANT UPDATE ON [dbo].[wsm_link_model_method_tmplate] TO [wsm_admin_group]
GRANT SELECT ON [dbo].[wsm_link_model_method_tmplate] TO [wsm_ro_group]
GO