Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Globalstorage system tables #150

Open
tshemsedinov opened this issue Aug 16, 2018 · 0 comments
Open

Globalstorage system tables #150

tshemsedinov opened this issue Aug 16, 2018 · 0 comments

Comments

@tshemsedinov
Copy link
Member

tshemsedinov commented Aug 16, 2018

Storage provider should work with all system tables and do hide implementation from all other modules. So generating Id should be part of storage provider because it can't access database at table-level. All other modules can access database schema level (can see only categories) and can't access tables.

Table Name CRUD Description Context
Action CRUD Action to be applied to categories System-wide replicated
Catalog CRUD Hierarchy to group entities System-wide replicated
Category CRU- Category extracted from schemas System-wide replicated
Config CRUD Globalstorage configuration System-wide replicated
File CRUD File storage records Server local table
Identifier CRU- Id index and pre-generated Ids Global sharding
Log CR-- Globalstorage access log Server local table
Permission CRUD Permissions given to certain role System-wide replicated
Role CRUD Roles (named groups of permissions) System-wide replicated
Schema CR-- Database schemas history System-wide replicated
Session CRUD User sessions on this server Server local table
Subdivision CRU- Organizational hierarchy System-wide replicated
User CRU- User accounts and auth data Global sharding
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant