Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each article history record, auto-incrementing integer |
||||
| ArticleId | int | 4 | null |
|
|
Article reference - Foreign key linking to Article.ID for the article being versioned (required field) |
|||||
| ArticleContent | nvarchar | 1073741823 | √ | null |
|
|
Historical content - Complete article content at the time of this version for rollback and comparison |
||||
| CreatedDate | datetime | 16,3 | null |
|
|
Version timestamp - When this version was created for chronological version tracking (required field) |
|||||
| CreatedBy | int | 4 | null |
|
|
Version author - User ID who created this version for accountability and editorial workflow (required field) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ArticleHistory | Primary key | Asc | Id |