The vdsUserAttr table extends the vdsUser table with custom attributes (see vdsUser).
Columns
Table: vdsUserAttr table columns| Column name | Data type | Primary key | Nullable | Description |
|---|
| vdsDomain | varchar(255) | Yes | No | |
| vdsUserId | varchar(255) | Yes | No | |
| vdsAttrGroup | varchar(64) | Yes | No | |
| vdsSeqNo | integer | Yes | No | |
| vdsName | varchar(64) | No | No | |
| vdsUsageQual | varchar(64) | No | Yes | |
| vdsValue | varchar(1024) | No | Yes | |
| vdsOptions | integer | No | Yes | |
| vdsCreateTime | timestamp | No | No | The date and time the data record was created. |
| vdsModifyTime | timestamp | No | No | The date and time the data record was last modified. |
| vdsKeyID | varchar(255) | No | Yes | |
| vdsValueKeyID | varchar(255) | No | Yes | |
| vdsVersion | integer | No | Yes | The current data schema version of the data record. |
Keys
Primary key: (vdsDomain, vdsUserId, vdsAttrGroup, vdsSeqNo)
Foreign keys:
- (vdsDomain, vdsUserId) references vdsUser (vdsDomain, vdsUserId) ON DELETE CASCADE
- (vdsKeyID) references vdsKey (vdsKeyID)
- (vdsValueKeyID) references vdsKey (vdsKeyID)
Indexes
Table: vdsUserAttr table indexes| Index name | Included fields |
|---|
| Level 0 (default) |
| vdsuserattridx | vdsDomain vdsUserId vdsAttrGroup vdsSeqNo |