Users table
Description
This table is used to store information about the guest accounts (guest database).
Schema
|
Field |
Type |
Required |
Primary key |
Description |
|
userID |
bigint |
* |
* |
Guest's login |
|
userLOGIN |
nvarchar(128) |
* |
|
COLLATE English_CI_AS user login |
|
userPASSWORD |
nvarchar(255) |
|
|
user's password |
|
userFULLNAME |
nvarchar(255) |
|
|
COLLATE French_CI_AS user's full name (first name) |
|
userEMAIL |
nvarchar(255) |
|
|
user's email address |
|
userDYNGROUP |
nvarchar(128) |
|
|
Group to which the user belongs |
|
userCODE |
nvarchar(255) |
|
|
guest's analytic code |
|
userHOMEFOLDER |
nvarchar(255) |
|
|
name of the user's folder in which his or her scanned jobs are stored |
|
userPIN |
varchar(64) |
|
|
PIN code associated with the user |
|
userCARD |
nvarchar(255) |
|
|
user's badge code |
|
userCOMPANY |
nvarchar(255) |
|
|
COLLATE French_CI_AS company to which the user belongs |
|
userCREATED |
datetime |
|
|
user's creation date |
|
userCREATEDBY |
nvarchar(128) |
|
|
COLLATE English_CI_AS ID of the administrator who created the user account |
|
userUPDATED |
datetime |
|
|
Date the user was updated |
|
userUPDATEDBY |
nvarchar(128) |
|
|
COLLATE English_CI_AS identifier of the administrator who updated the user account |
|
userEXPIRATION |
datetime |
|
|
expiration date of the user account |
|
userLOCKED |
tinyint |
|
|
locked user account (0=no; 1=yes). |
|
userVISITEDPERSON |
nvarchar(128) |
|
|
COLLATE English_CI_AS identifier of a visitor associated to the user |
|
userPUK |
varchar(128) |
|
|
PUK code associated to the user |