I'm building the core tables for a small, cloud-based enterprise app.
Is this data model suitable for a role based authentication system (flat hierarchy of permissions) that allows users to work for multiple companies?
As pointed out by Joel Brown, I didn't state my exact requirements. Here there are:
- This app is for a startup and specs change quite often, so the model should be flexible and expandable. The underlying idea is to create enterprise software (think ERP).
- One User can work for multiple Organizations with multiple Roles & Permissions (imagine a chain of hotels, each hotel is an Organization, and the top management of the chain has access to various Organizations)
- Permissions can be flat (ie no hierarchy).