ca_config_item

Used to track configuration management assets

Column Name Column Datatype Column Null Option Column Comment
config_item_uuid byte(16) not null  
asset_uuid byte(16) not null  
ci_version_label nvarchar(30) with null  
ci_version_number integer with null  
supply_date integer with null  
accept_date integer with null  
current_status nvarchar(50) with null  
scheduled_status nvarchar(50) with null  
comments nvarchar(255) with null  
creation_user nvarchar(64) with null  
creation_date integer with null  
last_update_user nvarchar(64) with null  
last_update_date integer with null  
version_number integer with null  

Product Name: Asset

Table Type: Table

Relationships:

Primary Key Related Table Related Column
config_item_uuid
asset_uuid
ca_link_config_item_doc config_item_uuid
asset_uuid
config_item_uuid
asset_uuid
ca_link_config_item config_item_uuid_1
asset_uuid
config_item_uuid
asset_uuid
ca_link_config_item config_item_uuid_2
asset_uuid
config_item_uuid
asset_uuid
ca_link_config_item config_item_uuid
asset_uuid
config_item_uuid
asset_uuid
ca_link_config_item config_item_uuid
asset_uuid
config_item_uuid
asset_uuid
ca_link_named_config_item config_item_uuid
asset_uuid


Copyright © 2006 CA. All rights reserved.