ANET_DELETE_TRACKING_LOG

0 rows


Description

Internal processing table

Columns

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

ACTIVE HUB ID identity value auto generated by system

ORG_ID int 4 null

Unique ID assigned to the ORG

DELETE_TRACKING_LOG_ID int 4 null

ID OF THE ANET_DELETE_TRACKING_LOG table. This is unique to individual org.

SOURCE_TABLENAME varchar 200 null

ORG Table name from which records were deleted

SOURCE_ID_VALUE int 4 null

ID of the record deleted

MIN_SOURCE_ID_VALUE int 4 null

If the table is bulk deleted, min ID value for that batch delete

MAX_SOURCE_ID_VALUE int 4 null

If the table is bulk deleted, min ID value for that batch delete

NUM_DELETED_RECORDS int 4 null

If the table is bulk deleted, number of records in that batch delete

SYSTEMUTCTIMESTAMP datetime 16,3 null

Date and time of the delete

meta_created datetime 16,3 null

Date and time when the record was pulled from source system

meta_updated datetime 16,3 null

Date and time when the updated record was pulled from source system

LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time when the record was pulled into AHUB

ACTIVE_HUB_PROCESS_ID bigint 8 null

Clover RUN ID

ROW_VERSION binary 8 null

System timestamp (for internal use)

Indexes

Constraint Name Type Sort Column(s)
ANET_DELETE_TRACKING_LOG_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
ANET_DELETE_TRACKING_LOG_Org_ID_DELETE_TRACKING_LOG_ID Performance Asc/Asc ORG_ID + DELETE_TRACKING_LOG_ID
ANET_DELETE_TRACKING_LOG_Org_ID_SOURCE_TABLENAME_SOURCE_ID_VALUE_SYSTEMUTCTIMESTAMP Performance Asc/Asc/Asc/Asc ORG_ID + SOURCE_TABLENAME + SOURCE_ID_VALUE + SYSTEMUTCTIMESTAMP
ANET_DELETE_TRACKING_LOG_ROW_VERSION_IX Performance Asc ROW_VERSION
ANET_DELETE_TRACKING_LOG_SOURCE_TABLENAME_IX Performance Asc SOURCE_TABLENAME

Relationships