This is a sketch which represents an issue i met in work with more complicated DB project. The real project - is a DB for goods purchasing, collection & delivery...

• This reply was modified 3 years, 6 months ago by  sameuser. Reason: details included

Improved 🙂 But the question still remains

Have 1 money processing table (payment) with 2 FK , but 2 independent spending channels.

Is a way to normalize? Make 2 payment tables? Triggers?...

Thank you for reply, guys! Didn't expected to get it so fast (because not much of topics here, in this sub-forum). I thought it has been abandoned 😀

The sketch above...