Contains information about relationship links between entities. The information regarding the relationship links such as primary object, secondary object, link instance, link template name, date and time of creation, etc., is stored in this table. This information can be viewed in the Links pane of relationship node of either primary or secondary object’s main view.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| lkacadid | integer | not null | Relationship definition id |
| primary_object_uuid | byte(16) | not null | Primary object. Second part of the primary key. Foreign key to one of the following fields: ca_company.company_uuid, ca_contact.contact_uuid, ca_location.location_uuid, ca_owned_resource.own_resource_uuid, ca_model_def.model_uuid, arg_legaldoc.legaldoc_uuid. Object UUID is the Unicenter Unique ID that is assigned to UAPM objects at the time of creation. This field stores the primary object's uuid. |
| lkac1ivi | smallint | not null | Primary Object Version. Third part of the primary key. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid ign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid |
| lkacdadt | date | not null | Date. Fourth part of the primary key. |
| lkactitm | nvarchar(8) | not null | Time. Fifth part of the primary key. |
| lkndid | smallint | not null | Link template. Second part of the primary key. Linkes are created based on link templates. This field stores the template id. |
| secondary_object_uuid | byte(16) | not null | Secondary Object. Seventh part of the primary key. Foreign key to one of the following fields: ca_company.company_uuid, ca_contact.contact_uuid, ca_location.location_uuid, ca_owned_resource.own_resource_uuid, ca_model_def.model_uuid, arg_legaldoc.legaldoc_uuid. Object UUID is the Unicenter Unique ID that is assigned to UAPM objects at the time of creation. This field stores the secondary object's uuid. |
| lk2ivid | smallint | not null | Secondary Object Version. Eighth part of the primary key. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid |
| lkinstnc | smallint | not null | Link Instance. Ninth part of the primary key. |
| primary_object_type | smallint | with null | Object type |
| secondary_object_type | smallint | with null | Secondary object type |
| lkstrtdt | date | with null | Start date. Link start date. |
| lkenddt | date | with null | End date. Link end date. |
| lkcommnt | nvarchar(255) | with null | Comments |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Creation date |
| last_update_user | nvarchar(64) | with null | Last update user |
| last_update_date | integer | with null | Last update date |
| version_number | integer | with null | Version number |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table