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
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?