i'm sitting little headache problem right now.
i have 2 entities payment order , account
payment order pk - id fk - debited acc fk - credited acc account pk - accountnumber i struggle find logic when credited account not account financial institution. can not foreign key anymore since account not contained within account table.
have guys idea workaround?
edit
question : have change constraint on credited acc nothing ? or can keep way is?
i recommend make account table contain more accountnumber column.
if toy example, add boolean indicate whether account number internal versus external. if going operational system, consider adding financial_institution table , use primary key foreign key in accountnumber table.
Comments
Post a Comment