Cards table
Description
The CARDS table contains all user badges.
Schéma
|
Field |
Type |
Required |
Primary Key |
Description |
|
crdID |
bigint |
* |
* |
internal identifier of the user's |
|
crdDOMAIN |
varchar(64) |
* |
* |
User's domain |
|
crdCARDID |
nvarchar(128) |
* |
|
read code of the badge |
|
crdUSER |
nvarchar(128) |
* |
|
user's login (identifier) |
|
crdCREATED |
datetime |
* |
|
creation date of the record |
|
crdUPDATE |
datetime |
|
|
date of last update |
|
crdEXPIRATION |
datetime |
|
|
expiration date of the badge |
|
crdLOCKED |
tinyint |
|
|
value indicating if the field is locked or not 0=not locked, 1=locked by admin, 2=locked automatically |
|
crdLOST |
tinyint |
|
|
value indicating if the badge is lost 0=not lost, 1=declared lost by admin, |
|
crdPASSWORD |
nvarchar(255) |
|
|
|
|
crdBILLINGCODE |
nvarchar(255) |
|
|
analytical code associated with the card |
|
crdLASTSEEN |
datetime |
|
|
date of the last use of the card |
|
crdLASTQUEUE |
varchar(64) |
|
|
id of the queue on which the user last used the card |
|
crdLOGINCOUNT |
bigint |
|
|
number of times the card has been used |
|
crdRETRIES |
tinyint |
|
|
number of times the badge has been used without success |
|
crdFULLNAME |
nvarchar(255) |
|
|
user's full name |
|
crdLABEL |
nvarchar(255) |
|
|
name given to the card |
|
crdSELFREG
|
varchar(64)
|
|
|
contains the identifier on which the auto-enrolment has been carried out |
|
crdEXTRA1 crdEXTRA2 |
ntext ntext |
|
|
RFU RFU |