Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | nvarchar | 400 | null |
|
|
Primary key - Unique identifier for each URL reference (required field) |
||
| ParentID | int | 4 | √ | null |
|
|
Parent entity ID - Reference to the parent entity this URL is associated with |
|
| ParentType | nvarchar | 100 | √ | null |
|
|
Parent entity type - Type classification of the parent entity (e.g., Ticket, Article, App) |
|
| Path | nvarchar | 400 | √ | null |
|
|
URL path - The actual URL or path being referenced |
|
| CreateBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this URL reference |
|
| CreateDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this URL reference was first created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_UrlReference | Primary key | Asc | ID |