STRUCTURE:
Student: First name, last name ,date of birth, image.
class:name, section
course:name,description
grades:student,course,class
So i'm struggling to create this database in symfony with doctrine ORM , if someone can help with the entities(especially the foreign keys) it will be greatly appreciated.
Thank you.
I suggest you to use the maker component to create your entities (composer require maker --dev). Also, the integration of Doctrine with Symfony is described here.
FIRST
bin/console make:entity Student # then just answer the question
bin/console make:entity ClassRoom # or anything different than "Class" as it looks like the "class" keyword
bin/console make:entity Course
bin/console make:entity Grades
When creating the Grades entity, choose the type ManyToOne (or OneToOne, can't guess with your description) for your three properties student, course and classRoom.
More information about association mapping here.
NEXT
Then open your entities and enhance your @Column and @ManyToOne annotations.
Considers adding a @UniqueConstraint on the Grade entity wrapping your three properties if needed.
Considers adding a @JoinColumn constraint under your three Grade properties.
FINALLY
bin/console make:migration
bin/console doctrine:migrations:migrate
