Support the ongoing development of Laravel.io →
tomwelch
posted 9 years ago
Eloquent
Last updated 2 years ago.
0
szegad
replied 9 years ago
Solution

Hi, "By the SQL book" imho:

  • Users table - where you store common fields
  • Teachers table - for teacher related fields. foreign key to users.
  • Students table - for student related fields. foreign key to users.

If you add more profiles you can find yourself in a situation when one users can have more then one profile (eg. course administrator profile).

This model can handle it.

Last updated 2 years ago.
0
tomwelch
replied 9 years ago

Hi szegad

Thanks. Sounds easy put like that :)

Last updated 2 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

tomwelch tomwelch Joined 11 Dec 2013

Moderators

We'd like to thank these amazing companies for supporting us

Eventy
Fathom
Forge
Envoyer
Beyond Code
Skynet Technologies
BairesDev
Remotely Works
Dotcom-monitor
N-iX

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X Twitter GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2024 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise