Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | CHAR | 40 | null |
|
|
Identifies the given polling entry |
||
| PARTITION_NUMBER | INT | 10 | null |
|
|
Identifies the given polling entry partition |
||
| ENTITY_ID | CHAR | 36 | null |
|
|
Identifies the id of the polleable entity this entry is related to |
||
| ENTITY_TYPE | VARCHAR | 64 | null |
|
|
Identifies the type of the polleable entity this entry is related to |
||
| CREATED_AT | DATETIME | 26 | CURRENT_TIMESTAMP(6) |
|
|
Identifies time of the creation of an entry |
||
| PROCESSED | TINYINT | 3 | 0 |
|
|
Identifies whether the entry was already processed |
||
| TRACE_METADATA | JSON | 1073741824 | √ | null |
|
|
||
| AGGREGATE_ROOT_ID | CHAR | 36 | √ | null |
|
|
Identifies the given polling entry target aggregate root id |
|
| AGGREGATE_ROOT_TYPE | VARCHAR | 32 | √ | null |
|
|
Identifies the given polling entry target aggregate root type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | ID + PARTITION_NUMBER + ENTITY_TYPE |
| DTW_CTR_POLLING_ENTRY_NID_IDX | Performance | Asc/Asc/Asc | PROCESSED + ENTITY_TYPE + ENTITY_ID |
| DTW_CTR_POLLING_ENTRY_NPT_IDX | Performance | Asc/Asc | PROCESSED + PARTITION_NUMBER |
| DTW_CTR_POLLING_ENTRY_PROCESSED_IDX | Performance | Asc | PROCESSED |
| DTW_CTR_POLLING_ENTRY_TSP_IDX | Performance | Asc/Asc/Asc | ENTITY_TYPE + PROCESSED + PARTITION_NUMBER |
Relationships
Close relationships within degrees of separation
