Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AccessID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each access log entry |
||||
| Userid | int | 4 | √ | null |
|
|
User reference - Links to the user account that performed the login/logout action (foreign key to AccessUser.UserID) |
||||
| DateLogin | datetime | 16,3 | √ | null |
|
|
Login timestamp - Date and time when the user logged into the system |
||||
| DateLogout | datetime | 16,3 | √ | null |
|
|
Logout timestamp - Date and time when the user logged out of the system |
||||
| Duration | int | 4 | √ | null |
|
|
Session duration - Total time in minutes the user was logged into the system |
||||
| SessionID | varchar | 15 | √ | null |
|
|
Session identifier - Unique session ID for tracking user sessions and concurrent access |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AccessLog__4C171ED4 | Primary key | Asc | AccessID |
Relationships
Close relationships within degrees of separation
