Expand All Collapse All
Individual Connection

IndivConnection Table

Individual Connection

This table stores the details of interaction addresses assigned to individuals. An individual can have more than one interaction address. There will be one record in this table for each interaction address assigned to an individual.

  • Table Type - Lookup
  • Last Changed Version - 16.1.0.378
  • Last Changed Reason - Added index IX_INDIVCONNECTION_SPINTX_RCL

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ConnInstID int False No

An identifier for each individual interaction address record in this table.

 4.0.106.453 4.0 Release
IndivID char (22) False Yes

A Globally Unique Identifier(GUID) to uniquely identify the individual (contact) that an interaction address is assigned to. Refer to the Individual table for more information regarding individuals (contacts).

 4.0.106.453 4.0 Release
ConnTypeID int False No

This column stores the identifier for the interaction address type that is being assigned to an individual. Refer to the ConnectionType table for more information regarding connection types (interaction address types) configured in your system.

 4.0.106.453 4.0 Release
ConnSubTypeId int False No

This column stores the identifier for the interaction address subtype that is being assigned to an individual. Refer to the ConnectionSubType table for more information about connection subtypes (intereaction address subtypes) configured in your system.

 4.0.106.453 4.0 Release
Value nvarchar (255) False Yes

This column stores the textual value of an individual interaction address. This value can be an email address, phone number, web url, etc.

 4.0.106.453 4.0 Release
IsDefault tinyint False No

Stores a value indicating whether or not an individual interaction address is the default interaction address for an individual. If this field is 1, this interaction address will be designated as the default interaction address for an individual (contact) in Interaction Desktop.

 4.0.106.453 4.0 Release
SystemInsertDate datetime2 True No

Stores the system date time when the individual interaction address record was inserted into the database.

 4.0.106.453 4.0 Release
Version int False No

Stores the version of an individual interaction address. Every time an individual interaction address is modified, the version field will be incremented.

 4.0.106.453 4.0 Release

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_IndivConnection Non-clustered ConnInstID (Ascending)
IndivID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_IndivConn_IndivID IndivID Individual IndivID Yes
FK_IndivConn_ConnTypeID ConnTypeID ConnectionType ConnTypeID Yes
FK_IndivConn_ConnSubTypeID ConnSubTypeId ConnSubType ConnSubTypeId Yes

Index Name Type Column Name (sort order)
IX_IndivConn_IndivID_IsDef Clustered IndivID (Ascending)
IsDefault (Descending)
IX_IndivConnection_SPINTX_RCL Non-clustered IndivID (Ascending)
IX_IndivConnection_Value Non-clustered Value (Ascending)