Table "insightsfactory"."content_templates" {
  "id" bigint [not null, increment, note: 'The id of the content template']
  "name" nvarchar(128) [not null, note: 'The human-readable name of the content template']
  "content_type" nvarchar(128) [not null, note: 'Human readable description of a type of the content, e.g. Text with media. Can be used to group content templates.']
  "dispatcher_template" nvarchar(max) [not null, note: 'A JSON with a template which instructs how to render the content in a format that can be understood by the dispatcher']
  "bank_admin_data_model" nvarchar(max) [not null, note: 'JSON containing data model with fields that can be configured by the Bank Admin. Can also contain example values.s']
  "bank_admin_template" nvarchar(max) [not null, note: 'Data which should instruct Bank Admin UI on how to display input forms for the Template and how to display a preview']
  "created_utc" datetime2(7) [not null, default: `getutcdate()`, note: 'The date of entity creation (utc)']

Indexes {
  id [pk]
}
  Note: 'Table containing content templates that can be used to create insight definition'
}

Table "insightsfactory"."channels" {
  "id" nvarchar(128) [not null, note: 'The id of the channel']
  "name" nvarchar(128) [not null, note: 'Human-readable name of the channel']
  "type" nvarchar(32) [not null, note: 'Human-readable type of the channel, allowed values: Push, Pull']
  "created_utc" datetime2(7) [not null, default: `getutcdate()`, note: 'The date of entity creation (utc)']

Indexes {
  id [pk]
}
  Note: 'Table containing channels of insight definitions'
}

Table "insightsfactory"."channel_to_content_template" {
  "channel_id" nvarchar(128) [not null]
  "content_template_id" bigint [not null]

Indexes {
  (channel_id, content_template_id) [pk]
}
}


Ref: "insightsfactory"."channel_to_content_template"."channel_id" > "insightsfactory"."channels"."id"

Ref: "insightsfactory"."channel_to_content_template"."content_template_id" > "insightsfactory"."content_templates"."id"