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