I have a quick question about ER diagram. My question is would a sender and receiver be a recursive relation?
Like if I want to send money to someone in a transaction via PayPal.
Asked
Active
Viewed 48 times
0
-
Not unless the receiver turns around and gives out that money to one or more others. – Chris Maurer Oct 13 '22 at 19:33
-
A recursive *relationship* (a relation is a table) happens when one column of a table makes a reference to the same table. – The Impaler Oct 13 '22 at 20:52
1 Answers
0
If both are stored in the same table, lets say customer and the transaction references both the sender and receiver, then yes.
In this circumstance, transaction would function as an intermediate table for customer m:m customer, creating a circular or recursive relation.
StackOverflower
- 526
- 3
- 14
-
You could also make this a recursive relation without a `transaction` table. – StackOverflower Oct 13 '22 at 19:48