[dbo].[ca_link_config

Property	Value
Row Count	0
Created	11:07:58 AM Wednesday, March 07, 2007
Last Modified	9:08:02 PM Friday, December 05, 2008

Property

Value

Row Count

Created

11:07:58 AM Wednesday, March 07, 2007

Last Modified

9:08:02 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)	Default
$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$ $Foreign Keys $ca_li_r0000032500000000: [dbo].[ca_config_item].config_item_uuid_1\asset_uuid_1$	config_item_uuid_1	binary(16)	16
$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$ $Foreign Keys $ca_li_r0000032500000000: [dbo].[ca_config_item].config_item_uuid_1\asset_uuid_1$	asset_uuid_1	binary(16)	16
$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$ $Foreign Keys $ca_li_r0000031b00000000: [dbo].[ca_config_item].config_item_uuid_2\asset_uuid_2$	config_item_uuid_2	binary(16)	16
$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$ $Foreign Keys $ca_li_r0000031b00000000: [dbo].[ca_config_item].config_item_uuid_2\asset_uuid_2$	asset_uuid_2	binary(16)	16
	link_type_id	int	4
	version_number	int	4	((0))
	last_update_date	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$ $Foreign Keys $ca_li_r0000032500000000: [dbo].[ca_config_item].config_item_uuid_1\asset_uuid_1$

config_item_uuid_1

binary(16)

asset_uuid_1

binary(16)

$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$ $Foreign Keys $ca_li_r0000031b00000000: [dbo].[ca_config_item].config_item_uuid_2\asset_uuid_2$

config_item_uuid_2

binary(16)

asset_uuid_2

binary(16)

link_type_id

int

version_number

int

((0))

last_update_date

int

	Name	Columns	Unique
$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$	XPKca_link_config_item	config_item_uuid_1, asset_uuid_1, config_item_uuid_2, asset_uuid_2

Name

Columns

Unique

$Cluster Primary Key XPKca_link_config_item: config_item_uuid_1\asset_uuid_1\config_item_uuid_2\asset_uuid_2$

XPKca_link_config_item

config_item_uuid_1, asset_uuid_1, config_item_uuid_2, asset_uuid_2

Name	Columns
$ca_li_r0000031100000000	link_type_id->[dbo].[ca_link_type].[link_type_id]
$ca_li_r0000031b00000000	config_item_uuid_2->[dbo].[ca_config_item].[config_item_uuid] asset_uuid_2->[dbo].[ca_config_item].[asset_uuid]
$ca_li_r0000032500000000	config_item_uuid_1->[dbo].[ca_config_item].[config_item_uuid] asset_uuid_1->[dbo].[ca_config_item].[asset_uuid]

Name

Columns

$ca_li_r0000031100000000

link_type_id->[dbo].[ca_link_type].[link_type_id]

$ca_li_r0000031b00000000

config_item_uuid_2->[dbo].[ca_config_item].[config_item_uuid]
asset_uuid_2->[dbo].[ca_config_item].[asset_uuid]

$ca_li_r0000032500000000

config_item_uuid_1->[dbo].[ca_config_item].[config_item_uuid]
asset_uuid_1->[dbo].[ca_config_item].[asset_uuid]

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Delete	ucmadmin
Grant	Insert	ucmadmin
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	regadmin
Grant	Select	ucmadmin
Grant	Update	ucmadmin
Grant	Select	ucmuser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams

Type

Action

Owning Principal

Grant

Delete

ca_itrm_group

Grant

Insert

ca_itrm_group

Grant

Delete

ucmadmin

Grant

Insert

ucmadmin

Grant

Delete

uniadmin

Grant

Insert

uniadmin

Grant

Select

ca_itrm_group

Grant

Update

ca_itrm_group

Grant

Select

regadmin

Grant

Select

ucmadmin

Grant

Update

ucmadmin

Grant

Select

ucmuser

Grant

Select

uniadmin

Grant

Update

uniadmin

Grant

Select

uniuser

Grant

Select

upmuser_group

Grant

Select

ca_itrm_group_ams

SQL Script

CREATE TABLE [dbo].[ca_link_config_item]
(
[config_item_uuid_1] [binary] (16) NOT NULL,
[asset_uuid_1] [binary] (16) NOT NULL,
[config_item_uuid_2] [binary] (16) NOT NULL,
[asset_uuid_2] [binary] (16) NOT NULL,
[link_type_id] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ca_link_c__versi__66161CA2] DEFAULT ((0)),
[last_update_date] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_config_item] ADD CONSTRAINT [XPKca_link_config_item] PRIMARY KEY CLUSTERED ([config_item_uuid_1], [asset_uuid_1], [config_item_uuid_2], [asset_uuid_2]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_link_config_item] ADD CONSTRAINT [$ca_li_r0000031100000000] FOREIGN KEY ([link_type_id]) REFERENCES [dbo].[ca_link_type] ([link_type_id])
GO
ALTER TABLE [dbo].[ca_link_config_item] ADD CONSTRAINT [$ca_li_r0000031b00000000] FOREIGN KEY ([config_item_uuid_2], [asset_uuid_2]) REFERENCES [dbo].[ca_config_item] ([config_item_uuid], [asset_uuid])
GO
ALTER TABLE [dbo].[ca_link_config_item] ADD CONSTRAINT [$ca_li_r0000032500000000] FOREIGN KEY ([config_item_uuid_1], [asset_uuid_1]) REFERENCES [dbo].[ca_config_item] ([config_item_uuid], [asset_uuid])
GO
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_link_config_item] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_link_config_item] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_link_config_item] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [ucmadmin]
GRANT INSERT ON  [dbo].[ca_link_config_item] TO [ucmadmin]
GRANT DELETE ON  [dbo].[ca_link_config_item] TO [ucmadmin]
GRANT UPDATE ON  [dbo].[ca_link_config_item] TO [ucmadmin]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [ucmuser]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [uniadmin]
GRANT INSERT ON  [dbo].[ca_link_config_item] TO [uniadmin]
GRANT DELETE ON  [dbo].[ca_link_config_item] TO [uniadmin]
GRANT UPDATE ON  [dbo].[ca_link_config_item] TO [uniadmin]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [uniuser]
GRANT SELECT ON  [dbo].[ca_link_config_item] TO [upmuser_group]
GO