Column |
Description |
|
siteID |
Required, used to setup multiple installs or test/live. Corresponds to the siteID in the ACConfigfile. |
userGUID |
Required, SQL Unique Key. Used for all lookups in the system. |
emailAddress |
Required, The username, must be unique |
password |
Required, Passwords are one-way hashes and are randomly generated initially unless set in admin or the user account settings screen. |
custID |
Required, The SL CustId tied to this user. |
fName |
Optional, the User's first name |
lName |
Optional, the User's last name |
lastUpdated |
Optional/automatic, records the last time the record was modified |
userContent |
Optional, text/html data specific to the user. |
timeStamp |
Required, the date the entry was first created |
active |
Required, whether this account should be allowed access. 1 = active, 0 = inactive |
admin |
Required, 1 = allows access to acAdmin. 0 = normal user |
user1 |
Optional, for customization purposes |
user2 |
Optional, for customization purposes |
user3 |
Optional, for customization purposes |
user4 |
Optional, for customization purposes |
user5 |
Optional, for customization purposes |
user6 |
Optional, for customization purposes |
user7 |
Optional, for customization purposes |
user8 |
Optional, for customization purposes |
user9 |
Optional, for customization purposes |
user10 |
Optional, for customization purposes |
user11 |
Optional, for customization purposes |