CREATE TABLE [dbo].[wsm_dc_resource]
(
[res_id] [int] NOT NULL,
[res_type] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[res_subtype] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[res_instance] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[attribute_type_id] [int] NULL,
[templateuuid] [binary] (16) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_dc_resource] ADD CONSTRAINT [XPKwsm_dc_resource] PRIMARY KEY CLUSTERED ([res_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1wsm_dc_resource] ON [dbo].[wsm_dc_resource] ([attribute_type_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [xwsm_dc_resource_id] ON [dbo].[wsm_dc_resource] ([res_type], [res_subtype], [res_instance]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2wsm_dc_resource] ON [dbo].[wsm_dc_resource] ([templateuuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_dc_resource] ADD CONSTRAINT [r_1544] FOREIGN KEY ([attribute_type_id]) REFERENCES [dbo].[wsm_attribute_type] ([attribute_type_id])
GO
ALTER TABLE [dbo].[wsm_dc_resource] ADD CONSTRAINT [r_1545] FOREIGN KEY ([templateuuid]) REFERENCES [dbo].[wsm_template] ([templateuuid])
GO