...
Modules themselves are not specific to any particular academic year, they in effect last forever. A record in the modules table holds information such as module code, title, school, etc.
Note: The modules_staff and modules_student linking tables join using the primary key ID of the modules table. Do not confuse this number with the module code which is sometimes referred to as ID (e.g. A11CLS).
...
Staff are placed on modules to form editing teams. The table modules_staff is used as a linking table between staff in the users table and module IDs in the modules table.
...