-- Таблица документа
CREATE TABLE [dbo].[Document] (
  [id] uniqueidentifier NOT NULL,
  [timestamp] timestamp NULL,
  [Name] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  [Description] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  PRIMARY KEY CLUSTERED ([id])
)

-- Табличная часть документа
CREATE TABLE [dbo].[TablePart] (
  [id] uniqueidentifier NOT NULL,
  [idOwner] uniqueidentifier NOT NULL, -- Ссылка на документ
  [Name] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  PRIMARY KEY CLUSTERED ([id]),
  CONSTRAINT [TablePart_fk] FOREIGN KEY ([idOwner]) 
  REFERENCES [dbo].[Document] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE CASCADE
)


-- Операции которые можно производить над документом
CREATE TABLE [dbo].[Operations] (
  [id] uniqueidentifier NOT NULL,
  [Name] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  CONSTRAINT [Operations_pk] PRIMARY KEY CLUSTERED ([id])
)

-- История изменения документов
CREATE TABLE [dbo].[DocumentHistory] (
  [id] uniqueidentifier NOT NULL,
  [documentId] uniqueidentifier NULL,
  [operationId] uniqueidentifier NULL,
  [operationTime] datetime NULL,
  [timestamp] timestamp NULL,
  [Name] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  [Description] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  PRIMARY KEY CLUSTERED ([id]),
  CONSTRAINT [DocumentHistory_fk] FOREIGN KEY ([documentId]) 
  REFERENCES [dbo].[Document] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE CASCADE,
  CONSTRAINT [DocumentHistory_fk2] FOREIGN KEY ([operationId]) 
  REFERENCES [dbo].[Operations] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION
)


-- Какая-то ещё таблица, на которую возможны ссылки "многое-ко-многим" из Документа
CREATE TABLE [dbo].[LinkTable] (
  [id] uniqueidentifier NOT NULL,
  [Name] nvarchar(max) COLLATE Cyrillic_General_CI_AS NULL,
  CONSTRAINT [LinkTable_pk] PRIMARY KEY CLUSTERED ([id])
)

-- Связь многие ко многим
CREATE TABLE [dbo].[MultLink] (
  [idDocument] uniqueidentifier NOT NULL,
  [idLink] uniqueidentifier NOT NULL,
  PRIMARY KEY CLUSTERED ([idDocument], [idLink]),
  CONSTRAINT [MultLink_fk] FOREIGN KEY ([idDocument]) 
  REFERENCES [dbo].[Document] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION,
  CONSTRAINT [MultLink_fk2] FOREIGN KEY ([idLink]) 
  REFERENCES [dbo].[LinkTable] ([id]) 
  ON UPDATE NO ACTION
  ON DELETE NO ACTION
)