text: ﻿CREATE TABLE [IQ].[Notification]
  (
      [Id] UNIQUEIDENTIFIER NOT NULL CONSTRAINT [DF_Notification_Id] DEFAULT (NEWSEQUENTIALID()),
  
      [Type] NVARCHAR(256) NOT NULL,
      [Message] NVARCHAR(MAX) NULL,
  
      [UserName] NVARCHAR(256) NOT NULL,
      [Read] DATETIMEOFFSET NULL,
  
      [TenantId] UNIQUEIDENTIFIER NOT NULL,
  
      [Created] DATETIMEOFFSET NOT NULL CONSTRAINT [DF_Notification_Created] DEFAULT (SYSUTCDATETIME()),
      [CreatedBy] NVARCHAR(100) NULL,
      [Updated] DATETIMEOFFSET NOT NULL CONSTRAINT [DF_Notification_Updated] DEFAULT (SYSUTCDATETIME()),
      [UpdatedBy] NVARCHAR(100) NULL,
      [RowVersion] ROWVERSION NOT NULL,
  
      CONSTRAINT [PK_Notification] PRIMARY KEY NONCLUSTERED ([Id] ASC),
      CONSTRAINT [FK_Notification_Tenant_TenantId] FOREIGN KEY ([TenantId]) REFERENCES [IQ].[Tenant]([Id]),
  )
  
  GO
  CREATE INDEX [IX_Notification_TenantId]
      ON [IQ].[Notification] ([TenantId])
  
  GO
  CREATE INDEX [IX_Notification_UserName]
      ON [IQ].[Notification] ([UserName])
  
  