DB base setup

[mledl]

The aim of this issue is to come up and discuss a base RDBMs schema that supports the following requirements:

• Support for multiple users
• Support for multiple projects
• User permissions on project level
• Store translations as key/value pair (key should be fully qualified name?)
• A project needs to consist of various translations across different languages.
• Different language standards need to be supported (e.g. different language code standards, also with localization)
• Support fallback language

The following image shows an example ER diagram depicting what such DB schema could look like.

Let's discuss if this is a good starting point or some adjustments to this proposal would make more sense. For example, not storing languages as individual table.

[benjaminstrasser]

I like the setup!
some additional thoughts and I would love some input.

add user groups

users can be added to groups. groups can be assigned to projects. individual users can still be added to projects.

permissions

add read/write permissions to the user groups/users associations with an project

[mledl]

I think having user groups with certain permissions is a good feature as well.
I would see this as an add-on once we are set with the per user permissions.