Tables [dbo].[wsm_link_icongrp_to_model]
Properties
PropertyValue
Row Count0
Created12:31:39 PM Sunday, December 05, 2010
Last Modified12:33:44 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKwsm_link_icongrp_to_model: icongroup_uuid\model_uuidForeign Keys r_129: [dbo].[wsm_icon_group].icongroup_uuidIndexes xif1wsm_link_icongrp_to_model: icongroup_uuidicongroup_uuidbinary(16)16
No
Cluster Primary Key XPKwsm_link_icongrp_to_model: icongroup_uuid\model_uuidForeign Keys r_130: [dbo].[wsm_model].model_uuidIndexes xif2wsm_link_icongrp_to_model: model_uuidmodel_uuidbinary(16)16
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwsm_link_icongrp_to_model: icongroup_uuid\model_uuidXPKwsm_link_icongrp_to_modelicongroup_uuid, model_uuid
Yes
xif1wsm_link_icongrp_to_modelicongroup_uuid
xif2wsm_link_icongrp_to_modelmodel_uuid
Foreign Keys Foreign Keys
NameColumns
r_129icongroup_uuid->[dbo].[wsm_icon_group].[id]
r_130model_uuid->[dbo].[wsm_model].[model_uuid]
SQL Script
CREATE TABLE [dbo].[wsm_link_icongrp_to_model]
(
[icongroup_uuid] [binary] (16) NOT NULL,
[model_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[wsm_link_icongrp_to_model] ADD CONSTRAINT [XPKwsm_link_icongrp_to_model] PRIMARY KEY CLUSTERED ([icongroup_uuid], [model_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_link_icongrp_to_model] ON [dbo].[wsm_link_icongrp_to_model] ([icongroup_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_link_icongrp_to_model] ON [dbo].[wsm_link_icongrp_to_model] ([model_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_link_icongrp_to_model] ADD CONSTRAINT [r_129] FOREIGN KEY ([icongroup_uuid]) REFERENCES [dbo].[wsm_icon_group] ([id])
GO
ALTER TABLE [dbo].[wsm_link_icongrp_to_model] ADD CONSTRAINT [r_130] FOREIGN KEY ([model_uuid]) REFERENCES [dbo].[wsm_model] ([model_uuid])
GO
Uses