Table:object map

This table is for storing objects being linked (new in Release 2.6.6). Each row is a one-to-one mapping between a primary object and an associated object. If a primary object is associated with multiple objects, multiple rows are created, one for each mapping.

Columns

  • object_id: This is for storing primary objects' id
  • object_type_id
  • linked_object_id: This is for associated objects' id
  • linked_object_type_id
  • creator
  • creation_date

Examples

Example 1: A contract has several hardware. Contract ID will be stored in object_id column, and each associated hardware's ID will be stored in linked_object_id column.

Example 2: Users reported several issues with a particular software, that software's ID goes to object_id column, each issue ID goes to linked_object_id column.