[dbo].[ca_software_def_class_def

Property	Value
Row Count	65765
Created	10:24:00 AM Sunday, December 05, 2010
Last Modified	10:24:04 AM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_software_def_class_def_matrix: class_id\sw_def_uuid\sw_def_class_def_matrix_type_id$	class_id	int	4
$Cluster Primary Key XPKca_software_def_class_def_matrix: class_id\sw_def_uuid\sw_def_class_def_matrix_type_id$	sw_def_uuid	binary(16)	16
$Cluster Primary Key XPKca_software_def_class_def_matrix: class_id\sw_def_uuid\sw_def_class_def_matrix_type_id$	sw_def_class_def_matrix_type_id	int	4

	Name	Columns
$Cluster Primary Key XPKca_software_def_class_def_matrix: class_id\sw_def_uuid\sw_def_class_def_matrix_type_id$	XPKca_software_def_class_def_matrix	class_id, sw_def_uuid, sw_def_class_def_matrix_type_id
	xif1ca_software_def_class_def_ma	class_id
	xif2ca_software_def_class_def_ma	sw_def_uuid
	xif3ca_software_def_class_def_ma	sw_def_class_def_matrix_type_id

Name	Columns
$ca_so_r00001d4000000000	sw_def_class_def_matrix_type_id->[dbo].[ca_link_type].[link_type_id]
$ca_so_r00001d4a00000000	sw_def_uuid->[dbo].[ca_software_def].[sw_def_uuid]
$ca_so_r00001d5400000000	class_id->[dbo].[ca_class_def].[class_id]

Type	Action	Owning Principal
Grant	Insert	upmuser_group
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Delete	upmadmin_group
Grant	Insert	upmadmin_group
Grant	Delete	upmuser_group
Grant	Select	regadmin
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	ca_itrm_group_ams
Grant	Select	upmadmin_group
Grant	Update	upmadmin_group
Grant	Select	upmuser_group
Grant	Update	upmuser_group

SQL Script

CREATE TABLE [dbo].[ca_software_def_class_def_matrix]
(
[class_id] [int] NOT NULL,
[sw_def_uuid] [binary] (16) NOT NULL,
[sw_def_class_def_matrix_type_id] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[ca_software_def_class_def_matrix] ADD CONSTRAINT [XPKca_software_def_class_def_matrix] PRIMARY KEY CLUSTERED ([class_id], [sw_def_uuid], [sw_def_class_def_matrix_type_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif1ca_software_def_class_def_ma] ON [dbo].[ca_software_def_class_def_matrix] ([class_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif3ca_software_def_class_def_ma] ON [dbo].[ca_software_def_class_def_matrix] ([sw_def_class_def_matrix_type_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [xif2ca_software_def_class_def_ma] ON [dbo].[ca_software_def_class_def_matrix] ([sw_def_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_software_def_class_def_matrix] ADD CONSTRAINT [$ca_so_r00001d4000000000] FOREIGN KEY ([sw_def_class_def_matrix_type_id]) REFERENCES [dbo].[ca_link_type] ([link_type_id])
GO
ALTER TABLE [dbo].[ca_software_def_class_def_matrix] ADD CONSTRAINT [$ca_so_r00001d4a00000000] FOREIGN KEY ([sw_def_uuid]) REFERENCES [dbo].[ca_software_def] ([sw_def_uuid])
GO
ALTER TABLE [dbo].[ca_software_def_class_def_matrix] ADD CONSTRAINT [$ca_so_r00001d5400000000] FOREIGN KEY ([class_id]) REFERENCES [dbo].[ca_class_def] ([class_id])
GO
GRANT SELECT ON  [dbo].[ca_software_def_class_def_matrix] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_software_def_class_def_matrix] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_software_def_class_def_matrix] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_software_def_class_def_matrix] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_software_def_class_def_matrix] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_software_def_class_def_matrix] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_software_def_class_def_matrix] TO [upmadmin_group]
GRANT INSERT ON  [dbo].[ca_software_def_class_def_matrix] TO [upmadmin_group]
GRANT DELETE ON  [dbo].[ca_software_def_class_def_matrix] TO [upmadmin_group]
GRANT UPDATE ON  [dbo].[ca_software_def_class_def_matrix] TO [upmadmin_group]
GRANT SELECT ON  [dbo].[ca_software_def_class_def_matrix] TO [upmuser_group]
GRANT INSERT ON  [dbo].[ca_software_def_class_def_matrix] TO [upmuser_group]
GRANT DELETE ON  [dbo].[ca_software_def_class_def_matrix] TO [upmuser_group]
GRANT UPDATE ON  [dbo].[ca_software_def_class_def_matrix] TO [upmuser_group]
GO