5e

Instructors

PK

PK,FK1

user id

account number

Theoreticaljessons
PK,FK2	id
FK2 FK1	coursejd instructorid subject datę hours room

Payments
PK	id
FK1 FK2	amount datę studentjd accepted_by status due_date

Payment_status
PK	id
	description

Driving_lesson
PK	id
FK2	studentjd
FK1	instructorjd start time end_time datę
FK4	coursejd
FK5	status distance
FK3	carjd

Courses
PK	id
FK1	start_date type practical_training theoretical_training

Categories
PK	cateeorv codę
	categoryname

student_course
PK,FK2 PK,FK1	course id student id
	medical_certificate certificate_number end_date

Status
PK	id
	name

FK2

FK1

Users

jd

username

email

first_name

last_name

mobile

phone

pesel

birth_date

nationality

homeAddress

mailingAddress

pass_sha256

register_date

comments
PK	comment id
FK1 FK2	placejd comment author datę grade

student_categories
PK,FK1 PK,FK2	student id
	category codę

lnteresting_places
PK	place id
FK1	lattitude longitude type description difficulty accepted city author datę

Students
PK,FK1	user id

Adresses
PK	id
	Street housenumber flatnumber town postal_code post_office

Types
PK	type id
	name description