Displaying 1 result from an estimated 1 matches for "owed_user_id".
2006 May 30
1
Having two columns in a model point to another table
...if someone could
point me in the right direction on this.
I 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...