Entity Connections
The entity_connections table contains data about connections between entities present in the organization.
This table can be used to determine which connections exist between which entities, as well as metadata about the connection such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| entity_connection_type_id | The numerical identifier of the type of this connection. Relates to the id column in the entity_connection_types table. |
INT8 | Yes |
| from_entity_id | The numerical identifier of the first entity this connection is between. Relates to the id column in the entities table. |
INT8 | Yes |
| to_entity_id | The numerical identifier of the second entity this connection is between. Relates to the id column in the entities table. |
INT8 | Yes |
| campaign_id | The numerical identifier of the campaign this connection is in. Relates to the id column in the campaigns table. |
INT8 | Yes |
| status | The status of this connection. 0 for inactive, and 1 for active. |
INT4 | No |
| created_by_id | The numerical identifier of the user that created this connection. Relates to the id column in the users table. |
INT8 | No |
| updated_by_id | The numerical identifier of the user that last updated this connection. Relates to the id column in the users table. |
INT8 | Yes |
| deleted_by_id | This column is currently unused. | INT8 | Yes |
| deleted_at | The UTC timestamp when this connection was deleted. | TIMESTAMP | 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 |
| imported | This column is currently unused. | BOOL | Yes |
| interact_id | The internal unique identifier for this connection. | UUID | No |