idnumber column

idnumber column

- Angel Simón の投稿
返信数: 4

Hello everyone,

 

There are columns called "idnumber" in mdl_groups and in mdl_course. Both are nvarchar(100). I would like to know what are these columns for.

Is it safe to put custom data in these columns? Does Moodle add information to these columns in some point?

 

Thanks in advance.

Angel Simón への返信

Re: idnumber column

- Davo Smith の投稿
画像 Core developers 画像 Particularly helpful Moodlers 画像 Peer reviewers 画像 Plugin developers

The idnumber fields (found throughout Moodle) have no specific pre-set meaning, but they are often used for matching up users + courses with either external systems or, for example, CSV import.

You should be safe to use them yourself (but, unless you lock them down, they are editable via the user profile / course settings pages).


Angel Simón への返信

Re: idnumber column

- tim st.clair の投稿
画像 Plugin developers

Some browser (I'm looking at you, Chrome) think that it's fun to stick values in this field for you. Autocompletion type data such as any usernames you might have saved for your moodle site! I'm constantly clearing out the idnumber field before I save. Just something to watch for.