Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each article-tag association, auto-incrementing integer |
||||
| ArticleID | int | 4 | null |
|
|
Article reference - Foreign key linking to Article.ID for the article being tagged (required field) |
|||||
| TagID | int | 4 | null |
|
|
Tag reference - Foreign key linking to Tag.TagId for the tag being applied to the article (required field) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ArticleTag | Primary key | Asc | ID |