[dbo].[ca_asset

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	1706
Created	11:08:06 AM Wednesday, March 07, 2007
Last Modified	4:35:41 PM Wednesday, March 24, 2010

	Name	Data Type	Max Length (Bytes)	Default
	asset_source_uuid	binary(16)	16
$Indexes ca_asset_source_idx_04: logical_asset_uuid\exclude_registration$ $Indexes ca_asset_source_idx_01: logical_asset_uuid\subschema_id$ $Indexes ca_asset_source_idx_06: subschema_id\logical_asset_uuid$	logical_asset_uuid	binary(16)	16
	source_location_uuid	binary(16)	16
$Indexes ca_asset_source_idx_01: logical_asset_uuid\subschema_id$ $Indexes ca_asset_source_idx_06: subschema_id\logical_asset_uuid$	subschema_id	int	4
	creation_user	nvarchar(64)	128
	creation_date	int	4
	last_update_user	nvarchar(64)	128
	last_update_date	int	4
	version_number	int	4	((0))
$Indexes ca_asset_source_idx_04: logical_asset_uuid\exclude_registration$	exclude_registration	int	4
	delete_time	int	4
	exclude_reconciliation	smallint	2

	Name	Columns	Unique
	ca_asset_source_idx_02	asset_source_uuid
	ca_asset_source_idx_01	logical_asset_uuid, subschema_id
	ca_asset_source_idx_03	source_location_uuid
	ca_asset_source_idx_04	logical_asset_uuid, exclude_registration
	ca_asset_source_idx_06	subschema_id, logical_asset_uuid

Name	Columns
$ca_as_r000001f300000000	subschema_id->[dbo].[ca_asset_subschema].[subschema_id]
$ca_as_r000001fd00000000	source_location_uuid->[dbo].[ca_asset_source_location].[source_location_uuid]
$ca_as_r0000066500000000	logical_asset_uuid->[dbo].[ca_logical_asset].[logical_asset_uuid]

Type	Action	Owning Principal
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	regadmin
Grant	Insert	regadmin
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
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	Update	regadmin
Grant	Select	service_desk_admin_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	ucmadmin
Grant	Select	ucmuser
Grant	Select	uniadmin
Grant	Select	uniuser
Grant	Select	upmuser_group
Grant	Select	amsgroup
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
Grant	Select	ams_group

SQL Script

CREATE TABLE [dbo].[ca_asset_source]
(
[asset_source_uuid] [binary] (16) NOT NULL,
[logical_asset_uuid] [binary] (16) NULL,
[source_location_uuid] [binary] (16) NULL,
[subschema_id] [int] NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_asset___versi__515009E6] DEFAULT ((0)),
[exclude_registration] [int] NULL,
[delete_time] [int] NULL,
[exclude_reconciliation] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_asset_source] ADD CONSTRAINT [ca_asset_source_idx_02] PRIMARY KEY NONCLUSTERED ([asset_source_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_asset_source_idx_04] ON [dbo].[ca_asset_source] ([logical_asset_uuid], [exclude_registration]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_asset_source_idx_01] ON [dbo].[ca_asset_source] ([logical_asset_uuid], [subschema_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_asset_source_idx_03] ON [dbo].[ca_asset_source] ([source_location_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_asset_source_idx_06] ON [dbo].[ca_asset_source] ([subschema_id], [logical_asset_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_asset_source] ADD CONSTRAINT [$ca_as_r000001f300000000] FOREIGN KEY ([subschema_id]) REFERENCES [dbo].[ca_asset_subschema] ([subschema_id])
GO
ALTER TABLE [dbo].[ca_asset_source] ADD CONSTRAINT [$ca_as_r000001fd00000000] FOREIGN KEY ([source_location_uuid]) REFERENCES [dbo].[ca_asset_source_location] ([source_location_uuid])
GO
ALTER TABLE [dbo].[ca_asset_source] ADD CONSTRAINT [$ca_as_r0000066500000000] FOREIGN KEY ([logical_asset_uuid]) REFERENCES [dbo].[ca_logical_asset] ([logical_asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_asset_source] TO [aiadmin]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [ams_group]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [amsgroup]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [regadmin]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [regadmin]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [regadmin]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [swcmadmin]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [swcmadmin]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [swcmadmin]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uapmadmin]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [uapmadmin]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [uapmadmin]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uapmbatch]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [uapmbatch]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [uapmbatch]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[ca_asset_source] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[ca_asset_source] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[ca_asset_source] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uapmreporting]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [ucmuser]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [uniuser]
GRANT SELECT ON  [dbo].[ca_asset_source] TO [upmuser_group]
GO