When I store a business in the database, what information does it require?
Name (Self-explanatory. Are names unique or can multiple businesses have different names? It would be no problem having same names as far as database is concerned, as everything is dealt with through ids.)
Names don't need to be unique.
Users (A list of all users in the business. This actually wont be stored here; instead each user has a business attached to it and i'll query all users filter_by business id matches business)
email? which email is associated with the business? the owners email? multiple emails?
Owners email
creator/owner (do you want the database to store who created the business or only who currently has what permissions?) Only current owner
type of business (is this chosen from a list or can users type anything they want here?)
Type anything they want. I'm not exactly sure what the purpose specifying this is but maybe I just haven't found a use for it myself.
appointments (a list of all appointments for the business. these will be like users and not actually stored in this database but can be queried easily)
contact information (what fields do you want here? and which fields are required and which are optional?) Business Name, Address, Phone No, Email (all required), Website, Social Media Handles, Logo
uploads? what types of files can your business upload? images, etc.? images and .pdf
When I store a business in the database, what information does it require?
Name (Self-explanatory. Are names unique or can multiple businesses have different names? It would be no problem having same names as far as database is concerned, as everything is dealt with through ids.) Names don't need to be unique.
Users (A list of all users in the business. This actually wont be stored here; instead each user has a business attached to it and i'll query all users filter_by business id matches business)
email? which email is associated with the business? the owners email? multiple emails? Owners email
creator/owner (do you want the database to store who created the business or only who currently has what permissions?) Only current owner
type of business (is this chosen from a list or can users type anything they want here?) Type anything they want. I'm not exactly sure what the purpose specifying this is but maybe I just haven't found a use for it myself.
appointments (a list of all appointments for the business. these will be like users and not actually stored in this database but can be queried easily)
contact information (what fields do you want here? and which fields are required and which are optional?) Business Name, Address, Phone No, Email (all required), Website, Social Media Handles, Logo
uploads? what types of files can your business upload? images, etc.? images and .pdf