I have 5 tables retailers, doctors, softwareproviders, members and contactpersons
. contactpersons
table associated with other 4 tables using type and refid
.
retailers
id | name | contactno | mem_type |
---|---|---|---|
2 | karthik | 855550 | 1 |
members
id | name | contactno |
---|---|---|
6 | naveen | 855550 |
contactpersons
id | type | refid | name |
---|---|---|---|
1 | 1 | 2 | ruban |
1 | 2 | 6 | aron |
type 1 - retailers, 2 - members, 3 - doctors, 4 - softwareproviders
In contactpersons model how to make hasone relationship
with other tables
public function retailersinfo(){
return $this->hasOne('App\Retailers','id','refid');
}
we need to add type condition (where condition =1)
.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire