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!