This table contains information about software signatures. Most, but not all software releases, service packs, or patches as defined in the ca_software_def table will have a signature so that it can be detected by Unicenter when it is installed in the customer's environment. The contents of this table should not be modified directly by the user except on direct instructions from CA.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| signature_uuid | byte(16) | not null | The uuid of the signature. |
| sw_def_uuid | byte(16) | with null | The uuid of the associated software release, service pack, or patch as identified in the ca_software_def table. |
| signature_data | long nvarchar | not null | The signature itself represented in XML. |
| version | nvarchar(10) | with null | The signature version tag. |
| signature_type | smallint | with null | "Indicates the type of signature: 0 = Service 1 = Release 2 = Patch 3 = Configuration Setting " |
| export_date | integer | with null | ** check with Joe Otero or Jens Maagoe ** |
| is_active | integer1 | with null | |
| content_version_number | integer | not null | ** check with Joe Otero or Jens Maagoe ** |
| comment | nvarchar(512) | with null | An optional comment about the signature. |
| source_type_id | integer | with null | The type code identifying the source of data. See the ca_source_type table. |
| auto_rep_version | date | with null | ** Check with Jens Maagoe ** |
| creation_user | nvarchar(64) | with null | |
| signature_os_group_id | byte(16) | with null | The uuid of the OS group (family) for which this signature is applicable. See signature_os_group. |
| domain_uuid | byte(16) | with null | Domain uuid is used for replication on custom defined signatures. Is contains the unique domain uuid for a mdb instance |
| 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: Unicenter Patch Management
Table Type: Table