Database Properties
Database Type: MySQL - 8.4.8
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| DTW_BST_ACCOUNT_FEATURE | 0 | 1 | 7 | Table | Holds the account features |
| DTW_BST_POLLING_ENTRY | 0 | 0 | 9 | Table | Holds the entries for the polling mechanism |
| DTW_BST_ENTRY_DETAILS | 0 | 1 | 6 | Table | Details associated with a metadata entry. |
| DTW_BST_DIM_HISTORY | 2 | 0 | 7 | Table | History dimension definition table. |
| DTW_BST_BALANCE_LAYER | 0 | 0 | 2 | Table | Balance type composition. |
| DTW_BST_SNAPSHOT_BALANCE | 0 | 1 | 4 | Table | Holds the amount on balance snapshots |
| DTW_BST_ACCOUNT_HOLDER | 0 | 0 | 4 | Table | Holds the taxId bound to a account holder |
| DTW_BST_AUD | 0 | 0 | 18 | Table | |
| DTW_BST_EVENT_ROUTING_DATA | 0 | 1 | 3 | Table | Holds the routed event data |
| DTW_BST_BALANCE_CORRELATION_ID | 0 | 0 | 4 | Table | Correlation Ids for a Balance Snapshot. |
| DTW_BST_SNAPSHOT | 1 | 1 | 5 | Table | Holds balance snapshots |
| DTW_BST_ACCOUNT_MEMBERSHIP | 1 | 1 | 4 | Table | Holds the bound to a account holder |
| DTW_BST_FACT_ENTRY | 4 | 6 | 13 | Table | Entry fact table definition. |
| DTW_BST_DIM_BALANCE_TYPE | 3 | 0 | 4 | Table | Balance type dimension table definition. |
| DTW_BST_DIM_DATE | 3 | 0 | 10 | Table | Entry date dimension definition table. |
| DTW_BST_EVENT_ROUTING | 1 | 0 | 7 | Table | Holds event routing |
| DTW_BST_DATABASECHANGELOG | 0 | 0 | 14 | Table | |
| DTW_BST_FACT_BALANCE | 0 | 3 | 9 | Table | Balance fact table definition. |
| DTW_BST_DIM_LIMIT | 0 | 0 | 12 | Table | Holder limit dimension definition table. |
| DTW_BST_ENTRY_FEATURE | 0 | 1 | 6 | Table | Entry Feature , searchable key/value |
| DTW_BST_COMPENSATING_ENTRY | 0 | 2 | 3 | Table | Entries compensated information |
| DTW_BST_DATABASECHANGELOGLOCK | 0 | 0 | 4 | Table | |
| DTW_BST_DIM_ENTRY_CATEGORY | 1 | 0 | 4 | Table | Entry kind category sub dimension definition table. |
| DTW_BST_DIM_ENTRY_KIND | 1 | 0 | 4 | Table | Entry kind dimension definition table. |
| DTW_BST_DIM_ACCOUNT_TYPE | 1 | 0 | 7 | Table | Account type dimension definition table. |
| DTW_BST_DIM_TIME | 1 | 0 | 6 | Table | Entry time dimension definition table. |
| DTW_BST_DIM_ACCOUNT | 6 | 1 | 7 | Table | Account status dimension definition table. |
| DTW_BST_BALANCE | 0 | 2 | 10 | Table | Holds the daily checking account balance |
| DTW_BST_IDEMPOTENCY_ENTRY | 0 | 0 | 4 | Table | Holds each entities changed on which revision (and their corresponding aggregates) |
| DTW_BST_ENTRY_CORRELATION_ID | 0 | 0 | 5 | Table | Correlation Ids for a Entry. |
| DTW_BST_PENDING_BALANCE | 0 | 1 | 8 | Table | Holds the pending balance bound to a balance holder |
| DTW_BST_ACC_MEMBERSHIP_FEAT | 0 | 1 | 7 | Table | Holds the bound to a account membership |
| DTW_BST_DIM_DOCUMENT_TYPE | 0 | 2 | 6 | Table | Document Type dimension definition table. |
| DTW_BST_POLLING_ENTRY_PARTITION_STATE | 0 | 0 | 3 | View |