DTW_TR_SNAPSHOT


Description

Holds balance snapshots

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null
DTW_TR_ACCOUNT_SNAPSHOT_STATE.LAST_SNAPSHOT_ID DTW_TR_ACC_SS_STE_LS_FK C
DTW_TR_SNAPSHOT_BALANCE.SNAPSHOT_ID DTW_TR_BALANCE_SNAPSHOT_FK C

Identifies the given snapshot
ACCOUNT_ID CHAR 36 null
DTW_TR_ACCOUNT.ID DTW_TR_SNAPSHOT_ACCOUNT_FK C

The account associated with the given entry batch
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the entry batch group was created
ENTRY_BATCH_GROUP_ID CHAR 36 √ null
DTW_TR_ENTRY_BATCH_GROUP.ID DTW_TR_SNAPSHOT_GROUP_FK C

Identifies the entry batch group associated with snapshot
LAST_ENTRY_ID CHAR 36 00000000-0000-0000-0000-000000000000

The entry id of the last entry that composed this balance snapshot

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_SNAPSHOT_ACCOUNT_IDX Performance Asc ACCOUNT_ID
DTW_TR_SNAPSHOT_GROUP_IDX Must be unique Asc ENTRY_BATCH_GROUP_ID

Relationships

Close relationships within degrees of separation