I am currently in the initial stages of developing a node.js/react application that will assist users in managing restaurant menu data. I am contemplating on how to properly organize user accounts, restaurant brand accounts, and data ownership.
Individual users should be able to log in and authenticate themselves.
The brand account should be controlled by users, allowing multiple users to access the brand account data.
Data ownership should belong to the brand account, ensuring that only authorized users associated with that brand can view the data.
What are some best practices for establishing these relationships within the schema?
My idea is to have models such as User, Account, and various other data models. For instance, let's take MenuItems:
Would this simplified example be the correct approach?:
User {
email: String,
password: String
}
Account {
account_name: String,
users: [User1, User2 ...] // Embedded documents or references
}
MenuItems {
title: String,
description: String,
account: [Account] // Embedded document or reference
}