Hello, I want to create a discussion group system, for that I saw that you need a database per discussion. I want to make sure that each user can create his group and therefore his database. Can we create a database with an action?
What do you mean by “database per discussion”? When you say one’s group, do you mean like a group chat? A structure like this would suffice.
Groups
| RowID | Group Name | Owner ID |
|---|---|---|
| G001 | Test A | O001 |
| G002 | Test B | O002 |
Group Messages
| RowID | Group ID | Message Owner ID | Message | Timestamp |
|---|---|---|---|---|
| M001 | G001 | O001 | Hello everyone! | 2024-06-23T23:30:00Z |
Then create a multiple relation from the Groups table to the Group Messages table, linking the rowID to Group Messages > Group ID.
1 Like