I do know it’s a frequent paradigm to separate tables when constructing a Consumer profile. For instance, having a consumer desk, and one other desk referred to as user_profile with a overseas key to the consumer desk.

My understanding is that the consumer desk is healthier for delicate consumer account knowledge or authentication knowledge, resembling e mail, password, consumer kind and so on. The Profile desk may have further knowledge of that consumer like first identify, final identify, date of delivery and extra.

However, what about different knowledge that may be associated to the consumer, and may also be modeled with a desk. Some examples might be Funds and Transactions. My first guess is to hyperlink these to the profile desk and that manner I haven’t got to make any joins simply to have Transactions and the identify of Consumer collectively (which the consumer desk doesn’t have). Linking to the profile, I’ve the consumer data and the Transactions. However then, when is it helpful to hyperlink to the consumer desk? What are the frequent paradigms?

Thanks prematurely!