Auth with multiple tables for storing data

I am trying to create a system that has three user types (admin, business, and personal) each of which that can log in via the standard /login Auth screen.

I have tampered around with using the Users table to hold an Id, email address, account_type and password where I then have secondary tables such as admins and businesses to hold the rest of their information (connecting via a user_id foreign key).

Basically, my question is, what is the best way for me to handle this process and are there any suggestions as to how I can join the data so that I am able to use Auth()->user()->('dataName') to access the information from the relevant table for only the Authenticated user.

If there are any further questions needed to help understand this issue, please do ask :)

burlresearch

8 years ago

Best Answer

Level 40

if your user can be several of these, at once, the you are definitely in the space of well documented many:many:

http://laravel.com/docs/5.6/eloquent-relationships#updating-many-to-many-relationships

If the user can be just 1, then you could have a User:

$table->enum('type', [admin, business, personal]);

in your migration and then just: switch(user->type){...}

Please or to participate in this conversation.