Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each article, auto-incrementing integer used for article references |
|||||||
| Name | nvarchar | 400 | √ | null |
|
|
Article title - Display title of the article for navigation and search results |
|||||||
| Description | nvarchar | 1000 | √ | null |
|
|
Article summary - Brief description or excerpt of article content for previews and search |
|||||||
| CoverMedia | nvarchar | 400 | √ | null |
|
|
Cover image - URL or path to featured image or media for article presentation |
|||||||
| ContentArticle | nvarchar | 1073741823 | √ | null |
|
|
Article body - Rich HTML content of the article including text, images, and formatting |
|||||||
| CreateBy | int | 4 | √ | null |
|
|
Author user ID - Reference to user who created the article for attribution and permissions |
|||||||
| UpdateBy | int | 4 | √ | null |
|
|
Last editor user ID - Reference to user who made the most recent update for audit trail |
|||||||
| CreateDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the article was first created for chronological organization |
|||||||
| UpdateDate | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - Most recent update for freshness tracking and notifications |
|||||||
| CreateByCompanyId | int | 4 | √ | null |
|
|
Company association - Reference to company that created the article for multi-tenant content management |
|||||||
| IsDelete | bit | 1 | √ | null |
|
|
Soft delete flag - Boolean indicating if article is logically deleted but retained for audit purposes |
|||||||
| IsPublic | bit | 1 | √ | null |
|
|
Public visibility - Boolean controlling whether article is visible to customers or internal only |
|||||||
| PublishDate | datetime | 16,3 | √ | null |
|
|
Publication timestamp - When the article was officially published for public access |
|||||||
| IsShowPublishDateOnCover | bit | 1 | √ | null |
|
|
Date display setting - Boolean controlling whether publish date appears on article cover |
|||||||
| Link | nvarchar | 4000 | √ | null |
|
|
External link - URL to external resource or related content for additional information |
|||||||
| CreateByName | nvarchar | 400 | √ | null |
|
|
Author display name - Human-readable name of article creator for attribution |
|||||||
| IsMustRead | bit | 1 | ((0)) |
|
|
Required reading flag - Boolean indicating if article is mandatory reading for certain user groups |
||||||||
| IsShowFirst | bit | 1 | √ | null |
|
|
Priority display - Boolean flag for featuring article prominently in lists and search results |
|||||||
| FileName | varchar | 255 | √ | null |
|
|
Attached file - Name of file attachment associated with the article for downloads |
|||||||
| TicketId | int | 4 | √ | null |
|
|
Related ticket - Optional reference to ticket that prompted article creation for solution documentation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Article | Primary key | Asc | ID |