There are some issues with some fieldnames:

"date" I think is reserved
"course" should be "courseid" (old Moodle tables that use "course" are old mistakes that we should not replicate)
"role" should be "roleid" etc (anything that's a foreign table id should have "id")