Users

Description:

This database contains all users affiliated with the institution (students and instructors). Each row corresponds to one user and includes identifiers, contact details, role information, and account status.

Variables:

createdAt — Date and time when the user record was first created on the platform.

updatedAt — Date and time of the most recent update to the user record.

id — Unique system-generated identifier for the user, serving as the primary key for data integration and cross-referencing.

firstName — Given name of the user as recorded in the platform.

lastName — Family name (surname) of the user as recorded in the platform.

email — Primary email address associated with the user account.

profilePic — URL to the user’s profile image (may be empty if not provided).

isActive — Boolean value indicating whether the user account is active and permitted to access the platform within this institution (TRUE) or archived and inactive (FALSE).

role — Platform role assigned to the user (e.g., Student, Instructor), used to determine permissions and access.

institutionId — Unique identifier linking the user to the parent institution.

deletedAt — Date and time when the account was deleted (empty if the account has not been deleted).

memberStatus — Platform-defined membership state within the institution. Possible values are pending, indicating that the user was added to the institution but has not yet activated their account, and member, indicating that the user has activated their account and is an active participant within the institution.

institution — Full name of the institution associated with the user.

country — Country in which the associated institution is located.