DTW_TR_ACCOUNT_SNAPSHOT_STATE


Description

Manages the account balance snapshot

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACCOUNT_ID CHAR 36 null
DTW_TR_ACCOUNT.ID DTW_TR_ACC_SS_STE_ACC_FK R

Identifies the account associated
LAST_SNAPSHOT_ID CHAR 36 null
DTW_TR_SNAPSHOT.ID DTW_TR_ACC_SS_STE_LS_FK C

Identifies the last known snapshot
VERSION CHAR 36 null

Identifies the snapshot version

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ACCOUNT_ID
DTW_TR_ACC_SS_STE_LS_IDX Must be unique Asc LAST_SNAPSHOT_ID

Relationships

Close relationships within degrees of separation