With the introduction of mulit-tenancy, some environment variables will have to be come tenanted. To represent the tenancy of these variables, the tenantSettings table will hold them. The unique id of rows on this table will not be generated, but will instead be a concatenation of the tenantId it is for and the name of the value it represents. For example:

// tenant id is colon-separated from the key of the variable the row represents
id: "1234-1234-1234:ExchangeRatesUrl"

The tenant settings table schema should look like this:

enum TenantSetting {
  ExchangeRatesUrl
  WebhookUrl
}

TenantSettings {
  id: string // Uses the pattern in above code snippet
  key: TenantSetting
  value: string
}

• Create migration for tenantSettings table
• Create model.ts file for tenantSettings table

Prerequisites

• [Multi-Tenant] backend tenants table #3103