Tables [dbo].[upm_baseline_patch]
Properties
PropertyValue
Row Count0
Created11:08:11 AM Wednesday, March 07, 2007
Last Modified6:12:01 PM Monday, May 04, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKupm_baseline_patch: baseline_uuid\install_pkg_uuidForeign Keys $upm_b_r0000060700000000: [dbo].[upm_baseline_sw].baseline_uuidIndexes xif1upm_baseline_patch: baseline_uuidbaseline_uuidbinary(16)16
No
Cluster Primary Key XPKupm_baseline_patch: baseline_uuid\install_pkg_uuidForeign Keys $upm_b_r000005fd00000000: [dbo].[ca_install_package].install_pkg_uuidIndexes xif2upm_baseline_patch: install_pkg_uuidinstall_pkg_uuidbinary(16)16
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKupm_baseline_patch: baseline_uuid\install_pkg_uuidXPKupm_baseline_patchbaseline_uuid, install_pkg_uuid
Yes
xif1upm_baseline_patchbaseline_uuid
xif2upm_baseline_patchinstall_pkg_uuid
Foreign Keys Foreign Keys
NameColumns
$upm_b_r000005fd00000000install_pkg_uuid->[dbo].[ca_install_package].[install_pkg_uuid]
$upm_b_r0000060700000000baseline_uuid->[dbo].[upm_baseline_sw].[baseline_uuid]
Permissions
TypeActionOwning Principal
GrantDeleteupmuser_group
GrantInsertupmuser_group
GrantDeleteupmadmin_group
GrantInsertupmadmin_group
GrantSelectca_itrm_group
GrantSelectupmadmin_group
GrantUpdateupmadmin_group
GrantSelectupmuser_group
GrantUpdateupmuser_group
SQL Script
CREATE TABLE [dbo].[upm_baseline_patch]
(
[baseline_uuid] [binary] (16) NOT NULL,
[install_pkg_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_baseline_patch] ADD CONSTRAINT [XPKupm_baseline_patch] PRIMARY KEY CLUSTERED ([baseline_uuid], [install_pkg_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1upm_baseline_patch] ON [dbo].[upm_baseline_patch] ([baseline_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2upm_baseline_patch] ON [dbo].[upm_baseline_patch] ([install_pkg_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[upm_baseline_patch] ADD CONSTRAINT [$upm_b_r000005fd00000000] FOREIGN KEY ([install_pkg_uuid]) REFERENCES [dbo].[ca_install_package] ([install_pkg_uuid])
GO
ALTER TABLE [dbo].[upm_baseline_patch] ADD CONSTRAINT [$upm_b_r0000060700000000] FOREIGN KEY ([baseline_uuid]) REFERENCES [dbo].[upm_baseline_sw] ([baseline_uuid])
GO
GRANT SELECT ON  [dbo].[upm_baseline_patch] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[upm_baseline_patch] TO [upmadmin_group]
GRANT INSERT ON  [dbo].[upm_baseline_patch] TO [upmadmin_group]
GRANT DELETE ON  [dbo].[upm_baseline_patch] TO [upmadmin_group]
GRANT UPDATE ON  [dbo].[upm_baseline_patch] TO [upmadmin_group]
GRANT SELECT ON  [dbo].[upm_baseline_patch] TO [upmuser_group]
GRANT INSERT ON  [dbo].[upm_baseline_patch] TO [upmuser_group]
GRANT DELETE ON  [dbo].[upm_baseline_patch] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[upm_baseline_patch] TO [upmuser_group]
GO
Uses