I’m writing db migrations. I’m trying to decide which column to select as a foreign key from two candidates, sender_id and recipient_id, which will map to a user table, but which one is the better choice? Does it matter? Should I make 2 foreign keys here? Any input on better design practice would be appreciated.
public function safeUp()
'id' => 'pk',
'sender_id' => 'int(11) NOT NULL',
'recipient_id' => 'int(11) NOT NULL',
'message' => 'varchar(8000) NOT NULL',
public function safeDown()