Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each custom ticket record |
|
| fkTicketID | int | 4 | √ | null |
|
|
Ticket reference - Links to the parent centralized ticket record for which this custom data applies (foreign key to CentralizedTicket.TicketID) |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Timestamp when the custom ticket record was first created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this custom ticket record (foreign key to AccessUser.UserID) |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Timestamp when the custom ticket record was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last updated by - UserID of the person who last modified this custom ticket record (foreign key to AccessUser.UserID) |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Timestamp when the custom ticket record was soft-deleted (null if active) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Centrali__40A359E3D18BFE8E | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
