GoldMine Table Structures.
USERLOG
DBase Directory Location: GMBASE
Table Description: Log file of user logins, duration and amount of work completed. Displayed in the
GoldMine system logs.
Table Indexes | |||
Name | DBase Index | SQL Index | ID |
USERLOG | USERID+LOGIN | USERID+LOGIN | - |
ULGRECID | RECID | RECID | - |
Table Relationships | |
Field | |
None |
Table Fields Structure | |||
Field Name | Field Type | Length | Description |
CRC | String | 2 | CRC code used as an integrity check to prevent tampering from outside sources. |
USERID | String | 8 | User Name |
LOGIN | String | 14 | Time logged in (Format YYYYMMDD HH:MM) |
LOGOUT | String | 14 | Time logged Out (Format YYYYMMDD HH:MM) |
INOUT | Integer | 2 | Number of times user logged in. If more than 1, Track Daily Totals has been turned on for this user. |
DUR | Long | 4 | Number of minutes logged in. If Track Daily Totals is turned on, this is the total login time for the day. |
KEYS | Long | 4 | Number of keys pressed |
CLICKS | Long | 4 | Number of mouse clicks |
RECID | String | 15 | Record ID |