Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | CHAR | 36 | null |
|
|
Identifies the given snapshot |
|||||
| ACCOUNT_ID | CHAR | 36 | null |
|
|
The account associated with the given snapshot |
|||||
| LAST_ENTRY_ID | CHAR | 36 | 00000000-0000-0000-0000-000000000000 |
|
|
The entry id of the last entry that composed this balance snapshot |
|||||
| CREATED_AT | DATETIME | 26 | CURRENT_TIMESTAMP(6) |
|
|
When the balance snapshot was created |
|||||
| METADATA | JSON | 1073741824 | √ | null |
|
|
Holds a json object storing the underlying holder metadata |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ID |
| DTW_BST_SNAPSHOT_ACCOUNT_IDX | Performance | Asc | ACCOUNT_ID |
Relationships
Close relationships within degrees of separation
