DTW_TR_PHYSICAL_BALANCE


Description

Holds the physical balance bound to a balance holder

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID CHAR 36 null

Identifiers the physical balance
BALANCE_TYPE VARCHAR 64 null
DTW_TR_BALANCE_TYPE.ID DTW_TR_PHYSICAL_BLC_TYPE_FK R

Identifies which kind of balance the underlying record holds
CURRENCY CHAR 3 null

Holds the currency of the value associated with the given balance
AMOUNT DECIMAL 19 null

Holds the value of the given balance
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the physical balance was created within the digital twin
UPDATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the physical balance was lastly updated
REFRESHED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the physical balance was lastly refreshed
BALANCE_HOLDER_TYPE VARCHAR 32 null

Holds the type of the balance account holder of the given balance (possible values: ACCOUNT)
BALANCE_HOLDER_ID CHAR 36 null

Identifiers the balance account holder of the given balance
LIMIT_HASH CHAR 36 null

The hash of the limit used to validate the given balance
VERSION CHAR 36 00000000-0000-0000-0000-000000000000

The version of the given balance (upon each update, it changes)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ID
DTW_TR_BALANCE_HOLDER_IDX Performance Asc/Asc BALANCE_HOLDER_ID + BALANCE_HOLDER_TYPE
DTW_TR_BALANCE_HOLDER_NTR_IDX Must be unique Asc/Asc/Asc BALANCE_HOLDER_ID + BALANCE_TYPE + BALANCE_HOLDER_TYPE
DTW_TR_BALANCE_TYPE_IDX Performance Asc BALANCE_TYPE

Relationships

Close relationships within degrees of separation