Displaying 1 result from an estimated 1 matches for "owee_user_id".
Did you mean:
owed_user_id
2006 May 30
1
Having two columns in a model point to another table
...have a "users" table in my application, and I wanted to set up a "debts"
table, to store debts between users.
My current table structure for "debts" is
CREATE TABLE debts (
id int not null auto_increment,
owed_user_id int not null, # User that is owed the money
owee_user_id int not null, # User that owes money to the owed_user
reason text not null, # Reason for debt
amount decimal(10,2) not null,
primary key(id)
);
In this case, both owed_user_id and owee_user_id point to a different user
in the Users table. How can I represent this in my model clas...