Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | CHAR | 36 | null |
|
|
The id of the given group |
||||||||
| KIND | VARCHAR | 32 | null |
|
|
The type of the given group |
||||||||
| MEMBERSHIP_IDENTIFIER | VARCHAR | 256 | null |
|
|
The type of the given group |
||||||||
| CREATED_AT | DATETIME | 26 | CURRENT_TIMESTAMP(6) |
|
|
When the account was created within the digital twin |
||||||||
| UPDATED_AT | DATETIME | 26 | CURRENT_TIMESTAMP(6) |
|
|
When the account was lastly updated (does not take balances in account) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ID |
| DTW_TR_ACCOUNT_GROUP_NID_IDX | Must be unique | Asc/Asc | MEMBERSHIP_IDENTIFIER + KIND |
| DTW_TR_ACCOUNT_GROUP_TYPE_IDX | Performance | Asc | KIND |
Relationships
Close relationships within degrees of separation
