- Links the students with their courses.
CREATE TABLE IF NOT EXISTS /*_*/ep_users_per_course (
upc_user_id INT unsigned NOT NULL, -- Foreign key on ep_user.user_id upc_course_id INT unsigned NOT NULL, -- Foreign key on ep_courses.course_id upc_role TINYINT unsigned NOT NULL, -- The role the user has for the course upc_time varbinary(14) NOT NULL -- Time at which the link was made
ep_user.user_id doesn't exist. Is this actually the core user table user_id column?