Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each ticket attachment, auto-incrementing integer |
|
| ParentID | int | 4 | √ | null |
|
|
Parent reference - Reference to parent attachment for hierarchical file organization |
|
| FileName | nvarchar | 800 | √ | null |
|
|
File name - Current file name of the attachment as stored in the system |
|
| FileSize | bigint | 8 | √ | null |
|
|
File size - Size of the attachment file in bytes for storage management |
|
| OriginalFileName | nvarchar | 600 | √ | null |
|
|
Original file name - Original name of the file as uploaded by the user |
|
| ContentType | nvarchar | 200 | √ | null |
|
|
MIME type - Content type of the file for proper handling and display |
|
| SystemFolder | nvarchar | 200 | √ | null |
|
|
Storage folder - System folder path where the file is physically stored |
|
| IsFolder | bit | 1 | √ | null |
|
|
Folder flag - Boolean indicating if this entry represents a folder rather than a file |
|
| LastWriteTime | datetime | 16,3 | √ | null |
|
|
Last write timestamp - When the file was last modified in the file system |
|
| UploadedBy | int | 4 | √ | null |
|
|
Uploader user ID - Reference to user who uploaded this attachment |
|
| UploadDate | datetime | 16,3 | √ | null |
|
|
Upload timestamp - When the attachment was uploaded to the system |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When the attachment was logically deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user ID - Reference to user who deleted this attachment |
|
| TicketID | nvarchar | 400 | √ | null |
|
|
Ticket reference - Reference to the ticket this attachment belongs to |
|
| Category | varchar | 100 | √ | null |
|
|
Attachment category - Classification category for organizing attachments |
|
| UploadedByName | varchar | 100 | √ | null |
|
|
Uploader name - Display name of the user who uploaded this attachment |
|
| CompanyId | int | 4 | √ | null |
|
|
Company reference - Reference to company for multi-tenant attachment management |
|
| IsInternal | bit | 1 | √ | null |
|
|
Internal flag - Boolean indicating if attachment is internal-only or customer-visible |