Database schema

[manuelpereiradiconium]

Proposed Database Schema

Here is the initial diagram for the database schema given current information:

I have some doubts mainly from the integrations relations.
Please give me your inputs.

[teixeped]

I think it's a good starting point 👍
With MongoDB I think it would be useful to also define the schema as JSON as it is different than SQL.

[manuelpereiradiconium]

{
  "users": {
    "user_id": "ObjectId",
    "email": "string",
    "password": "string",
    "emails": "Email[]",
    "groups": "Group[]",
    "templates": "Template[]",
    "api_keys": "ApiKey[]"
  },
  "groups": {
    "group_id": "ObjectId",
    "name": "string",
    "recipients": "Recipient[]"
  },
  "api_keys": {
    "api_key_id": "ObjectId",
    "permission": "string",
    "name": "string",
    "created_at": "Date",
    "domain_id": "string",
    "token": "string"
  },
  "templates": {
    "template_id": "ObjectId",
    "name": "string",
    "subject": "string",
    "content": "string"
  },
  "integrations": {
    "integration_id": "ObjectId",
    "smtp_port": "string",
    "host": "string",
    "config_key": "string"
  },
  "emails": {
    "email_id": "ObjectId",
    "subject": "string",
    "content": "string",
    "recipients": "string[]",
    "cc": "string[]",
    "bcc": "string[]"
  },
  "recipients": {
    "recipient_id": "ObjectId",
    "email": "string"
  }
}

Something like this? Should I add it to the repo also to document the model in the README of the server?