Tables [dbo].[usm_event_instance_value]
Properties
PropertyValue
Row Count0
Created11:08:10 AM Wednesday, March 07, 2007
Last Modified1:17:03 PM Tuesday, March 30, 2010
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKusm_event_instance_value: event_instance_value_idevent_instance_value_idint4
No
Foreign Keys $usm_e_r000022c500000000: [dbo].[usm_metric_attr_value].metric_attribute_value_idmetric_attribute_value_idint4
Yes
Foreign Keys $usm_e_r000022bb00000000: [dbo].[usm_event_instance].event_instance_idevent_instance_idint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_event_instance_value: event_instance_value_idXPKusm_event_instance_valueevent_instance_value_id
Yes
Foreign Keys Foreign Keys
NameColumns
$usm_e_r000022bb00000000event_instance_id->[dbo].[usm_event_instance].[event_instance_id]
$usm_e_r000022c500000000metric_attribute_value_id->[dbo].[usm_metric_attr_value].[metric_attribute_value_id]
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_event_instance_value]
(
[event_instance_value_id] [int] NOT NULL,
[metric_attribute_value_id] [int] NULL,
[event_instance_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_event_instance_value] ADD CONSTRAINT [XPKusm_event_instance_value] PRIMARY KEY CLUSTERED ([event_instance_value_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_event_instance_value] ADD CONSTRAINT [$usm_e_r000022bb00000000] FOREIGN KEY ([event_instance_id]) REFERENCES [dbo].[usm_event_instance] ([event_instance_id])
GO
ALTER TABLE [dbo].[usm_event_instance_value] ADD CONSTRAINT [$usm_e_r000022c500000000] FOREIGN KEY ([metric_attribute_value_id]) REFERENCES [dbo].[usm_metric_attr_value] ([metric_attribute_value_id])
GO
GRANT SELECT ON  [dbo].[usm_event_instance_value] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_event_instance_value] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_event_instance_value] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_event_instance_value] TO [usmgroup]
GO
Uses