I'm using Laravel 5.3. I've 4 tables. Default Users
table. Departments
, Position
, Employees
tables.
Users
table has ID | Email | Password
Departments
table has ID | Department | User_Id
- Here User_Id
is foreign key comes from Users
table's ID
Positions
table has ID | Position | Department_Id
- Here Department_Id
is foreign key comes from Departments
table's ID
Employees
table has ID | Employee | Position_Id
- Here Position_Id
is foreign key comes from Positions
table's ID
User can have multiple Departments
. Departments
can have multiple Positions
, Positions
can have multiple Employees
. So, if user is different, how can i retrieve all data from all 4 tables which that user had created?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire