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