DTW_TR_ACC_GROUP_MEMBERSHIP


Description

Holds the membership of accounts within a group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACCOUNT_GROUP_ID CHAR 36 null
DTW_TR_ACCOUNT_GROUP.ID DTW_TR_ACC_GRP_MSHIP_GRP_FK C

The id of the associated group
ACCOUNT_ID CHAR 36 null
DTW_TR_ACCOUNT.ID DTW_TR_ACC_GRP_MSHIP_ACC_FK C

The id of the associated account
CREATED_AT DATETIME 26 CURRENT_TIMESTAMP(6)

When the account type was created within the digital twin

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ACCOUNT_GROUP_ID + ACCOUNT_ID
DTW_TR_ACC_GRP_MSHIP_ACC_IDX Performance Asc ACCOUNT_ID
DTW_TR_ACC_GRP_MSHIP_GRP_IDX Performance Asc ACCOUNT_GROUP_ID

Relationships

Close relationships within degrees of separation