Tables [dbo].[usm_slo_threshold]
Properties
PropertyValue
Row Count68
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_slo_threshold: slo_threshold_idslo_threshold_idint4
No
Foreign Keys $usm_s_r00002da100000000: [dbo].[usm_slo_instance].slo_instance_idIndexes IX_SLO_THRESHOLD_SLOINST: slo_instance_idslo_instance_idint4
Yes
thresholdfloat8
Yes
threshold_typeint4
Yes
threshold_orderint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_slo_threshold: slo_threshold_idXPKusm_slo_thresholdslo_threshold_id
Yes
IX_SLO_THRESHOLD_SLOINSTslo_instance_id
Foreign Keys Foreign Keys
NameColumns
$usm_s_r00002da100000000slo_instance_id->[dbo].[usm_slo_instance].[slo_instance_id]
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_slo_threshold]
(
[slo_threshold_id] [int] NOT NULL,
[slo_instance_id] [int] NULL,
[threshold] [float] NULL,
[threshold_type] [int] NULL,
[threshold_order] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_slo_threshold] ADD CONSTRAINT [XPKusm_slo_threshold] PRIMARY KEY CLUSTERED ([slo_threshold_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_SLO_THRESHOLD_SLOINST] ON [dbo].[usm_slo_threshold] ([slo_instance_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_slo_threshold] ADD CONSTRAINT [$usm_s_r00002da100000000] FOREIGN KEY ([slo_instance_id]) REFERENCES [dbo].[usm_slo_instance] ([slo_instance_id])
GO
GRANT SELECT ON  [dbo].[usm_slo_threshold] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_slo_threshold] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_slo_threshold] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_slo_threshold] TO [usmgroup]
GO
Uses