ca_query_version

Used to store version info on a query

Column Name Column Datatype Column Null Option Column Comment
query_uuid byte(16) not null UUID of the query
query_version_uuid byte(16) not null UUID of the entity
query_domain_uuid byte(16) not null Object id of the domain where the query belongs to
label nvarchar(255) not null Label of query version, readable name. Will default to name of query and creation time of result.
flag integer with null Currently unused
creation_user nvarchar(255) with null Database user or component/process that created the record.
creation_date integer with null Creation date/time.
last_update_user nvarchar(255) with null Database user or component/process that last updated the record.
last_update_date integer with null Last change date/time.
version_number integer with null Last version number
auto_rep_version date with null  
domain_list nvarchar(2000) with null  
query_version_domain_uuid byte(16) with null  

Product Name: Unicenter Desktop and Server Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
query_uuid
query_version_uuid
ca_query_result query_version_uuid
query_uuid


Copyright © 2006 CA. All rights reserved.