I am building a data model for a social networking site and lost of how to model Users and Accounts.
1) User signsup and creates an Account. So we assign the User a user Id like on most social websites we see which is same profile ID. Now is that the account ID too? OR is there a separate account ID also hidden? If user can have multiple profiles, then user ID is seperate from account ID which is separate from each profile ID?
2) We assume 1 user has only 1 account. But when a user is editing his account or let's say an admin edits a user's account, then the User is editing an account, so two separate IDs required to model this?
3) What is the life of a user and account object? If user closes his account, that means both the user and account object get killed?
4) And who holds the user profile details, user settings, privacy, friends, etc? The user object or Account object, and which object is superior?
5) There are system objects such as photo, video, etc which a user can create/admin, so are those owned by the user or the account object?
6) What exactly makes an object? Say we have status updates, comments, profile details. Are these 3 objects? Or all considered 1 type of object and just 3 categories?