NOVA

Tables (4)

ARTICLES

  • ArticleId — INT
  • Title — NVARCHAR(255) — NOT NULL
  • BodyText — NVARCHAR(MAX)
  • IncludeBodyInRag — BIT — NOT NULL
  • Status — CHAR(1) — NOT NULL
  • CreatedAt — DATETIME — NOT NULL

ARTICLE_PDFS

  • ArticlePdfId — INT
  • ArticleId — INT — Foreign key → ARTICLES.ArticleId — NOT NULL
  • FilePath — NVARCHAR(500) — NOT NULL
  • FileName — NVARCHAR(255) — NOT NULL
  • PageCount — INT — NOT NULL
  • CreatedAt — DATETIME — NOT NULL

BATCH_JOBS

  • JobId — INT
  • JobType — VARCHAR(20) — NOT NULL
  • TargetType — VARCHAR(20) — NOT NULL
  • TargetId — INT — Foreign key → ARTICLES.ArticleId — NOT NULL
  • Status — VARCHAR(20) — NOT NULL
  • CreatedAt — DATETIME — NOT NULL

CHUNKS

  • ChunkId — INT
  • ArticleId — INT — Foreign key → ARTICLES.ArticleId — NOT NULL
  • SourceType — VARCHAR(20) — NOT NULL
  • SourcePdfId — INT — Foreign key → ARTICLE_PDFS.ArticlePdfId
  • PageStart — INT
  • PageEnd — INT
  • Content — NVARCHAR(MAX) — NOT NULL
  • Status — CHAR(1) — NOT NULL