3582284984

Subjects
P " subjectjd	INTE
subject_name	VAR'

Lessons

_>t-

Class

P ’ classjd    INTEGER

c I ass_p rofi I e    VARCHAR2 (04

Class_PK (classjd)

P ' lesson_id F ’ subject_id F * class_id F ’ teacher id

INTEGER

INTEGER

INTEGER

INTEGER

Lessons_PK (lesson_id)

Warni ngs

Lessons_Subjects_FK (subject_id) Lessons_Class_FK (class_id) Lessons_Users_FK (teacher_id)

W

Attendance

P	" attendance_id	INTEGER
	datę	DATĘ
	present	CHAR (1)
F	' lessonjd	INTEGER
Attendance_PK (attendancejd)

Attendance_Lessons_FK (lessonj

warn_id

warn_content

datę

student_id teacher id

INTEGER

VARCHAF|

DATĘ

INTEGER

INTEGER

(Warnings_PK (warn_id)

Users

! student_id (student_id) i Warnings_Users_FK (teacher.

_2		\_
Grades
P	' grade_id	INTEGER
	grade	NUMBER
	datę	DATĘ
	description	VARCHAR2 (255)
F	" subjectjd	INTEGER
F	’ studentjd	INTEGER
F	" teacherjd	INTEGER
Grades_PK (gradejd)
	Grades_Subjects_FK (subjectjd)
	Grades_Users_FK (student_id)
	Grades_Users_FKv2 (teacherjd)

user_id

email

password_hash

role

firstname

lastname

phone_number

mother_firstname

father_firstname

mother_phone_number

father_phone_number

student class id

Users_PK (user_id)