Tables [dbo].[wsm_link_model_method_tmplate]
Properties
PropertyValue
Row Count0
Created12:31:39 PM Sunday, December 05, 2010
Last Modified12:33:46 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key xpkwsm_link_model_method_tmpla: model_method_uuid\model_uuidForeign Keys r_1531: [dbo].[wsm_model_method_template].model_method_uuidIndexes xif1wsm_link_model_method_tmpl: model_method_uuidmodel_method_uuidbinary(16)16
No
Cluster Primary Key xpkwsm_link_model_method_tmpla: model_method_uuid\model_uuidForeign Keys r_1532: [dbo].[wsm_model].model_uuidIndexes xif2wsm_link_model_method_tmpl: model_uuidmodel_uuidbinary(16)16
No
Indexes xif3wsm_link_model_method_tmplat: rule_uuidrule_uuidbinary(16)16
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key xpkwsm_link_model_method_tmpla: model_method_uuid\model_uuidxpkwsm_link_model_method_tmplamodel_method_uuid, model_uuid
Yes
xif1wsm_link_model_method_tmplmodel_method_uuid
xif2wsm_link_model_method_tmplmodel_uuid
xif3wsm_link_model_method_tmplatrule_uuid
Foreign Keys Foreign Keys
NameColumns
r_1531model_method_uuid->[dbo].[wsm_model_method_template].[model_method_uuid]
r_1532model_uuid->[dbo].[wsm_model].[model_uuid]
Permissions
TypeActionOwning Principal
GrantDeletewsm_admin_group
GrantInsertwsm_admin_group
GrantSelectwsm_admin_group
GrantUpdatewsm_admin_group
GrantSelectwsm_ro_group
SQL Script
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
Uses