vdsUserAttr
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
|