雄辩的模型继承 - 多表设计

Question

Assume we have two db tables: posts and threads:

threads
   id - integer
   title - string
posts
   id - integer
   body - text
   created_at - timestamp
   thread_id - integer (fk)

and two Eloquent models:

class Post extends Model { 

   public function thread()
   {
       return $this->hasOne('App\Thread');
   }  
}


class Thread extends Post { 

   protected $table = 'threads';

   public function post()
   {
      return $this->belongsTo('App\Post');
   } 
}

What I want to achieve is Thread object having id, title, body, created_at attributes, while Post object having id, body, created_at attributes.

Yet, I still get error:

Column not found: 1054 Unknown column 'body' in 'field list'

which is MySQL error that basically means that Laravel's trying to look up the body column in the threads table. However, it is stored in the posts table.

Answer 1

What you are trying to do is unnecessary with Eloquent.

The data that is retreived from the database iss storred in the $attributes property.

So unless you are sharing any behaviour you don't need to inherit from anything other than Model.