vdsUserAttr

The content is currently unavailable in French. You are viewing the default English version.

Résumé de l’article

Avez-vous trouvé ce résumé utile ?

Merci pour vos commentaires

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.

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)

Table: vdsUserAttr table indexes
Index name	Included fields
Level 0 (default)
vdsuserattridx	vdsDomain vdsUserId vdsAttrGroup vdsSeqNo

Cet article vous a-t-il été utile ?

Table des matières