Hi, I am working on Music database where we have multiple order of users of our portal. Different category of users is having some common attributes but some different attributes based on their registration. This becomes a hierarchy pattern. I am attaching one sample hierarchy pattern of User Module which is somehow part of my current data modeling.
*There are few conditions:-* *1) email id should be unique. i.e If some user registered with one email id then that particular user can't able to register as another user. * *2) Some type of users having 20-30 columns as in their registration. such as company,address,email,first_name,join_date etc..* *Query pattern is like:-* *1) select user by email* Please suggest me how to do data modeling for these type of hierarchy data. Should I create a seperate table for the seperate type of users or should I go with single user table? As we have unique email id condition, so should I go with email id as a primary key or user_id UUID will be the best choice. Best regards, Nandan Priyadarshi
--------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org