> 关联查询中关系有`包含 (Has One)`和`属于 (Belongs to)`的区别，两者属于正反方向关系 > 本章主要介绍`属于关系 (Belongs to)` [TOC] ## 属于 (BELONG TO) ~~~ // `User`属于`Profile`, `ProfileID`为外键 type User struct { gorm.Model Profile Profile ProfileID int } type Profile struct { gorm.Model Name string } // SELECT * FROM profiles WHERE id = 111; // 111是user的外键ProfileID db.Model(&user).Related(&profile) ~~~ ## 指定外键 ~~~ type Profile struct { gorm.Model Name string } type User struct { gorm.Model Profile Profile `gorm:"ForeignKey:ProfileRefer"` // 使用ProfileRefer作为外键 ProfileRefer int } ~~~ ## 指定外键和关联外键 ~~~ type Profile struct { gorm.Model Refer string Name string } type User struct { gorm.Model Profile Profile `gorm:"ForeignKey:ProfileID;AssociationForeignKey:Refer"` ProfileID int } ~~~