Entity Connection Types
The entity_connection_types table contains data about types of connections between entities present in the organization.
This table can be used to determine which connection types exist, as well as metadata about the type such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| entity_type_id_1 | The numerical identifier of the first entity type this connection is between. Relates to the id column in the entity_types table. |
INT4 | Yes |
| entity_type_id_2 | The numerical identifier of the second entity type this connection is between. Relates to the id column in the entity_types table. |
INT4 | Yes |
| display_position | Where on an entity's profile this connection type is displayed. 0 for above other fields in the information tab, and 1 for below. |
INT4 | No |
| created_by_id | The numerical identifier of the user that created this entity connection type. Relates to the id column in the users table. |
INT8 | No |
| updated_by_id | The numerical identifier of the user that last updated this entity connection type. Relates to the id column in the users table. |
INT8 | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |
| interact_id | The internal unique identifier for this entity connection type. | UUID | Yes |