Database Properties
Database Type: MySQL - 8.4.8
Tables
| Table / View | Children | Parents | Columns | Type | Comments |
|---|---|---|---|---|---|
| DTW_TR_INTENT_ENTRY_REL | 0 | 2 | 2 | Table | Links an intent to its entries |
| DTW_TR_IDEMPOTENCY_ENTRY | 0 | 0 | 4 | Table | Holds each entities changed on which revision (and their corresponding aggregates) |
| DTW_TRS_BATCH_JOB_EXECUTION_PARAMS | 0 | 1 | 8 | Table | |
| DTW_TR_ENTRY_BATCH | 1 | 1 | 4 | Table | Groups entries of an account into a single batch |
| DTW_TR_MONITORING_PROCESS_REL | 1 | 1 | 7 | Table | Holds the monitoring related process |
| DTW_TR_EVENT_ROUTING_DATA | 0 | 1 | 3 | Table | Holds the routed event data |
| DTW_TR_EVENT_ROUTING | 1 | 0 | 7 | Table | Holds event routing |
| DTW_TR_DATABASECHANGELOG | 0 | 0 | 14 | Table | |
| DTW_TRS_BATCH_JOB_EXECUTION_SEQ | 0 | 0 | 2 | Table | |
| DTW_TR_HOLD_REASON_FEATURE | 0 | 1 | 7 | Table | Holds the available hold reason features |
| DTW_TR_HISTORY_CODE | 3 | 1 | 6 | Table | Holds the available history codes (formerly known as entry types) |
| DTW_TR_BALANCE_TYPE_FEATURE | 0 | 1 | 7 | Table | Holds the balance type features |
| DTW_TR_ACC_TYPE_FEATURE | 0 | 1 | 7 | Table | Holds the account type features |
| DTW_TR_ENTRY | 9 | 2 | 10 | Table | Holds an entry bound to an account |
| DTW_TR_HISTORY_CODE_FEAT | 0 | 1 | 7 | Table | Holds the history code features |
| DTW_TR_DATABASECHANGELOGLOCK | 0 | 0 | 4 | Table | |
| DTW_TR_METADATA | 0 | 0 | 4 | Table | Holds the metadata associated to an entity |
| DTW_TR_SYS | 1 | 0 | 4 | Table | |
| DTW_TR_VALIDATION_R_BLUEPRINT | 0 | 2 | 4 | Table | Holds a exception blueprint for a pattern-based validation rule |
| DTW_TRS_SCHEDULE_LIMIT | 1 | 1 | 5 | Table | Schedule limit events |
| DTW_TRS_BATCH_JOB_SEQ | 0 | 0 | 2 | Table | |
| DTW_TR_ACCOUNT | 5 | 1 | 8 | Table | Holds an account |
| DTW_TR_INTENT | 10 | 0 | 9 | Table | Holds assorted intents |
| DTW_TR_ACCOUNT_FEATURE | 0 | 1 | 7 | Table | Holds the account features |
| DTW_TR_ENTRY_FULFILLMENT | 0 | 2 | 3 | Table | Holds the relationship between a pending entry and its fulfillment |
| DTW_TRS_BATCH_JOB_EXECUTION_CONTEXT | 0 | 1 | 3 | Table | |
| DTW_TR_BALANCE_TYPE | 11 | 0 | 10 | Table | Holds a balance types |
| DTW_TRS_BATCH_STEP_EXECUTION | 1 | 1 | 18 | Table | |
| DTW_TR_INTENT_EXCLUSION | 0 | 1 | 3 | Table | Holds the a exclusion intent |
| DTW_TR_CORRELATION_ID | 0 | 0 | 9 | Table | Holds a correlation ids |
| DTW_TR_SYS_FEAT | 0 | 1 | 7 | Table | |
| DTW_TR_SNAPSHOT_BALANCE | 0 | 2 | 4 | Table | Holds the amount on balance snapshots |
| DTW_TR_AUD | 0 | 0 | 18 | Table | |
| DTW_TR_LIMIT | 0 | 0 | 9 | Table | Holds the limit associated with a particular balance |
| DTW_TR_MONITORING_RELEASE | 1 | 1 | 6 | Table | Holds the monitoring release |
| DTW_TRS_BATCH_JOB_EXECUTION | 3 | 1 | 11 | Table | |
| DTW_TR_RULE_PATTERN | 3 | 1 | 6 | Table | Holds a rule pattern |
| DTW_TR_PATTERN_RULE_BALANCE | 0 | 3 | 3 | Table | |
| DTW_TR_PHYSICAL_BALANCE | 0 | 1 | 11 | Table | Holds the physical balance bound to a balance holder |
| DTW_TR_ACCOUNT_TYPE | 2 | 0 | 6 | Table | Holds the available account types |
| DTW_TRS_BATCH_JOB_INSTANCE | 1 | 0 | 4 | Table | |
| DTW_TR_BALANCE_LAYER | 0 | 2 | 3 | Table | Binds a composite balance (parent) to its components (children) |
| DTW_TR_ACC_GROUP_MEMBERSHIP | 0 | 2 | 3 | Table | Holds the membership of accounts within a group |
| DTW_TR_BLOCKING_RELATED_ENTRY | 0 | 3 | 4 | Table | Links an intent to its entries |
| DTW_TR_ACTIVE_MONITORING | 0 | 1 | 3 | Table | Active monitorings |
| DTW_TR_INTENT_BLUEPRINT | 0 | 1 | 2 | Table | Holds the blueprint associated with a given intent |
| DTW_TR_ACC_GROUP_BALANCE_TYPE | 0 | 1 | 2 | Table | Holds the available account types |
| DTW_TR_ACCOUNT_GROUP_FEATURE | 0 | 1 | 4 | Table | Holds account groups features. The semantics of any given feature is given by the underlying account group type |
| DTW_TRS_CURRENT_LIMIT | 0 | 0 | 10 | Table | Schedule limit events |
| DTW_TR_INTENT_ENTRY_TRIGGER | 0 | 1 | 5 | Table | Holds the trigger associated with a given intent |
| DTW_TR_ENTRY_BATCH_GROUP | 2 | 1 | 4 | Table | Groups batches |
| DTW_TR_MONITORING_RELEASE_ENTRIES | 0 | 2 | 2 | Table | Holds the monitoring release |
| DTW_TR_MONITORING | 0 | 0 | 2 | Table | Holds assorted monitoring |
| DTW_TR_LOCK_ENTRY | 0 | 0 | 5 | Table | |
| DTW_TR_POLLING_ENTRY | 0 | 0 | 9 | Table | Holds the entries for the polling mechanism |
| DTW_TR_ACCOUNT_GROUP | 2 | 0 | 5 | Table | Holds account groups |
| DTW_TR_MONITORING_BALANCE_REL | 0 | 2 | 2 | Table | Holds assorted monitoring/balances relationship |
| DTW_TR_BALANCE_PATTERN_BKP | 2 | 1 | 6 | Table | Holds a balance pattern |
| DTW_TR_BALANCE_CRITERION_BKP | 0 | 1 | 6 | Table | Holds a balance pattern criterion |
| DTW_TR_AFFECTED_BLC_CTG_BPK | 1 | 0 | 4 | Table | Holds a balance pattern category |
| DTW_TRS_BATCH_STEP_EXECUTION_CONTEXT | 0 | 1 | 3 | Table | |
| DTW_TR_COMPENSATING_ENTRY | 0 | 1 | 3 | Table | Holds the a compensating entry (e.g., exclusion, reversal, and etc) |
| DTW_TR_MONITORING_PROCESS_REL_ENTRIES | 0 | 2 | 2 | Table | Holds the monitoring related process entries |
| DTW_TR_ACCOUNT_SNAPSHOT_STATE | 0 | 2 | 3 | Table | Manages the account balance snapshot |
| DTW_TRS_SCHEDULE_LIMIT_TIME | 0 | 1 | 10 | Table | Schedule limit time |
| DTW_TR_PATTERN_BASED_RULE | 3 | 0 | 5 | Table | Holds a pattern based rule |
| DTW_TR_HOLD_REASON | 2 | 0 | 5 | Table | Holds the available hold reason codes for entry |
| DTW_TRS_BATCH_STEP_EXECUTION_SEQ | 0 | 0 | 2 | Table | |
| DTW_TR_ACCOUNT_BASED_INTENT | 0 | 1 | 3 | Table | Links account based intent to its account |
| DTW_TR_BALANCE_PATTERN_BLC_BKP | 0 | 2 | 2 | Table | |
| DTW_TR_ENTRY_BALANCE_CHANGE | 0 | 2 | 4 | Table | Holds which balances were change by an entry |
| DTW_TR_INTENT_METADATA | 0 | 1 | 2 | Table | Holds the metadata associated to an intent |
| DTW_TR_SNAPSHOT | 2 | 2 | 5 | Table | Holds balance snapshots |
| DTW_TR_CRITERION | 0 | 1 | 6 | Table | Holds a criterion |
| DTW_TR_BALANCE_PATTERN_BALANCE | 0 | 0 | 2 | View | |
| DTW_TRS_SCHEDULE_LIMIT_CANDIDATE | 0 | 0 | 8 | View | |
| DTW_TR_AFFECTED_BALANCE_CTG | 0 | 0 | 4 | View | |
| DTW_TR_BALANCE_PATTERN | 0 | 0 | 6 | View | |
| DTW_TR_BALANCE_CRITERION | 0 | 0 | 6 | View | |
| DTW_TR_POLLING_ENTRY_PARTITION_STATE | 0 | 0 | 3 | View |