As I am doing a QR Code attendance taking system for our university.

Could please guide me on the tables below if i am doing it wrong as well as any recommendations?

Currently my tables:

user (staff and student are in 1 same table)
Intake (Each student will be enroll in 1 intake)
Module (Each intake will have 6-7 modules,Each module will have many students,same module can be use by other intake)
Class (Each class held with attendance)

User Table:
id (pk)
email (login criteria)
password
name
module_id (fk) (NULL)
intake_id (fk) (NULL)
user_type (student/lecturer)

Intake Table:
intake_id
intake_name

Module Table:
module_id
module_name
intake_id (fk)

Class Table (attendance for each class):
class_id
class_date
intake_id(FK)
module_id(FK)
user_email (FK) (students will use their email to identify each others)
attendance (0 = Absent/ 1 = Present / 2 = Late)

note:

Intake 1:M Modules
Intake 1:M Students
Module M:N Students
Students M:N Classes

Any recommendations on the design of database? Sincerely Thank you!