New answers tagged physical-design
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