Asset_Assignment describes a relationship between two assets. Each instance of this table is one parentchild arrangement.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| hier_parent | byte(16) | not null | Hierarchy parent. Foreign key to the id field of the ca_owned_resource table. |
| hier_child | byte(16) | not null | Hierarchy child. Foreign key to the id field of the ca_owned_resource table. |
| hier_log_date | integer | not null | Time of assignment |
| hier_license_num | nvarchar(40) | with null | License, serial # |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the UUID of the contact who last modified this record |
Product Name: Unicenter Service Desk
Table Type: Table