Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| TicketID | INT | 10 | 0 |
|
|
|||||
| TicketStatusID | INT | 10 | 1 |
|
|
|||||
| TicketStatus | VARCHAR | 25 | √ | null |
|
|
||||
| TicketPriorityID | INT | 10 | 10 |
|
|
|||||
| TicketPriority | VARCHAR | 30 | √ | null |
|
|
||||
| TicketCategory | VARCHAR | 255 | √ | null |
|
|
||||
| TicketLevel | INT | 10 | null |
|
|
|||||
| TicketCreated | DATETIME | 19 | null |
|
|
|||||
| TicketLastContact | DATETIME | 19 | null |
|
|
|||||
| TicketDueDate | DATETIME | 19 | √ | null |
|
|
||||
| TicketContactEmail | VARCHAR | 100 | null |
|
|
|||||
| TicketSubject | VARCHAR | 255 | null |
|
|
|||||
| ClientID | INT | 10 | 0 |
|
|
|||||
| ComputerID | INT | 10 | 0 |
|
|
|||||
| NetworkDeviceID | INT | 10 | 0 |
|
|
Relationships
Close relationships within degrees of separation
