Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AccessID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| in_email | varchar | 50 | √ | null |
|
|
Login email - Email address provided during login attempt for user identification |
|
| in_password | varchar | 50 | √ | null |
|
|
Login password - Password provided during login attempt (stored for audit purposes) |
|
| in_companyID | varchar | 20 | √ | null |
|
|
Company identifier - Company or agency ID associated with the login attempt |
|
| in_SessionID | varchar | 30 | √ | null |
|
|
Session identifier - Unique session ID generated for the user’s login session |
|
| in_IPAddr | varchar | 30 | √ | null |
|
|
IP address - Client IP address from which the login attempt was made |
|
| out_userid | int | 4 | √ | null |
|
|
User ID result - System user ID returned after successful authentication |
|
| out_interalAgencyID | int | 4 | √ | null |
|
|
Internal agency ID - Internal agency identifier associated with the authenticated user |
|
| out_username | varchar | 150 | √ | null |
|
|
Username result - Username returned after successful authentication |
|
| out_LogoutMin | int | 4 | √ | null |
|
|
Logout timeout - Number of minutes until automatic logout for this session |
|
| out_CompanyName | varchar | 100 | √ | null |
|
|
Company name result - Company name returned after successful authentication |
|
| ser_LoginSuccess | varchar | 30 | √ | null |
|
|
Login success status - Indicates whether the login attempt was successful or failed |
|
| ser_DateLogin | datetime | 16,3 | √ | null |
|
|
Login timestamp - Date and time when the user logged into the system |
|
| ser_DateLogout | datetime | 16,3 | √ | null |
|
|
Logout timestamp - Date and time when the user logged out of the system |
|
| ser_Duration | int | 4 | √ | null |
|
|
Session duration - Total duration of the user session in minutes |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AccessUserLog__62A57E71 | Primary key | Asc | AccessID |