[dbo].[inv_generalinventory

Property	Value
Row Count	22017
Created	11:07:17 AM Wednesday, March 07, 2007
Last Modified	11:14:16 AM Wednesday, March 07, 2007

Property

Value

Row Count

22017

Created

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

Last Modified

11:14:16 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKinv_generalinventory_tree: object_uuid\item_id$ $Indexes inv_rep_idx1: object_uuid\item_id\item_index$ $Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$ $Indexes inv_generalinventory_tree_index1: object_uuid\item_root_name_id$	object_uuid	binary(16)	16
$Cluster Primary Key XPKinv_generalinventory_tree: object_uuid\item_id$ $Indexes inv_rep_idx1: object_uuid\item_id\item_index$	item_id	int	4
	item_root_id	int	4
$Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$	item_parent_id	int	4
$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$	item_parent_name_id	int	4
$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$	item_indent	int	4
$Indexes inv_rep_idx1: object_uuid\item_id\item_index$ $Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$	item_index	int	4
$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$	item_flag	int	4
$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$ $Indexes inv_generalinventory_tree_index1: object_uuid\item_root_name_id$	item_root_name_id	int	4
$Indexes inv_generalinventory_tree_index3: auto_rep_version\domain_uuid$ $Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$	domain_uuid	binary(16)	16
$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$ $Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$	item_name_id	int	4
$Indexes inv_generalinventory_tree_index3: auto_rep_version\domain_uuid$	auto_rep_version	timestamp	8
	object_type	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key XPKinv_generalinventory_tree: object_uuid\item_id$ $Indexes inv_rep_idx1: object_uuid\item_id\item_index$ $Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$ $Indexes inv_generalinventory_tree_index1: object_uuid\item_root_name_id$

object_uuid

binary(16)

$Cluster Primary Key XPKinv_generalinventory_tree: object_uuid\item_id$ $Indexes inv_rep_idx1: object_uuid\item_id\item_index$

item_id

int

item_root_id

int

$Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$

item_parent_id

int

$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$

item_parent_name_id

int

$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$

item_indent

int

$Indexes inv_rep_idx1: object_uuid\item_id\item_index$ $Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$

item_index

int

$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$

item_flag

int

$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$ $Indexes inv_generalinventory_tree_index1: object_uuid\item_root_name_id$

item_root_name_id

int

$Indexes inv_generalinventory_tree_index3: auto_rep_version\domain_uuid$ $Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$

domain_uuid

binary(16)

$Indexes inv_generalinventory_browse: item_root_name_id\item_parent_name_id\item_indent\item_flag\domain_uuid\item_name_id$ $Indexes inv_generalinventory_tree_index2: object_uuid\item_parent_id\item_name_id\item_index$

item_name_id

int

$Indexes inv_generalinventory_tree_index3: auto_rep_version\domain_uuid$

auto_rep_version

timestamp

object_type

int

	Name	Columns
$Cluster Primary Key XPKinv_generalinventory_tree: object_uuid\item_id$	XPKinv_generalinventory_tree	object_uuid, item_id
	inv_generalinventory_browse	item_root_name_id, item_parent_name_id, item_indent, item_flag, domain_uuid, item_name_id
	inv_generalinventory_tree_index1	object_uuid, item_root_name_id
	inv_generalinventory_tree_index2	object_uuid, item_parent_id, item_name_id, item_index
	inv_generalinventory_tree_index3	auto_rep_version, domain_uuid
	inv_rep_idx1	object_uuid, item_id, item_index

Name

Columns

Unique

$Cluster Primary Key XPKinv_generalinventory_tree: object_uuid\item_id$

XPKinv_generalinventory_tree

object_uuid, item_id

inv_generalinventory_browse

item_root_name_id, item_parent_name_id, item_indent, item_flag, domain_uuid, item_name_id

inv_generalinventory_tree_index1

object_uuid, item_root_name_id

inv_generalinventory_tree_index2

object_uuid, item_parent_id, item_name_id, item_index

inv_generalinventory_tree_index3

auto_rep_version, domain_uuid

inv_rep_idx1

object_uuid, item_id, item_index

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Insert	ca_itrm_group
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmadmin
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
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	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

Type

Action

Owning Principal

Grant

Delete

ca_itrm_group

Grant

Insert

uapmadmin

Grant

Delete

uapmbatch

Grant

Insert

uapmbatch

Grant

Delete

swcmadmin

Grant

Insert

swcmadmin

Grant

Insert

ca_itrm_group

Grant

Delete

uapmadmin_group

Grant

Insert

uapmadmin_group

Grant

Delete

uapmbatch_group

Grant

Insert

uapmbatch_group

Grant

Delete

uapmadmin

Grant

Select

ca_itrm_group

Grant

Update

ca_itrm_group

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

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].[inv_generalinventory_tree]
(
[object_uuid] [binary] (16) NOT NULL,
[item_id] [int] NOT NULL,
[item_root_id] [int] NULL,
[item_parent_id] [int] NULL,
[item_parent_name_id] [int] NULL,
[item_indent] [int] NULL,
[item_index] [int] NULL,
[item_flag] [int] NULL,
[item_root_name_id] [int] NULL,
[domain_uuid] [binary] (16) NULL,
[item_name_id] [int] NULL,
[auto_rep_version] [timestamp] NULL,
[object_type] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[inv_generalinventory_tree] ADD CONSTRAINT [XPKinv_generalinventory_tree] PRIMARY KEY CLUSTERED ([object_uuid], [item_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [inv_generalinventory_tree_index3] ON [dbo].[inv_generalinventory_tree] ([auto_rep_version], [domain_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [inv_generalinventory_browse] ON [dbo].[inv_generalinventory_tree] ([item_root_name_id], [item_parent_name_id], [item_indent], [item_flag], [domain_uuid], [item_name_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [inv_rep_idx1] ON [dbo].[inv_generalinventory_tree] ([object_uuid], [item_id], [item_index]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [inv_generalinventory_tree_index2] ON [dbo].[inv_generalinventory_tree] ([object_uuid], [item_parent_id], [item_name_id], [item_index]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [inv_generalinventory_tree_index1] ON [dbo].[inv_generalinventory_tree] ([object_uuid], [item_root_name_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [ams_group]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [amsgroup]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[inv_generalinventory_tree] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[inv_generalinventory_tree] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[inv_generalinventory_tree] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [swcmadmin]
GRANT INSERT ON  [dbo].[inv_generalinventory_tree] TO [swcmadmin]
GRANT DELETE ON  [dbo].[inv_generalinventory_tree] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[inv_generalinventory_tree] TO [swcmadmin]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin]
GRANT INSERT ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin]
GRANT DELETE ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[inv_generalinventory_tree] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch]
GRANT INSERT ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch]
GRANT DELETE ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[inv_generalinventory_tree] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [uapmreporting]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [uapmreporting_group]
GRANT SELECT ON  [dbo].[inv_generalinventory_tree] TO [upmuser_group]
GO