dqybeh2884 2014-09-27 12:26
浏览 24

Laravel 4在数据透视表上的关系

Schema for Professor-Teaching-Subject

Above is the current schema that is on my mind.

Each professor (faculty), will teach more than one subjects. The faculties_has_subjects table is the pivot table linking the two. On top of that, the pivot relation should have an attribute to store which semester it was taught in.

Sample data for the semesters table is:

+----+------------------+
| id | name             | 
+----+------------------+
| 1  | Fall 2010-2011   |
+----+------------------+
| 2  | Winter 2010-2011 |
+----+------------------+
| 3  | Fall 2011-2012   | 
+----+------------------+
| 4  | Winter 2011-2012 | 
+----+------------------+

How do I use laravel's Eloquent ORM to extract the following details for a particular faculty.

  • Subjects Taught
  • Semester in which each subject was taught

I could do it easily if instead of semesters_id, there was semester_name directly. But since this is a foreign key in the pivot table itself, how do I use Eloquent ORM with it?

Thanks!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 基于卷积神经网络的声纹识别
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 stm32开发clion时遇到的编译问题