Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | CHAR | 36 | null |
|
|
The ID of the given revision change |
|||||
| REVISION_ID | DECIMAL | 32 | null |
|
|
The revision associated with the given revision change |
|||||
| ENTITY_TYPE | VARCHAR | 32 | null |
|
|
The type of the entity being changed |
|||||
| ENTITY_ID | CHAR | 36 | null |
|
|
The id of the entity being changed |
|||||
| AGGREGATE_ROOT_TYPE | VARCHAR | 32 | null |
|
|
The type of the aggregate root of the entity being changed |
|||||
| AGGREGATE_ROOT_ID | CHAR | 36 | null |
|
|
The id of the aggregate root of the entity being changed |
|||||
| AGGREGATE_ROOT_KEY | VARCHAR | 64 | null |
|
|
The aggregate root key |
|||||
| REVISION_TYPE | DECIMAL | 1 | null |
|
|
The revision type (e.g., DELETE, UPDATE, or INSERT) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ID |
| DTW_REG_REV_CHANGE_AG_IDX | Performance | Asc/Asc | AGGREGATE_ROOT_TYPE + AGGREGATE_ROOT_ID |
| DTW_REG_REV_CHANGE_AY_IDX | Performance | Asc | AGGREGATE_ROOT_TYPE |
| DTW_REG_REV_CHANGE_ET_IDX | Performance | Asc/Asc | ENTITY_TYPE + ENTITY_ID |
| DTW_REG_REV_CHANGE_EY_IDX | Performance | Asc | ENTITY_TYPE |
| DTW_REG_REV_CHANGE_RV_IDX | Performance | Asc | REVISION_ID |
Relationships
Close relationships within degrees of separation
