REFERENCE_VALUES

0 rows


Description

Miscellaneous reference values to support cascading updates.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int identity 4 null

The Hub record ID

REFERENCE_TABLE varchar 255 null

The name of the source table that the reference value is from

REFERENCE_COLUMN varchar 50 null

The name of the source column that the reference value is from

REFERENCE_ID int 4 null

The primary key ID from the reference table that identifies the reference value

REFERENCE_VALUE varchar 200 null

The referenced value

LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time Hub record was last modified

ACTIVE_HUB_PROCESS_ID bigint 8 null

The Hub sync process ID

ORG_ID int 4 null

Your organization’s unique identifier in the Active Net system

ROW_VERSION binary 8 null

System timestamp (for internal use)

Indexes

Constraint Name Type Sort Column(s)
REFERENCE_VALUES_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
REFERENCE_VALUES_REFERENCE_ID_REFERENCE_TABLE_REFERENCE_COLUMN_ORG_ID_IX Performance Asc/Asc/Asc/Asc REFERENCE_ID + REFERENCE_TABLE + REFERENCE_COLUMN + ORG_ID
REFERENCE_VALUES_ROW_VERSION_IX Performance Asc ROW_VERSION

Relationships