[dbo].[ca_asset

Property	Value
Row Count	867
Created	11:08:06 AM Wednesday, March 07, 2007
Last Modified	9:07:48 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKca_asset_class: logical_asset_uuid\hierarchy_id$	logical_asset_uuid	binary(16)	16
$Cluster Primary Key XPKca_asset_class: logical_asset_uuid\hierarchy_id$ $Foreign Keys $ca_as_r0000020700000000: [dbo].[ca_class_hierarchy].hierarchy_id\class_id$	hierarchy_id	int	4
	override_weight	int	4
$Foreign Keys $ca_as_r0000020700000000: [dbo].[ca_class_hierarchy].hierarchy_id\class_id$	class_id	int	4
	overridden_class_id	int	4
	last_update_date	int	4

	Name	Columns	Unique
$Cluster Primary Key XPKca_asset_class: logical_asset_uuid\hierarchy_id$	XPKca_asset_class	logical_asset_uuid, hierarchy_id

Name	Columns
$ca_as_r0000020700000000	hierarchy_id->[dbo].[ca_class_hierarchy].[hierarchy_id] class_id->[dbo].[ca_class_hierarchy].[child_class_id]
$ca_as_r0000021000000000	hierarchy_id->[dbo].[ca_hierarchy].[hierarchy_id]
$ca_as_r0000021900000000	logical_asset_uuid->[dbo].[ca_logical_asset].[logical_asset_uuid]

Type	Action	Owning Principal
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	regadmin
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Select	aiadmin
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	regadmin
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[ca_asset_class]
(
[logical_asset_uuid] [binary] (16) NOT NULL,
[hierarchy_id] [int] NOT NULL,
[override_weight] [int] NULL,
[class_id] [int] NOT NULL,
[overridden_class_id] [int] NULL,
[last_update_date] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_asset_class] ADD CONSTRAINT [XPKca_asset_class] PRIMARY KEY CLUSTERED ([logical_asset_uuid], [hierarchy_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_asset_class] ADD CONSTRAINT [$ca_as_r0000020700000000] FOREIGN KEY ([hierarchy_id], [class_id]) REFERENCES [dbo].[ca_class_hierarchy] ([hierarchy_id], [child_class_id])
GO
ALTER TABLE [dbo].[ca_asset_class] ADD CONSTRAINT [$ca_as_r0000021000000000] FOREIGN KEY ([hierarchy_id]) REFERENCES [dbo].[ca_hierarchy] ([hierarchy_id])
GO
ALTER TABLE [dbo].[ca_asset_class] ADD CONSTRAINT [$ca_as_r0000021900000000] FOREIGN KEY ([logical_asset_uuid]) REFERENCES [dbo].[ca_logical_asset] ([logical_asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_asset_class] TO [aiadmin]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_asset_class] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_asset_class] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [regadmin]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_asset_class] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_asset_class] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [uapmadmin]
GRANT INSERT ON  [dbo].[ca_asset_class] TO [uapmadmin]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[ca_asset_class] TO [uapmadmin]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[ca_asset_class] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[ca_asset_class] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [uapmbatch]
GRANT INSERT ON  [dbo].[ca_asset_class] TO [uapmbatch]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[ca_asset_class] TO [uapmbatch]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[ca_asset_class] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[ca_asset_class] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[ca_asset_class] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [uapmreporting]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[ca_asset_class] TO [upmuser_group]
GO