Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-17004

Evaluate usage of idnumber fileld in Moodle database tables

    XMLWordPrintable

Details

    • Task
    • Resolution: Won't Fix
    • Minor
    • None
    • 2.0
    • Administration
    • None
    • MOODLE_20_STABLE

    Description

      While looking at MDL-15187 (assigning roles via CSV upload), I noticed that we are making an assumption that the idnumber field can be used as a unique record identifier for the user and course tables. I also noticed that we do not have an idnumber field for the course_category or groups tables which I would advocate for adding to Moodle 2.0 for increased interaction between Moodle and other student information systems (SISs) which may have unique internal identifiers for course categories and groups. I do not see a need for an idnumber field for the course_modules and block_instance tables. If the idnumber fields are assumed to be unique identifiers and are used as such for importing records, I wonder if we ought to enforce that either via an index or some checking similar to how we handle checking for duplicate usernames. I figured now is a good time to take a look at these issues and see if we wanted to add the idnumber field to course_categories and groups tables. Peace - Anthony

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              aborrow Anthony Borrow
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.