Users and access

User Logins data set: columns, keys and joins

Primary key: LoginAttemptId 9 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
UserIdint4FK
UserNamenvarchar256
IPvarchar64
SessionIdint4
StatusTypenvarchar50
AttemptDatedatetime28
ImpersonatingUserIdint4FK
LoginAttemptIdnvarchar36PK
LoginSourcenvarchar50

Joins to (1)

Joined from (0)

None

Edit history links

None

Foreign keys without a stated target

  • ImpersonatingUserId: Marked as a foreign key by D2L, without a stated target data set.

Source