Courses

Description:

This database contains courses created within the institution through the Clinical Mind AI platform. Each row corresponds to one course and includes information about its creation, description, instructional leadership, and associated learners and simulated patients.

Variables:

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

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

createdBy — Unique identifier of the user who originally created the course. To obtain the associated user details (e.g., name or role), this variable must be joined with the Users database.

updatedBy — Unique identifier of the user who last updated the course record. To obtain the associated user details (e.g., name or role), this variable must be joined with the Users database

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

name — Title of the course as displayed to students and instructors. This field is entered by the creator of the course.

description — Brief textual summary outlining the course’s focus, objectives, or structure. This information is written by the creator of the course.

timePeriod — Academic term or time range during which the course takes place (e.g., “Fall 2025”). This field is specified by the creator of the course.

courseColor — Visual identifier assigned to the course within the user interface to aid recognition. The color is selected by the creator of the course.

programOfCourse — Academic or training program to which the course belongs (e.g., MD Program, Nursing, Residency). This information is indicated by the creator of the course.

yearOfMedicalStudent — Targeted learner level of the course (e.g., first-year, second-year). This information is indicated by the creator of the course.

isActive — Boolean value indicating whether the course is currently active and accessible to users (TRUE) or archived (FALSE).

institutionId — Unique identifier linking the course to the parent institution within the database.

mainInstructor — Name of the primary instructor responsible for the course.

mainInstructorId — Unique system identifier for the main instructor.

institution — Full name of the institution offering the course.

country — Country in which the institution is located.

noOfInstructors — Number of instructors associated with the course.

noOfStudents — Number of students enrolled in the course.

noOfPatients — Number of AI-simulated patients or clinical cases linked to the course.

patientNames — List of names or titles of patients/cases included within the course.