done some work at U of C integrating class lists and grades between
WeBWorK and blackboard, which includes some manual writing to the
webwork database, and we came across an interesting issue. Due to some
unexpected situations one of our scripts wrote the same user into the
database multiple times. Thus in several tables we have the same
user_id appearing multiple times. As the user_id column is intended to
be a unique identifier of a student within a course, it would make
sense that this column be either a primary key or a unique index,
whereas by default the key type for this column is set to 'MUL',
allowing multiple instances of the same value.
Has anyone experimented with changing this value to either 'UNI' or
'PRI', or can anyone foresee any undesired side effects in doing so?
<| Post or View Comments |>