ca_software_license

Contains a list of purchased software licenses

Column Name Column Datatype Column Null Option Column Comment
license_uuid byte(16) not null Unique identifier for the license. Primary key.
license_type_id integer with null Foreign key to the id field of the ca_license_type table to represent license type. (e.g. user, site, CPU)
license_count integer with null License count included as part of a licensed software resource. (e.g. "50" in a "50-user license")
license_duration_unit integer with null Unit of time for which license is valid. (e.g. "day" in a "30-day trial license")
license_key nvarchar(255) with null License key.
license_duration integer with null Length of time for which license is valid. (e.g. "30" in a "30-day trial license")
asset_uuid byte(16) with null Foreign key to the ca_asset table for the software asset which this license represents.
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process that last updated the record.
last_update_date integer with null Date the record was last updated.
version_number integer with null Version number for transaction integrity.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete Time

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.