Tag Info

New answers tagged


Have a single User table. Then if anything changes, such as a phone number, it changes for the lender and the borrower simultaneously without awkward reconciliation between the two tables. Your Loan table will look something like this Loan ---- LenderID -- A foreign key pointing to User BorrowerID -- Also a foreign key pointing to User ItemID ...

Top 50 recent answers are included